Percona-Server-shared-compat required for pt-deadlock-logger

[Keith Murphy]

We recently upgraded from Percona-Server 5.1 to 5.5. I noticed today that pt-deadlock-logger was not running. We have it deployed/daemonized to run every 30 seconds. On every server it was not running. Trying to restart it produce the following:

# pt-deadlock-logger --create-dest-table --dest D=admin,t=deadlocks h=127.0.0.1
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.
Undefined subroutine &DBD::mysql::db::_login called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBD/mysql.pm line 140.
#

This error seemed to indicate that authentication was failing however the users on the systems didn't change.

After a bit of thought i realized that previously I had the shared-compat package installed with Percona Server 5.1 and only installed the shared package with 5.5. Installing the shared-package resolved the issue.

Apparently something in the shared-compatability package (a libmysqlclient i assume) is required for pt-deadlock-logger. If this is true, then the shared-compatability package should be a requirement for installation of the toolkit.

[Raghavendra D Prabhu (raghavendra-prabhu)]

How did you install percona-toolkit? If you are using the files
directly then you can face this issue.

The reason being, the version of perl-DBD-MySQL you are having
has dependencies which can be satisfied by
Percona-Server-shared-51 or Percona-Server-shared-compat for
older versions of DBD, Percona-Server-shared-55 for newer
versions.

[Daniel Nichter (daniel-nichter)]

Our packaging has changed a lot over this year. I bet this is fixed now, so I'm going to close this bug. If not, please reply and we'll re-open it.

[Shahriyar Rzayev (rzayev-sehriyar)]

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