pt-table-checksum got error with gtid

[Hu Zilin]

1. firts error：
$ mysqld --version
mysqld Ver 5.6.26 for linux-glibc2.5 on x86_64 (MySQL Community Server (GPL))

$ pt-table-checksum --version
pt-table-checksum 2.2.16

$ pt-table-checksum -uxxxx -pxxxxx -hxxxxxx -Pxxxxx --replicate=test.checksums --no-check-binlog-format --recursion-method=processlist --no-check-replication-filters
Waiting to check replicas for differences: 0% 00:00 remain
Waiting to check replicas for differences: 0% 00:00 remain
Waiting to check replicas for differences: 0% 00:00 remain
Waiting to check replicas for differences: 0% 00:00 remain
Waiting to check replicas for differences: 0% 00:00 remain
Waiting to check replicas for differences: 0% 00:00 remain

pt-table-checksum still print this.

2.second error
$./bin/mysqld --version
./bin/mysqld Ver 5.6.23 for linux-glibc2.5 on x86_64 (MySQL Community Server (GPL))

$pt-table-sync --execute --replicate=test.checksums h='xxxxx',u='xxxxx',p='xxxxxx',P=3306

When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1. [for Statement "CREATE TEMPORARY TABLE `xxxxx`.`__xxxxxx` ( `id` varchar(100) NOT NULL) ENGINE=MEMORY"] at line 4027 while doing xxxxxxx.xxxxxxxx on xxxxxx

Table is InnoDB storage engine.

3.third error
pt-table-checksum -uxxxxx -pxxxxx -hxxxxxx -Pxxxxx --replicate=test.checksums --no-check-binlog-format --recursion-method=processlist
Waiting for the --replicate table to replicate to cluster3...
Waiting for the --replicate table to replicate to cluster3...

pt-table-checksum still print this.

This is my test machine,and no load on it.
I connect this server's slave,and found test.checksums table has been replicated.

Please indicate what I made a mistake.

[Thomas Kane (tkane-p)]

I get the second error as well, I have oracle mysql 5.6.26 and got this error with versions 2.2.15 and 2.2.17 of the toolkit.

It appears pt-table-sync will try to create the temporary table if the character set is not latin1, but for some reason I only get this error with one table.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1341