Table 'percona.checksum' doesn't exist

1

I am getting the following error after execute
pt-table-sync --user=checksum_user h=192.168.0.51 --sync-to-master --replicate percona.checksum --verbose --print

DBD::mysql::db selectall_arrayref failed: Table 'percona.checksum' doesn't exist [for Statement "SELECT db, tbl, CONCAT(db, '.', tbl) AS `table`, chunk, chunk_index, lower_boundary, upper_boundary, COALESCE(this_cnt-master_cnt, 0) AS cnt_diff, COALESCE(this_crc <> master_crc OR ISNULL(master_crc) <> ISNULL(this_crc), 0) AS crc_diff, this_cnt, master_cnt, this_crc, master_crc FROM percona.checksum WHERE master_cnt <> this_cnt OR master_crc <> this_crc OR ISNULL(master_crc) <> ISNULL(this_crc)"] at /usr/bin/pt-table-sync line 5053.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle ;host=192.168.0.51;mysql_read_default_group=client at /usr/bin/pt-table-sync line 5053.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle ;host=192.168.0.50;port=3306;mysql_read_default_group=client at /usr/bin/pt-table-sync line 5053.
[root@mysql1 ~]#

But the command pt-table-checksum does not create a table percona.checksum, it create a table percona.checksums. Is this correct? maybe some bug?

mysql> 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
mysql> show tables;
+-------------------+
| Tables_in_percona |
+-------------------+
| checksums         |
| dsns              |
+-------------------+

[root@mysql1 ~]# pt-table-checksum --version
pt-table-checksum 3.5.3
[root@mysql1 ~]#
2

can you share the pt-table-checksum command you used, I guess you used table name as checksums with an ‘s’ not checksum, Please use the same table name which you used in you pt-table-checsum command thanks

3

Hello @Solaire-Astora,

Your command says “–replicate percona.checksum”
pt-table-sync --user=checksum_user h=192.168.0.51 --sync-to-master --replicate percona.checksum --verbose --print

but “show tables” shows the table name is “checksums”

mysql> show tables;
+-------------------+
| Tables_in_percona |
+-------------------+
| checksums         |
| dsns              |
+-------------------+

So correct your command as follows and it should work.
pt-table-sync --user=checksum_user h=192.168.0.51 --sync-to-master --replicate percona.checksums --verbose --print

Thanks,
K