Percona-XtraDB-Cluster-server-56 installation fails on CentOS 6.x

[David Kedves]

Steps leading to the problem:
- start up a clean CentOS 6.x instance
- install & enable epel-6 repository on it
- add percona-release repository
- then execute: yum -y install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56

 [root@galera_node1 vagrant]# yum -y install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.met.hu
 * epel: mirrors.nic.cz
 * extras: mirror.met.hu
 * updates: mirror.met.hu
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-XtraDB-Cluster-client-56.x86_64 1:5.6.25-25.12.1.el6 will be installed
---> Package Percona-XtraDB-Cluster-server-56.x86_64 1:5.6.25-25.12.1.el6 will be installed
--> Processing Dependency: percona-xtrabackup >= 2.2.5 for package: 1:Percona-XtraDB-Cluster-server-56-5.6.25-25.12.1.el6.x86_64
--> Processing Dependency: Percona-XtraDB-Cluster-shared-56 for package: 1:Percona-XtraDB-Cluster-server-56-5.6.25-25.12.1.el6.x86_64
--> Processing Dependency: lsof for package: 1:Percona-XtraDB-Cluster-server-56-5.6.25-25.12.1.el6.x86_64
--> Processing Dependency: Percona-XtraDB-Cluster-galera-25 for package: 1:Percona-XtraDB-Cluster-server-56-5.6.25-25.12.1.el6.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: 1:Percona-XtraDB-Cluster-server-56-5.6.25-25.12.1.el6.x86_64
--> Running transaction check
---> Package Percona-XtraDB-Cluster-galera-3.x86_64 0:3.12-1.rhel6 will be installed
---> Package Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.25-25.12.1.el6 will be installed
---> Package lsof.x86_64 0:4.82-5.el6 will be installed
---> Package percona-xtrabackup.x86_64 0:2.2.12-1.el6 will be installed
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Running transaction check
---> Package Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.625.rhel6 will be installed
--> Processing Conflict: Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64 conflicts mysql-libs
--> Finished Dependency Resolution
Error: Percona-Server-shared-51 conflicts with 1:Percona-XtraDB-Cluster-shared-56-5.6.25-25.12.1.el6.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

It seems Percona-XtraDB-Cluster-server-56-5.6.25-25.12.1.el6.x86_64 is pulling the perl-DBD-MySQL as dependency which depends on mysql-libs which conflicts with Percona-Server-shared :-S

Please advice how to fix this issue...

[Przemek (pmalkowski)]

I can reproduce the same problem when trying to do yum update. Seems like the new Percona-Server-shared-51 package version is broken:

[root@percona1 ~]# rpm -qa|egrep -i "perc|mysql"
Percona-XtraDB-Cluster-client-56-5.6.25-25.12.1.el6.x86_64
Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64
percona-release-0.1-3.noarch
perl-DBD-MySQL-4.013-3.el6.x86_64
Percona-XtraDB-Cluster-galera-3-3.12-1.rhel6.x86_64
Percona-XtraDB-Cluster-server-56-5.6.25-25.12.1.el6.x86_64
percona-xtrabackup-2.2.12-1.el6.x86_64
Percona-XtraDB-Cluster-shared-56-5.6.25-25.12.1.el6.x86_64
Percona-XtraDB-Cluster-garbd-3-3.12-1.rhel6.x86_64
[root@percona1 ~]# yum -q update
Error: Percona-Server-shared-51 conflicts with 1:Percona-XtraDB-Cluster-shared-56-5.6.25-25.12.1.el6.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

[root@percona1 ~]# rpm -ql Percona-Server-shared-51
/usr/lib64/libmysqlclient.so.16.0.0
/usr/lib64/libmysqlclient_r.so.16.0.0
/usr/lib64/mysql/libmysqlclient.so.16.0.0
/usr/lib64/mysql/libmysqlclient_r.so.16.0.0
[root@percona1 ~]#
[root@percona1 ~]# rpm -ql Percona-XtraDB-Cluster-shared-56
/etc/ld.so.conf.d/percona-xtradb-cluster-shared-5.6.25-x86_64.conf
/usr/lib64/libmysqlclient.so.18.1.0
/usr/lib64/libmysqlclient_r.so.18.1.0

