# pt-table-checksum error

**URL:** <https://forums.percona.com/t/pt-table-checksum-error/3581>\
**Category:** Percona Toolkit\
**Created:** [June 30, 2014, 8:01pm UTC](https://forums.percona.com/t/pt-table-checksum-error/3581 "2014-06-30T20:01:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![robinswp](https://avatars.discourse-cdn.com/v4/letter/r/91b2a8/32.png) [@robinswp](https://forums.percona.com/u/robinswp)\
**Post date:** [June 30, 2014, 8:01pm UTC](https://forums.percona.com/t/pt-table-checksum-error/3581/1 "2014-06-30T20:01:37Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![psong](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/psong/32/16894_2.png) [@psong](https://forums.percona.com/u/psong)\
**Post date:** [July 6, 2014, 3:03am UTC](https://forums.percona.com/t/pt-table-checksum-error/3581/2 "2014-07-06T03:03:17Z")

</div>

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]](http://dev.mysql.com/doc/refman/5.6/en/replication-rules.html%5B/url%5D)
