Affects Version/s: None
Fix Version/s: None
**Reported in Launchpad by Ben Mildren last update 03-09-2014 17:01:55
- pt-table-checksum --recursion-method=cluster
- pxc 5.6.15
With PXC 5.6 the session binlog_format cannot be changed to STATEMENT:
mysql> /!50108 SET @@binlog_format := 'STATEMENT'/;
ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'
Therefore pt-table-checksum fails with the message:
Failed to /!50108 SET @@binlog_format := 'STATEMENT'/: DBD::mysql::db do failed: Variable 'binlog_format' can't be set to the value of 'STATEMENT' [for Statement "/*!50108 SET @@binlog_format := 'STATEMENT'*/"] at /usr/bin/pt-table-checksum line 9101, <STDIN> line 1.
This tool requires binlog_format=STATEMENT, but the current binlog_format is set to ROW and an error occurred while attempting to change it. If running MySQL 5.1.29 or newer, setting binlog_format requires the SUPER privilege. You will need to manually set binlog_format to 'STATEMENT' before running this tool.
There doesn't seem to be any workaround for this using the current options.