Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
pt-table-checksum gives error CRC32 never needs BIT_XOR optimization
General
Escalation
General
Escalation
Description
MariaDB database upgraded to version 10.3
pt-table-checksum --replicate=percona.checksums --no-check-binlog-format 'h=lnc7160.homedepot.com,P=3306,u=pt_check_user,p=*********' Checking if all tables can be checksummed ... Starting checksum ... CRC32 never needs BIT_XOR optimization at /usr/bin/pt-table-checksum line 6165.
[mysql@lnc7160 ~]$ mysql --version mysql Ver 15.1 Distrib 10.3.5-MariaDB, for Linux (x86_64) using readline 5.1
MariaDB support told : crc32() in 10.2 returns unsigned LONGLONG, whereas in 10.3 it returns an unsigned LONG. That this causes the percona tool to break is a percona problem.
Environment
None
Attachments
2
27 Apr 2020, 08:41 AM
26 Jun 2018, 11:06 AM
Smart Checklist
Activity
Show:
Michael Bladowski April 27, 2020 at 10:12 AM
this issue now is older than 2 years, no one cares... I don´t use it any longer.....
Volker Klasen April 27, 2020 at 8:43 AM
I just attached a slightly different patch for this issue. There was already a mapping from crc_type 'bigint' to 'int', so I also map 'integer' to 'int'.
But independent of the patch itself, it would be really nice to get a solution released. We currently have to patch our deployments manually.
Cheers,
Volker
Moritz Lenz August 29, 2019 at 7:02 AM
For the record, you can work around this by using the option
--function MD5
(which might be a bit slower than CRC32, since it's a cryptographic hash function).
Thomas Rohrer July 26, 2019 at 1:17 PM
I looking forward to release. We need monitor our 10.3 instances.
Michael Bladowski May 6, 2019 at 9:46 AM
Eduardo Casarero: can you please let us know your plans ? thanks !
MariaDB database upgraded to version 10.3
pt-table-checksum --replicate=percona.checksums --no-check-binlog-format 'h=lnc7160.homedepot.com,P=3306,u=pt_check_user,p=*********'
Checking if all tables can be checksummed ...
Starting checksum ...
CRC32 never needs BIT_XOR optimization at /usr/bin/pt-table-checksum line 6165.
[mysql@lnc7160 ~]$ pt-table-checksum --version
pt-table-checksum 3.0.8
[mysql@lnc7160 ~]$ mysql --version
mysql Ver 15.1 Distrib 10.3.5-MariaDB, for Linux (x86_64) using readline 5.1
MariaDB support told : crc32() in 10.2 returns unsigned LONGLONG, whereas in 10.3 it returns an unsigned LONG. That this causes the percona tool to break is a percona problem.