Critical: May be a bug in pt-table-checksum need little help in analyzing the data

this is from one of the tables checksum result on stdout
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE

05-30T17:08:11 0 1 0 1 0 0.013 xxx.xxx_test

---------------------------------------------------------------------------------------------------------------------------------------------
the result in the percona.checksums table says there is no diff for table on master as well on the slave, but there is difference in the number of rows of data in the table.

I tried different combinations and all the time the result showed as if there is no difference in the number of rows
master_cnt this_cnt actual master_cnt actual this_cnt
0 0 0 2
2 2 2 3
3 3 3 2

something like that how ever i try the result in the table for both master_cnt and this_cnt remained the same value as that of master_cnt, how ever the row count in the slave is. But in the STDOUT result set the Diff to '1' indicating the data is different in that table.

Comment

Hi, are you looking at the percona.checksum table on the master? On the master, the this_crc and master_crc would always agree with each other since they are the same thing, the same for this_cnt and master_cnt.

Please check percona.checksum on the slave server to see the difference between the slave and the master.