Comment 1 for bug 1250450

Revision history for this message
Jaime Sicam (jssicam) wrote :

Tested on PXC 5.6.20 and pt-table-sync 2.2.11:

Created two PXC clusters where one node of a cluster is a asynchronous slave of one node on the other cluster

[root@localhost ~]# pt-table-sync --execute --sync-to-master h=192.168.1.97
Deadlock found when trying to get lock; try restarting transaction at line 6143 while doing employees.employees on 192.168.1.97

Error log on Master:
2014-11-14 04:40:29 3962 [Warning] WSREP: SQL statement was ineffective, THD: 11, buf: 667
QUERY: commit
 => Skipping replication