Comment 0 for bug 1316863

- pt-table-checksum --ask-pass --recursion-method=cluster
- 2.2.7
- pxc 5.6.15

https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1263991

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'
mysql>

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.