pt-table-checksum fails when using murmur_hash
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
I have installed the hash (fnv,fnv1a,murmur) functions from percona-server package to MariaDB 10.0 and 10.1. They are loaded fine and seems to work as expected.
When I run pt-table-checksum (2.20 from debian and 3.0.2 from your site) however MariaDB throws a warning which pt-table-checksum does not ignore and skips the table.
pt-table-checksum --replicate sys.checksums \
--defaults-file /etc/mysql/
--databases marvin_production \
--function MURMUR_HASH \
--recursion-
h=localhost,
04-06T15:36:02 Error checksumming table marvin_
Level: Note
Code: 1105
Message: Cast to unsigned converted negative integer to it's positive complement
Query: REPLACE INTO ....
From my research it seems that CAST raises a warning when casting a negative integer to unsigned integer which pt-table-checksum detects it and skips the table.
MariaDB [(none)]> select CAST(MURMUR_
+------
| CAST(MURMUR_
+------
| 111872891684706
+------
1 row in set, 1 warning (0.00 sec)
MariaDB [(none)]> show warnings;
+------
| Level | Code | Message |
+------
| Note | 1105 | Cast to unsigned converted negative integer to it's positive complement |
+------
1 row in set (0.00 sec)
MariaDB [(none)]>
By adding 1105 => 1 to my %ignore_code it seems to work as expected.
Is this a bug or am I missing a configuration parameter for pt-table-checksum?
I suspect this affects pt-table-sync as well. Need to verify it tho.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-1420