Not the answer you need?
Register and ask your own question!

pt-table-checksum error

robinswprobinswp EntrantCurrent User Role Beginner
Hi all,

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

[email protected] /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.

Comments

  • psongpsong Contributor Inactive User Role Beginner
    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:

    http://dev.mysql.com/doc/refman/5.6/en/replication-rules.html
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.