Percona toolkit execution failure

MySQL & MariaDB Other MySQL® Questions
,
1

The attempts to run Percona toolkit programs are failing with following error, for example:
$ pt-heartbeat …

install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 37) line 3, line 1.

at /usr/bin/pt-heartbeat line 2964.
$

That happens on:
OS: AlmaLinux 9
Perl: This is perl 5, version 32, subversion 1 (v5.32.1) built for x86_64-linux-thread-multi
DBM: perl-DBD-MySQL.x86_64 1:4.050-4.el9 @pdps-8.0.36-release-x86_64
Percona toolkit: pt-heartbeat 3.6.0

Can anybody please advise on this matter?
With regards
Leszek Kotzian

2

Hello @Leszek_Kotzian,
AlmaLinux is not one of our supported operating systems. However, it looks like you need to install perl DBD::mysql from our repo, and update dbd::mysql to the latest versions. This is not an issue with pt-heartbeat, but an issue with your perl install.

3

I’m having the same issue with Alma 9, and using the version of the perl module from the pt release repository: perl-DBD-MySQL-1:4.050-5.el9.x86_64

4

I’m also having the same issue with Alma 9. If I use the version of the module from the Percona-Toolkit repository, it fails. If I use the stock alma 9 appstream version, it works.

]# yum install https://repo.almalinux.org/almalinux/9/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.050-13.el9.x86_64.rpm
Repository 'Percona-Toolkit' is missing name in configuration, using id.
Last metadata expiration check: 1:25:29 ago on Fri 06 Dec 2024 08:25:07 AM EST.
perl-DBD-MySQL-4.050-13.el9.x86_64.rpm                                                             2.2 MB/s | 145 kB     00:00
Dependencies resolved.
===================================================================================================================================
 Package                           Architecture              Version                         Repository                       Size
===================================================================================================================================
Downgrading:
 perl-DBD-MySQL                    x86_64                    4.050-13.el9                    @commandline                    145 k

Transaction Summary
===================================================================================================================================
Downgrade  1 Package

# pt-show-grants
-- Grants dumped by pt-show-grants
-- Dumped from server Localhost via UNIX socket, MySQL 11.4.4-MariaDB-log at 2024-12-06 09:51:11