Install PXC 5.5 on CentOS 6.5 getting dependency failure

[Nilnandan Joshi]

[root@percona-pxc1 ~]# uname -a
Linux percona-pxc1 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@percona-pxc1 ~]#
[root@percona-pxc1 ~]# lsb_release -a
LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Distributor ID: CentOS
Description: CentOS release 6.5 (Final)
Release: 6.5
Codename: Final
[root@percona-pxc1 ~]#
[root@percona-pxc1 ~]# rpm -qa | grep -i Percona
percona-release-0.0-1.x86_64
[root@percona-pxc1 ~]#
[root@percona-pxc1 ~]# yum install Percona-XtraDB-Cluster-server-55 Percona-XtraDB-Cluster-client-55 Percona-XtraDB-Cluster-galera-2
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: centos.mirror.net.in
 * extras: centos.mirror.net.in
 * updates: centos.mirror.net.in
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-XtraDB-Cluster-client-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Processing Dependency: Percona-XtraDB-Cluster-shared-55 for package: 1:Percona-XtraDB-Cluster-client-55-5.5.34-25.9.607.rhel6.x86_64
---> Package Percona-XtraDB-Cluster-galera-2.x86_64 0:2.8-1.157.rhel6 will be installed
---> Package Percona-XtraDB-Cluster-server-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Processing Dependency: percona-xtrabackup >= 2.1.4 for package: 1:Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64
--> Processing Dependency: socat for package: 1:Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64
--> Running transaction check
---> Package Percona-XtraDB-Cluster-server-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Processing Dependency: socat for package: 1:Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64
---> Package Percona-XtraDB-Cluster-shared-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
---> Package percona-xtrabackup.x86_64 0:2.1.7-721.rhel6 will be installed
--> Processing Dependency: perl(Time::HiRes) for package: percona-xtrabackup-2.1.7-721.rhel6.x86_64
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-2.1.7-721.rhel6.x86_64
--> Running transaction check
---> Package Percona-XtraDB-Cluster-server-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Processing Dependency: socat for package: 1:Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64
---> 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
---> Package perl-Time-HiRes.x86_64 4:1.9721-136.el6 will be installed
--> Running transaction check
---> Package Percona-XtraDB-Cluster-server-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Processing Dependency: socat for package: 1:Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution
Error: Package: 1:Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64 (percona)
           Requires: socat
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@percona-pxc1 ~]#

Even while doing "yum update" getting this error.

Transaction Check Error:
  file /usr/lib64/libmysqlclient.so.16.0.0 conflicts between attempted installs of Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64 and Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64
  file /usr/lib64/libmysqlclient_r.so.16.0.0 conflicts between attempted installs of Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64 and Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64

Error Summary
-------------

[root@percona-pxc1 ~]#

[Nilnandan Joshi (nilnandan-joshi)]

With RPM packages,

[root@percona-pxc1 ~]# rpm -ivh Percona-XtraDB-Cluster-client-55-5.5.34-25.9.607.rhel6.x86_64.rpm Percona-XtraDB-Cluster-galera-2-2.8-1.157.rhel6.x86_64.rpm Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64.rpm Percona-XtraDB-Cluster-shared-55-5.5.34-25.9.607.rhel6.x86_64.rpm Percona-XtraDB-Cluster-devel-55-5.5.34-25.9.607.rhel6.x86_64.rpm
error: Failed dependencies:
 socat is needed by Percona-XtraDB-Cluster-server-55-1:5.5.34-25.9.607.rhel6.x86_64
[root@percona-pxc1 ~]#
[root@percona-pxc1 ~]#
[root@percona-pxc1 ~]# yum install socat
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: centos.mirror.net.in
 * extras: centos.mirror.net.in
 * updates: centos.mirror.net.in
Setting up Install Process
No package socat available.
Error: Nothing to do
[root@percona-pxc1 ~]#

[Nilnandan Joshi (nilnandan-joshi)]

Workaround:

[root@percona-pxc1 ~]# wget http://pkgs.repoforge.org/socat/socat-1.7.1.3-1.el6.rf.x86_64.rpm

[root@percona-pxc1 ~]#
[root@percona-pxc1 ~]# rpm -ivh socat-1.7.1.3-1.el6.rf.x86_64.rpm
warning: socat-1.7.1.3-1.el6.rf.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing... ########################################### [100%]
   1:socat ########################################### [100%]
[root@percona-pxc1 ~]#

[root@percona-pxc1 ~]# yum install Percona-XtraDB-Cluster-server-55 Percona-XtraDB-Cluster-client-55 Percona-XtraDB-Cluster-galera-2
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: centos.mirror.net.in
 * extras: centos.mirror.net.in
 * updates: centos.mirror.net.in
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-XtraDB-Cluster-client-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Processing Dependency: Percona-XtraDB-Cluster-shared-55 for package: 1:Percona-XtraDB-Cluster-client-55-5.5.34-25.9.607.rhel6.x86_64
---> Package Percona-XtraDB-Cluster-galera-2.x86_64 0:2.8-1.157.rhel6 will be installed
---> Package Percona-XtraDB-Cluster-server-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Running transaction check
---> Package Percona-XtraDB-Cluster-shared-55.x86_64 1:5.5.34-25.9.607.rhel6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================
 Package Arch Version Repository Size
===============================================================================================================================================
Installing:
 Percona-XtraDB-Cluster-client-55 x86_64 1:5.5.34-25.9.607.rhel6 percona 6.1 M
 Percona-XtraDB-Cluster-galera-2 x86_64 2.8-1.157.rhel6 percona 1.1 M
 Percona-XtraDB-Cluster-server-55 x86_64 1:5.5.34-25.9.607.rhel6 percona 15 M
Installing for dependencies:
 Percona-XtraDB-Cluster-shared-55 x86_64 1:5.5.34-25.9.607.rhel6 percona 645 k

Transaction Summary
===============================================================================================================================================
Install 4 Package(s)

Total download size: 23 M
Installed size: 100 M
Is this ok [y/N]: Y
Downloading Packages:
(1/4): Percona-XtraDB-Cluster-client-55-5.5.34-25.9.607.rhel6.x86_64.rpm | 6.1 MB 00:20
(2/4): Percona-XtraDB-Cluster-galera-2-2.8-1.157.rhel6.x86_64.rpm | 1.1 MB 00:02
(3/4): Percona-XtraDB-Cluster-server-55-5.5.34-25.9.607.rhel6.x86_64.rpm ...

[Nilnandan Joshi (nilnandan-joshi)]

socat is missing in percona repo so it seems a PXC bug.

[Raghavendra D Prabhu (raghavendra-prabhu)]

a)

> Even while doing "yum update" getting this error.

What exactly are you updating? rpm -qa | grep -i Percona shows empty.

Are you doing fresh installation or doing an update of existing packages.

Please provide full output of command where you got

"
Transaction Check Error:
  file /usr/lib64/libmysqlclient.so.16.0.0 conflicts between attempted installs of Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64 and Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64
  file /usr/lib64/libmysqlclient_r.so.16.0.0 conflicts between attempted installs of Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64 and Percona-Server-shared-51-5.1.73-rel14.11.603.rhel6.x86_64

"

b) For socat you need EPEL enabled for CentOS 6. http://pkgs.org/search/?keyword=socat

c) > socat is missing in percona repo so it seems a PXC bug.

We don't provide socat in our repo. Enable EPEL for it.

[Nilnandan Joshi (nilnandan-joshi)]

a) I was doing fresh installation, after installing CentOS 6.5 and add percona repo, I did yum update
b) Installed socat through EPEL but still getting error

Find attached file for required output.

[Raghavendra D Prabhu (raghavendra-prabhu)]

The issue with mysql-libs is a known one with PS libraries. It is going
to be fixed in next release (of both PXC and PS).

You are seeing the issue not due to socat, but due to mysql-libs
installed. Removing it and subsequent installation of PXC
packages should fix it.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Also check https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1278516 where it has been fixed.

[Launchpad Janitor (janitor)]

[Expired for Percona XtraDB Cluster because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

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