Comment 8 for bug 918056
Revision history for this message
| Przemek (pmalkowski) wrote Re: pt-table-sync can't nibble table because MySQL chose no index | #8 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
35a32c5
(Get the code!)
I have fully reproducible case here.
To repeat the problem, load the history_master.sql table to master node, then history_slave.sql to slave node. Slave will have slightly more rows then master.
Then on master:
pt-table-checksum --databases=drupal
pt-table-sync --execute --print --replicate percona.checksums localhost
Also included full query log from pt-table-sync session as well as the tool's debug log.