pt-table-checksum error at runtime DBD::mysql::dr::imp_data_size

[Peter Sylvester]

Command used:
pt-table-checksum --databases=<db here> --user=psylvester --password=<password here>

Output:
Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.
Had to create DBD::mysql::db::imp_data_size unexpectedly at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 1190.
04-15T21:28:56 Undefined subroutine &DBD::mysql::db::_login called at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/mysql.pm line 149.

Version:
pt-table-checksum 2.2.7

I ran the installation seperately on a pair of VMs and did not have the issue listed above. This only appears to be happening on our production server which is running CentOS 5.10

[Muhammad Irfan (muhammad-irfan)]

I can't reproduce this issue. To me it's more like an issue with perl-DBD-MySQL
Probably wrong rpm installed or not installed accordingly 32/64 bit architecture for perl-DBD-MySQL.
How did you installed perl dbd-mysql module via yum or rpm or manually ? Can you try to remove/install dbd-mysql and check if it works.

 [root@centos59]# /root/downloads/percona-toolkit-2.2.7/bin/pt-table-checksum --version
pt-table-checksum 2.2.7
[root@centos59]# /root/downloads/percona-toolkit-2.2.7/bin/pt-table-checksum --databases=test --user=msandbox --password=msandbox --socket=/tmp/mysql_sandbox20484.sock
Cannot connect to h=127.0.0.1,p=...,u=msandbox
Diffs cannot be detected because no slaves were found. Please read the --recursion-method documentation for information.
            TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
08-28T12:16:49 0 0 4079 4 0 0.240 test.City
08-28T12:16:49 0 0 239 1 0 0.104 test.Country
08-28T12:16:49 0 0 984 1 0 0.009 test.CountryLanguage
08-28T12:16:49 0 0 9738 1 0 0.080 test.flaggedrevs
08-28T12:16:49 0 0 2 1 0 0.043 test.messages
08-28T12:16:49 0 0 0 1 0 0.013 test.messages_innodb

[Launchpad Janitor (janitor)]

[Expired for Percona Toolkit because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1219