pt-table-checksum error

Polyglot Projects Percona Toolkit
1

Hi all,

I faced a strange problem while running pt-table-checksum:

root@mainserver /home/www> pt-table-checksum h=‘127.0.0.1’,u=‘checksums’,p=‘mycheck654321’,P=3306 -d m_xinhui_mall --nocheck-replication-filters --replicate=test.checksums --recursion-method=hosts
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…
Waiting for the --replicate table to replicate to ip-172-31-25-122…

…

I searched on google, cannot find any posts about this error.

2

Hi there,

The pt-table-checksum tool monitors the replica and pauses when the replica falls behind, replication stopped, etc. Looks like the tool is waiting for the test.checksums table to be replicated to a replica. Was there replication error on the slave? Run “SHOW SLAVE STATUS\G” to find that out.

Also please check the binlog filter(binlog-do-db, binlog-ignore-db) on the master’s my.cnf file and replication filter(replicate-do-db, replicate-ignore-db, replicate-wild-do-table, replicate-wild-ignore-table) on the slave’s my.cnf file to make sure that replication on test db is properly enabled. Please refer to the documentation for details:

[url]http://dev.mysql.com/doc/refman/5.6/en/replication-rules.html[/url]