Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1059680: pt-table-checksum reports diffs not found with pt-table-sync

Description

**Reported in Launchpad by Mike Benshoof last update 25-03-2013 15:36:24

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

Environment

None

Smart Checklist

Activity

lpjirasync January 24, 2018 at 6:59 PM

**Comment from Launchpad by: Daniel Nichter on: 25-03-2013 15:36:01

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.

lpjirasync January 24, 2018 at 6:59 PM

**Comment from Launchpad by: Daniel Nichter on: 07-01-2013 21:23:42

Could this be related to bug 1080765?

lpjirasync January 24, 2018 at 6:59 PM

**Comment from Launchpad by: Daniel Nichter on: 13-10-2012 17:01:56

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

Not a Bug

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 6:58 PM
Updated February 4, 2018 at 2:05 AM
Resolved January 24, 2018 at 6:59 PM