Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-checksum error

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum error

    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=33 06 -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:

    http://dev.mysql.com/doc/refman/5.6/...ion-rules.html

    Comment

    Working...
    X