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

  1. Bug #1674266
  2. Comment #2

Comment 2 for bug 1674266

Revision history for this message
Jericho Rivera (jericho-rivera) wrote :

Also affects pt-3.0.1

03-21T07:09:05 Error executing EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `f1`, `f2`, CONCAT(ISNULL(`f1`), ISNULL(`f2`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `test`.`cp1251` /*explain checksum table*/: DBD::mysql::st execute failed: Illegal mix of collations for operation 'concat_ws' [for Statement "EXPLAIN SELECT COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `f1`, `f2`, CONCAT(ISNULL(`f1`), ISNULL(`f2`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `test`.`cp1251` /*explain checksum table*/"] at /usr/bin/pt-table-checksum line 11352.

03-21T07:09:05 Error checksumming table test.cp1251: Error executing checksum query: DBD::mysql::st execute failed: Illegal mix of collations for operation 'concat_ws' [for Statement "REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `f1`, `f2`, CONCAT(ISNULL(`f1`), ISNULL(`f2`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `test`.`cp1251` /*checksum table*/" with ParamValues: 0='test', 1='cp1251', 2=1, 3=undef, 4=undef, 5=undef] at /usr/bin/pt-table-checksum line 10742.