pt-table-checksum got error with gtid
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
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=
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=
When @@GLOBAL.
Table is InnoDB storage engine.
3.third error
pt-table-checksum -uxxxxx -pxxxxx -hxxxxxx -Pxxxxx --replicate=
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.
tags: | added: pt-table-sync |
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.