Hi all,
Please help, I am not able to make pt-table-checksum tool work.
I have a simple master-slave environment and I am trying to check data consistency between them.
I am issuing the next command
pt-table-checksum --user=xxxxxx --password=xxxxx
And I get the next error message
01-09T11:54:08 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 9148.
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.
[root@hades admin]# [SSH] ERROR: An existing connection was forcibly closed by the remote host.
[SSH] FAIL: Write failed: An existing connection was forcibly closed by the remote host.
Our master is a cluster running under MariaDB Galera 10 with binlog format = ROW and I cannot change that because is mandatory as you can read here [url]https://mariadb.com/kb/en/mariadb/documentation/managing-mariadb/replication/galera/getting-started-with-mariadb-galera-cluster/[/url]
I have been googling how to run this command without any success. Some people recommend to disable the check binlog format with the --nocheck-binlog-format, but that didn t do nothing
[# pt-table-checksum --user=xxxxx --password=xxxxxx --nocheck-binlog-format
01-09T12:52:26 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 9148.
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.
Before giving up, I would like to know if anybody has faced the same issue and how they solved it?
Thanks
More info
I am using Percona Toolkit version 2.2.12
Redhat 6.5
MariaDB 10