pt-table-checksum checksum tablename extra characters
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Carlos Salguero |
Bug Description
When I run pt-table-checksum with the following parameters
pt-table-checksum --replicate=
The table in the percona schema is getting created with a wrong name. This is a new as I have used pt-table-checksum with these servers and these databases for some time.
The process creates a table percona.`checksums `. Yes the A and an empty character, it doesn't appear to be a space as typing a space into a commandline sql statement won't find the table
The server is running binlog_format = 'MIXED';
Server is Redhat 6.6
MariaDB 10.1.13
Percona tools 2.2.19
Tool appears to go about its business checksumming
I have built a master slave test case on an AWS environment using two RedHat 6.5 AMI's I installed the same version of tools and database and employee database and set up replication
The odd characters are there. I then upgraded the entire stack to Redhat 6.8 and MariaDB to 10.1.19 and still saw the problem.
When I rename the table pt-table-sync cannot find the odd name table and needs to be renamed.
tags: | added: pt-table-checksum |
Changed in percona-toolkit: | |
status: | Incomplete → New |
Cannot reproduce. percona. checksums --ignore-databases mysql,sys --no-check- binlog- format --user=msandbox --password=msandbox -h 127.0.0.1 --port=12345
pt-table-checksum --replicate=
then mysql --user=msandbox --password=msandbox --host=127.0.0.1 --port=12345 ------- ------- -----+- ------- ------- ------+ ------- ------- -----+- ------- ------- ------+ conversions | | compile_ machine | x86_64 | malloc_ library | bundled jemalloc | ------- ------- -----+- ------- ------- ------+
show variables like '%version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.19-67.0 |
| protocol_version | 10 |
| slave_type_
| version | 10.0.13-MariaDB-log |
| version_comment | MariaDB Server |
| version_
| version_compile_os | Linux |
| version_
+------
8 rows in set (0.00 sec)
show tables from percona; ------- ------+ ------- ------+ ------- ------+
+------
| Tables_in_percona |
+------
| checksums |
+------
1 row in set (0.00 sec)