pt-table-checksum 3.0.4 reports no differences for master binlog_format=row and --no-check-binlog-format

Bug #1715801 reported by Nickolay Ihalainen on 2017-09-08
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Undecided
Unassigned

Bug Description

create table t(id int, c varchar(255)) engine=innodb;
insert into t values (1,"master");

on slave:
update test.t set c='s1' where id=1;

WORKS:
root@b89c0a091ab4:/# pt-table-checksum --recursion-method=hosts --create-replicate-table h=m,P=3306,u=root,p=root --ignore-databases mysql,sys
            TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-08T04:54:48 0 1 1 1 0 0.364 test.t

NO DIFFERENCE REPORTED:
root@b89c0a091ab4:/# pt-table-checksum --recursion-method=hosts --create-replicate-table h=m,P=3306,u=root,p=root --ignore-databases mysql --no-check-binlog-format
            TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-08T04:55:34 0 0 6 1 0 0.351 sys.sys_config
09-08T04:55:34 0 0 1 1 0 0.303 test.t

WORKAROUND - add binlog_format=statement with set-vars:
root@b89c0a091ab4:/# pt-table-checksum --recursion-method=hosts --create-replicate-table h=m,P=3306,u=root,p=root --set-vars binlog_format=statement --ignore-databases mysql --no-check-binlog-format
            TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-08T05:03:40 0 0 6 1 0 0.325 sys.sys_config
09-08T05:03:40 0 1 1 1 0 0.328 test.t

Changed in percona-toolkit:
status: New → Confirmed
tags: added: i204706
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers