Affects Version/s: None
Fix Version/s: 3.0.11
I am testing pt-table-checksum and this test is failing: t/pt-table-checksum/ignore_columns.t
If you have a sandbox with at least a master and a slave, you can reproduce the problem as follow:
I am going to assume the master is running on port 12345 and the slave is at port 12346
On the master, run:
So, on the master and on the slave, you will have these rows:
and now on the slave you will have the column c empty on all rows:
The problem starts here:
If you run pt-table-checksum, checksumming all columns, produces this output
which is correct.
Then re-run pt-table-checksum ignoring column c:
As you can see, it says DIFFS 1 which is incorrect since the column c was ignored and all other columns have the same values.
If you run again
it shows the correct value, DIFFS 0 but if you re-run pt-table-checksum WITHOUT ignoring the column c, the result will be invalid again, until you re-run the 2 twice with or without --ignore-columns c
It seems like the first time is somehow getting an old value and re-running the program it gets the correct values.