Skip to:
pt-table-checksum will emit a warning when connecting to a replica and its binlog_format is ROW, the tool will try to set it to STATEMENT - which does not make sense given the limitation of multi-tiered replication.
See report below:
https://jira.percona.com/browse/PT-638
https://jira.percona.com/browse/PT-1483
Given this knowledge, we should simply convert the error like below into an meaningful warning.
For example:
There should be no need to attemp SET SESSION on the replica since it will be noop anyway.
pt-table-checksum will emit a warning when connecting to a replica and its binlog_format is ROW, the tool will try to set it to STATEMENT - which does not make sense given the limitation of multi-tiered replication.
See report below:
https://jira.percona.com/browse/PT-638
https://jira.percona.com/browse/PT-1483
Given this knowledge, we should simply convert the error like below into an meaningful warning.
For example:
There should be no need to attemp SET SESSION on the replica since it will be noop anyway.