The workaround to install PXC is to specify the previous shared-51 version explicitly:

yum -q install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56 Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6

[root@percona3 ~]# yum -q install Percona-XtraDB-Cluster-server-56 Percona-XtraDB-Cluster-client-56 Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6

===============================================================================================================================================================================================================================================================================
 Package Arch Version Repository Size
===============================================================================================================================================================================================================================================================================
Installing:
 Percona-Server-shared-51 x86_64 5.1.73-rel14.12.624.rhel6 percona-release-x86_64 2.1 M
 Percona-XtraDB-Cluster-client-56 x86_64 1:5.6.25-25.12.1.el6 percona-release-x86_64 6.1 M
 Percona-XtraDB-Cluster-server-56 x86_64 1:5.6.25-25.12....

[Raghavendra D Prabhu (raghavendra-prabhu)]

The issue here is that the Percona-Server-shared-51 no longer provides mysql-libs={version} (which is 5.1.73 in this case). Hence the conflict and other issues.

For PXC as a workaround try https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation/yum_repo.html#install-xtradb-cluster

ie. install the metapackage Percona-XtraDB-Cluster-56

The shared package is not required for server operation.

[Tomislav Plavcic (tplavcic)]

@raghu
They both (the old one and the new one) provide the same thing:
uploader@repo:~/Percona-Server-shared-51$ rpm -qp --provides Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64.rpm
MySQL-shared
Percona-XtraDB-shared
libmysqlclient.so.16()(64bit)
libmysqlclient.so.16(libmysqlclient_16)(64bit)
libmysqlclient_r.so.16()(64bit)
libmysqlclient_r.so.16(libmysqlclient_16)(64bit)
mysql-libs
mysql-shared
Percona-Server-shared-51 = 5.1.73-rel14.12.625.rhel6
Percona-Server-shared-51(x86-64) = 5.1.73-rel14.12.625.rhel6

 plavi@bender  x86_64  rpm -qp --provides Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64.rpm
MySQL-shared
Percona-XtraDB-shared
libmysqlclient.so.16()(64bit)
libmysqlclient.so.16(libmysqlclient_16)(64bit)
libmysqlclient_r.so.16()(64bit)
libmysqlclient_r.so.16(libmysqlclient_16)(64bit)
mysql-libs
mysql-shared
Percona-Server-shared-51 = 5.1.73-rel14.12.624.rhel6
Percona-Server-shared-51(x86-64) = 5.1.73-rel14.12.624.rhel6

The change was that the new one doesn't "obsolete" mysql-libs as it was intended that it stays on the system.
And it was done because of this issue: https://bugs.launchpad.net/percona-server/+bug/1497893

Anyway PXC installation was working if you had mysql-libs installed on the system (at least for me). If you remove mysql-libs and then try installation as suggested in this ticket then you get the same error.

I have now removed that new PS-shared-51 package and now it should be resolved (would be good if somebody other then me can confirm). But now I have to reopen that other ticket and see how to resolve it.

Bottom line is that there's too many workarounds like this because of no separate repos for different products.

[Przemek (pmalkowski)]

Raghu, indeed the Percona-Server-shared-51 nor mysql-libs is needed for PXC server operation unless you need xtrabackup. Xtrabackup requires perl-DBD-MySQL and the former requires

[root@percona3 ~]# yum install percona-xtrabackup
(...)
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup.x86_64 0:2.2.12-1.el6 will be installed
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-2.2.12-1.el6.x86_64
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Running transaction check
---> Package Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.624.rhel6 will be installed

Tomislav, thank you, after removing the Server-shared-51-5.1.73-rel14.12.625 version from repo, all seems to work fine with 5.1.73-rel14.12.624.

[Shahriyar Rzayev (rzayev-sehriyar)]

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