pt-table-checksum 3.0.4 reports no differences for master binlog_format=row and --no-check-binlog-format
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@b89c0a091a
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@b89c0a091a
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_
root@b89c0a091a
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 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-1443