pt-table-checksum checksum tablename extra characters

[Peter McLarty]

When I run pt-table-checksum with the following parameters

pt-table-checksum --replicate=percona.checksums  --ignore-databases mysql,sys --no-check-binlog-format --user=ptuser --password=<pwd> -hmasterhostname

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.

[Carlos Salguero (carlos-salguero)]

Cannot reproduce.
pt-table-checksum --replicate=percona.checksums --ignore-databases mysql,sys --no-check-binlog-format --user=msandbox --password=msandbox -h 127.0.0.1 --port=12345

then mysql --user=msandbox --password=msandbox --host=127.0.0.1 --port=12345
show variables like '%version%';
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| innodb_version | 5.6.19-67.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 10.0.13-MariaDB-log |
| version_comment | MariaDB Server |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_malloc_library | bundled jemalloc |
+-------------------------+---------------------+
8 rows in set (0.00 sec)

show tables from percona;
+-------------------+
| Tables_in_percona |
+-------------------+
| checksums |
+-------------------+
1 row in set (0.00 sec)

[Peter McLarty (peter-mclarty)]

AWS testbed
Linux ip-172-31-14-91.ap-southeast-2.compute.internal 2.6.32-642.11.1.el6.x86_64 #1 SMP Wed Oct 26 10:25:23 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux

+-------------------------+---------------------------------+
| Variable_name | Value |
+-------------------------+---------------------------------+
| innodb_version | 5.6.32-79.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 10.1.19-MariaDB |
| version_comment | MariaDB Server |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_malloc_library | system jemalloc |
| version_ssl_library | OpenSSL 1.0.1e-fips 11 Feb 2013 |
| wsrep_patch_version | wsrep_25.16 |
+-------------------------+---------------------------------+

MariaDB [(none)]> use percona;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [percona]> show tables;
+-------------------+
| Tables_in_percona |
+-------------------+
| checksums  |
+-------------------+
1 row in set (0.00 sec)

[root@ip-172-31-25-91 ~]# perl -MDBD::mysql\ 9999
DBD::mysql version 9999 required--this is only version 4.013.
BEGIN failed--compilation aborted.

Only thing seemingly in common is that DBD::mysql is the same version across all systems

MariaDB [(none)]> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

Production Host with issue

MariaDB [(none)]> show variables like '%version%';
+-------------------------+---------------------------------+
| Variable_name | Value |
+-------------------------+---------------------------------+
| innodb_version | 5.6.28-76.1 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 10.1.13-MariaDB |
| version_comment | MariaDB Server |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_malloc_library | system jemalloc |
| version_ssl_library | OpenSSL 1.0.1e-fips 11 F...

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1391