Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1224

LP #1316863: pt-table-checksum doesn't work on pxc 5.6

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Ben Mildren last update 03-09-2014 17:01:55

      • pt-table-checksum --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.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: