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
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Confirmed
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
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1443

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.