Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-checksum can't complete

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

  • pt-table-checksum can't complete

    Hi

    I am running pt-table-checksum, I am getting some errors which I can't make sense of. What is it waiting for ?

    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain

    Many thanks

    Best Regards

    Kubilay

  • #2
    I am running into the same problem...

    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain
    Waiting to check replicas for differences: 0% 00:00 remain

    I keep seeing this in the output of pt-table-checksum. The table it is stuck on has 10 rows. The process list on the master says the checksum query has been sleeping for over an hour. There is no replication lag between master and slave. So what is it waiting on? Here is my example command:

    pt-table-checksum -u user -p pass -h masterip --set-vars innodb_lock_wait_timeout=50 --nocheck-plan --no-check-binlog-format --chunk-size-limit 100.0 --chunk-time 10.0 --nocheck-replication-filters > checksum_output.log 2> checksum_errors.log

    Comment


    • #3
      Hi,

      Can you provide pt-table-checksum version + MySQL/Percona version + full checksum output log.

      Comment

      Working...
      X