Pt-onine-Schema-change failing to connect after Rocky 8 Upgrade

MySQL & MariaDB Percona Distribution for MySQL
,
1

Hi,
Earlier we used pt-online-schema-change 3.2.0 which has perl 5.16.3 and perl DBD version of 4.0.46, It worked fine.
But later when we upgraded all our nodes or VMs to Rocky build , percona started failing upon verifying the packages we found that perl version is 5.26.3 and perl DBD version is 4.0.23.
and the error is
Cannot connect to MySQL: DBI connect('schema_name;host=;mysql_ssl=1;mysql_read_default_group=client','root',...) failed: SSL connection error: self-signed certificate in certificate chain at /usr/local/bin/pt-online-schema-change line 2345.
Later we tried upgrading pt-online-schema-change to the latest version but it still has the same version of Perl 5.26.3.
Please help here.

2

Please upgrade your DBD to the latest version. It is available in Percona’s repos.

3

Do we have any compatibility matrix of Perl and Perl DBD versions?
We currently have Perl 5.0.26 and Perl DBD 4.0.46
From the percona repo, we found that Perl DBD 4.0.50 is the latest version(Percona Repo), so trying it now.

4

We are getting the error when we try to upgrade it to the latest perl DBD 4.0.50 version

Error:
 Problem: conflicting requests
  - package perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline does not have a compatible architecture
  - nothing provides ld-linux-x86-64.so.2()(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides ld-linux-x86-64.so.2(GLIBC_2.3)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides libc.so.6(GLIBC_2.14)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides libc.so.6(GLIBC_2.2.5)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides libc.so.6(GLIBC_2.3)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides libc.so.6(GLIBC_2.3.4)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides libc.so.6(GLIBC_2.4)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides libdl.so.2(GLIBC_2.2.5)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
  - nothing provides libpthread.so.0(GLIBC_2.2.5)(64bit) needed by perl-DBD-MySQL-1:4.050-4.el8.x86_64 from @commandline
---- End output of "bash"  ----
Ran "bash"  returned 1
5

Are you on ARM or i386?

6

ARM

bash-4.4$ cat /etc/os-release
NAME="Rocky Linux"
VERSION="8.9 (Green Obsidian)"
ID="rocky"
ID_LIKE="rhel centos fedora"
VERSION_ID="8.9"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Rocky Linux 8.9 (Green Obsidian)"
ANSI_COLOR="0;32"
LOGO="fedora-logo-icon"
CPE_NAME="cpe:/o:rocky:rocky:8:GA"
HOME_URL="https://rockylinux.org/"
BUG_REPORT_URL="https://bugs.rockylinux.org/"
SUPPORT_END="2029-05-31"
ROCKY_SUPPORT_PRODUCT="Rocky-Linux-8"
ROCKY_SUPPORT_PRODUCT_VERSION="8.9"
REDHAT_SUPPORT_PRODUCT="Rocky Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="8.9"
bash-4.4$ arch
aarch64
bash-4.4$
7

Unfortunately we do not yet fully support ARM for all of our software, which is why you are seeing that error message. You’ll need to find an ARM package for DBD by the community.

8

Do you know if the issue is because of Perl DBD or the Perl version?
We have two options
Downgrading Perl to 5.16.3 which worked earlier or
Using ARM packaged for DBD (4.0.50)? (A
Which one do we need to try?

9

I would downgrade since you know it works.

10

Hi Matthew,
Rocky Linux documentation says we wont be able to downgrade any package at the moment, can you please let us know if there is any other versions that is supported?