Comment 4 for bug 1269877

Revision history for this message
John Fowler (jfowler-n) wrote : RE: [Bug 1269877] Re: pt-duplicate-key-checker fails at line 891

Hi Jericho,

Thank you for getting back to me. I think we'll probably need to install the package you identified in order to correct the problem we're encountering.

One more question: Does the Percona Toolkit work with community, Remi, and Enterprise editions of MySQL?

Thank you,
John

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jericho Rivera
Sent: Tuesday, January 21, 2014 10:33 PM
To: Fowler John
Subject: [Bug 1269877] Re: pt-duplicate-key-checker fails at line 891

So I tested this locally on a Centos VM and got this:

[root@vagrant-centos64 /]# pt-duplicate-key-checker --database=mysql
install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 20) line 3.

 at /usr/bin/pt-duplicate-key-checker line 891

The test environment:
MySQL-server-5.5.29-2.el6.x86_64
percona-toolkit-2.2.6-1

Installing MySQL Shared Compat somehow fixed it:
yum localinstall MySQL-shared-compat-5.5.29-2.el6.x86_64.rpm
...
Installed:
  MySQL-shared-compat.x86_64 0:5.5.29-2.el6

Complete!
[root@vagrant-centos64 /]# pt-duplicate-key-checker --database=mysql

# A software update is available:
# * The current version for MySQL Community Server (GPL) is 5.5.35.

# ########################################################################
# Summary of indexes
# ########################################################################

# Total Indexes 29

Ideally installation of these packages would have to be through "yum install packagename" so that all package depencies will be installed as well.

Are you installing these packages running "yum localinstall packagename.rpm" or "rpm -ivh packagename.rpm"?

Unfortunately, I have no way of testing this on Red Hat Enterprise Linux or MySQL Enterprise Server.

--
You received this bug notification because you are subscribed to the bug report.
https://bugs.launchpad.net/bugs/1269877

Title:
  pt-duplicate-key-checker fails at line 891

Status in Percona Toolkit:
  New

Bug description:
  When I run the utility pt-duplicate-key-checker and used the --databases option...
  # pt-duplicate-key-checker --databases=mem
   I get the following error:
  install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
  Compilation failed in require at (eval 7) line 3.

   at /usr/bin/pt-duplicate-key-checker line 891

  I've tried using other options but they all result in the same error.

  Our environment is as follows:
  Red Hat Enterprise Linux Server release 6.3
  MySQL 5.5.29-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
  percona-toolkit-2.2.6-1.noarch.rpm
  perl-DBD-MySQL-4.013-3.el6.x86_64.rpm

  When I installed the toolkit there was a dependency requirement for
  perl and I then included the above rpm in the installation.

  Please help.
  Thanks!

To manage notifications about this bug go to:
https://bugs.launchpad.net/percona-toolkit/+bug/1269877/+subscriptions