pt-table-checksum reports diffs not found with pt-table-sync

Reported by Mike Benshoof on 2012-10-01
20
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona Toolkit
Undecided
Unassigned

Bug Description

Running pt-table-checksum against the master repeatedly shows different chunks out of sync on the slave that are not found by pt-table-sync.

Details:

- Table has timestamp column with ON UPDATE CURRENT_TIMESTAMP
- Updates to table are done via an explicit transaction
- Max timestamp from the ON UPDATE field generally matches the ts column from the checksum table (give or take a second) for the out of sync chunks
- tx_isolation is REPEATABLE-READ on master/slave

tags: added: pt-table-checksum tx-isolation wrong-output
Changed in percona-toolkit:
status: New → Triaged
importance: Undecided → High
assignee: nobody → Daniel Nichter (daniel-nichter)
tags: added: percona-26500
Daniel Nichter (daniel-nichter) wrote :

Michael, have you been able to produce a test case for this? Or, was I supposed to to something and forgot? :-)

Daniel Nichter (daniel-nichter) wrote :

Could this be related to bug 1080765?

Daniel Nichter (daniel-nichter) wrote :

I'm going to bet that this is related to bug 1080765, and since we probably don't have access to the original machines on which this was happening, I'll close this issue.

Changed in percona-toolkit:
status: Triaged → Invalid
assignee: Daniel Nichter (daniel-nichter) → nobody
importance: High → Undecided
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers