pt-table-checksum report error rows is wrong

Reported by lyxing on 2013-09-07
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers