mysql conflicts with Percona-Server-client-56 on Centos 5

[Roel Van de Paar]

* Spin up a Centos5 container, or use some other Centos 5 box

$ sudo docker run -t -i centos:centos5 /bin/bash

# yum install -y wget
# wget http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
# rpm -iv percona-release-0.1-3.noarch.rpm
# yum install -y Percona-Server-client-56 Percona-Server-server-56
# yum install -y percona-xtrabackup.x86_64

[root@a45f5ffe7d56 /]# yum install -y percona-xtrabackup.x86_64
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.mirror.crucial.com.au
 * extras: centos.mirror.crucial.com.au
 * libselinux: mirror.optus.net
 * updates: centos.mirror.crucial.com.au
Reducing CentOS-5 - libselinux to included packages only
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup.x86_64 0:2.2.9-5067.el5 set to be updated
--> Processing Dependency: rsync for package: percona-xtrabackup
--> Processing Dependency: libgcrypt.so.11(GCRYPT_1.2)(64bit) for package: percona-xtrabackup
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup
--> Processing Dependency: libgcrypt.so.11()(64bit) for package: percona-xtrabackup
--> Processing Dependency: libgpg-error.so.0()(64bit) for package: percona-xtrabackup
--> Running transaction check
---> Package libgcrypt.x86_64 0:1.4.4-7.el5_10 set to be updated
---> Package libgpg-error.x86_64 0:1.4-2 set to be updated
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL
---> Package rsync.x86_64 0:3.0.6-6.el5_11 set to be updated
--> Running transaction check
---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated
---> Package perl-DBI.x86_64 0:1.52-2.el5 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.95-5.el5_9.x86_64 from base has depsolving problems
  --> mysql conflicts with Percona-Server-client-56
Error: mysql conflicts with Percona-Server-client-56
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

[Roel Van de Paar (roel11)]

Before installing Percona Repo, mysql client is also not installed by default;

[root@2f5d2fc397be /]# yum remove mysql
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: mysql
Loading mirror speeds from cached hostfile
 * base: centos.mirror.crucial.com.au
 * extras: centos.mirror.crucial.com.au
 * libselinux: mirror.optus.net
 * updates: centos.mirror.crucial.com.au
Reducing CentOS-5 - libselinux to included packages only
Finished
Package(s) mysql available, but not installed.
No Packages marked for removal

[Roel Van de Paar (roel11)]

Centos 6 is fine

[root@0df137d878b5 /]# yum install -y percona-xtrabackup.x86_64
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.mirror.crucial.com.au
 * extras: centos.mirror.crucial.com.au
 * updates: centos.mirror.crucial.com.au
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup.x86_64 0:2.2.9-5067.el6 will be installed
--> Processing Dependency: rsync for package: percona-xtrabackup-2.2.9-5067.el6.x86_64
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-2.2.9-5067.el6.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: percona-xtrabackup-2.2.9-5067.el6.x86_64
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: perl(DBI::Const::GetInfoType) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> 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
---> Package perl-Time-HiRes.x86_64 4:1.9721-136.el6_6.1 will be installed
---> Package rsync.x86_64 0:3.0.6-12.el6 will be installed
--> Running transaction check
---> Package Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.624.rhel6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

[Roel Van de Paar (roel11)]

Also present for PS 5.5 + XB

---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated
---> Package perl-DBI.x86_64 0:1.52-2.el5 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.95-5.el5_9.x86_64 from base has depsolving problems
  --> mysql conflicts with Percona-Server-client-55
Error: mysql conflicts with Percona-Server-client-55
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

[Roel Van de Paar (roel11)]

Also with 5.1 which seems to make this an XB PKG bug?

[Shahriyar Rzayev (rzayev-sehriyar)]

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