# pt-table-checksum can't complete **URL:** \ **Category:** Percona Toolkit\ **Created:** [March 6, 2014, 9:07am UTC](https://forums.percona.com/t/pt-table-checksum-cant-complete/3318 "2014-03-06T09:07:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![kubilay](https://avatars.discourse-cdn.com/v4/letter/k/0ea827/32.png) [@kubilay](https://forums.percona.com/u/kubilay)\ **Post date:** [March 6, 2014, 9:07am UTC](https://forums.percona.com/t/pt-table-checksum-cant-complete/3318/1 "2014-03-06T09:07:18Z")
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 ---
**Author:** ![bexicusmaximus](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@bexicusmaximus](https://forums.percona.com/u/bexicusmaximus)\ **Post date:** [March 24, 2014, 12:39pm UTC](https://forums.percona.com/t/pt-table-checksum-cant-complete/3318/2 "2014-03-24T12:39:07Z")
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 ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [March 25, 2014, 4:59am UTC](https://forums.percona.com/t/pt-table-checksum-cant-complete/3318/3 "2014-03-25T04:59:16Z")
Hi, Can you provide pt-table-checksum version + MySQL/Percona version + full checksum output log. ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [March 26, 2015, 7:50am UTC](https://forums.percona.com/t/pt-table-checksum-cant-complete/3318/4 "2015-03-26T07:50:47Z")
I have the same problem pt-table-checksum 2.2.13 # mysql --version mysql Ver 14.14 Distrib 5.6.21-70.1, for debian-linux-gnu (x86\_64) using EditLine wrapper pt-table-checksum --no-check-binlog-format --databases my\_xx --tables transfer --nocheck-replication-filters --recursion-method=processlist --no-check-slave-tables Cannot connect to h=10.25.3.69 Cannot connect to h=10.25.7.58 Replica lag is 75 seconds on 53.xx.xx. Waiting. Replica lag is 49 seconds on 53.xx.xx. Waiting. Replica lag is 79 seconds on 53.xx.xx. Waiting. Replica lag is 109 seconds on 53.xx.xx. Waiting. Replica lag is 73 seconds on 53.xx.xx. Waiting. Replica lag is 31 seconds on 53.xx.xx. Waiting. Replica lag is 4 seconds on 53.xx.xx. Waiting. Checksumming my\_xx.transfer: 0% 14:05:58 remain Checksumming my\_xx.transfer: 13% 25:06 remain Checksumming my\_xx.transfer: 27% 12:12 remain Checksumming my\_xx.transfer: 42% 06:58 remain Checksumming my\_xx.transfer: 56% 04:17 remain Checksumming my\_xx.transfer: 72% 02:21 remain Checksumming my\_xx.transfer: 94% 00:22 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 ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [April 2, 2015, 6:59am UTC](https://forums.percona.com/t/pt-table-checksum-cant-complete/3318/5 "2015-04-02T06:59:04Z")
@PavelVD, make sure to check if you have database my\_xx and table transfer on the slaves. Schema and table differences The tool presumes that schemas and tables are identical on the master and all replicas. Replication will break if, for example, a replica does not have a schema that exists on the master (and that schema is checksummed), or if the structure of a table on a replica is different than on the master. ---
**Author:** ![Davide\_Spagnoli](https://avatars.discourse-cdn.com/v4/letter/d/ecb155/32.png) [@Davide\_Spagnoli](https://forums.percona.com/u/Davide_Spagnoli)\ **Post date:** [April 30, 2015, 4:44am UTC](https://forums.percona.com/t/pt-table-checksum-cant-complete/3318/6 "2015-04-30T04:44:49Z")
I ran into the same problem testing if after modifying a row on the slave (for testing purposes of course!)… it was simply waiting for me to commit the transaction!!!