pt-table-checksum report error rows is wrong
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.
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 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-1150