Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1427552
  2. Comment #2

Comment 2 for bug 1427552

Revision history for this message
monty solomon (monty+launchpad) wrote :

We experience a similar issue.

execute failed: Illegal mix of collations for operation 'concat_ws' at /usr/bin/pt-table-checksum line 11268.

execute failed: Illegal mix of collations for operation 'concat_ws' at /usr/bin/pt-table-checksum line 10658.

The table has DEFAULT CHARSET=latin1 and the table contains some character columns that use latin1, utf8, and usc2. The PRIMARY KEY column and another column use CHARACTER SET utf8. Another column uses CHARACTER SET ucs2.

pt-table-checksum 2.2.15
mysql Ver 14.14 Distrib 5.6.25-73.1, for Linux (x86_64) using 6.0
Server version: 5.6.25-73.1-log Percona Server (GPL), Release 73.1, Revision 07b797f
Linux 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
CentOS release 6.5 (Final)