pt-table-checksum report error rows is wrong

Bug #1222084 reported by lyxing
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Triaged
Undecided
Unassigned

Bug Description

When i used pt-table-checksume to check slave datas,it report :
           TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-07T09:30:50 0 2 298722 13 0 3.529 usersxxxx.userxxxx_0

But,the table has 298732 rows in fact.

And i find that the table has two wrong rows that pt-table-sync had not printed with --print option.The rows have a column with smallint type.the column's values are 32767 on master and 65532 on slave.The slave's value are wrong,but pt-table-sync did not found them.The value on slave are wrong,because they are out of range.

On Master:
7137780 0 0 0 0 0 0 0 0 32767 15 0 7 0 4
7287320 0 1 0 0 0 0 0 0 32767 14 1 0 0 0

On slave:
7137780 0 0 0 0 0 0 0 0 65532 15 0 7 0 4
7287320 0 1 0 0 0 0 0 0 65532 14 1 0 0 0

tags: added: pt-table-checksum
Changed in percona-toolkit:
status: New → Triaged
summary: - pt-table-checksume report error rows is wrong
+ pt-table-checksum report error rows is wrong
Changed in percona-toolkit:
milestone: none → 2.2.6
Changed in percona-toolkit:
milestone: 2.2.6 → none
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1150

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.