Percona XtraDB Cluster - HA scalable solution for MySQL

Percona Cluster install on clean CentOS - conflict with MySQL libs

Reported by Vadim Yevsyukov on 2013-05-24
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster
Medium
Ignacio Nin

Bug Description

Following instructions from guidance:

Installing Percona XtraDB Cluster on CentOS
http://www.percona.com/doc/percona-xtradb-cluster/howtos/cenots_howto.html

Clean install of CentOS 6.3. Firewall and SELinux disabled.

Reboot.

[root@percona1 ~]# rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Retrieving http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Preparing... ########################################### [100%]
   1:percona-release ########################################### [100%]
[root@percona1 ~]# yum install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client
Loaded plugins: fastestmirror, refresh-packagekit, security
base | 3.7 kB 00:00
base/primary_db | 4.4 MB 00:21
extras | 3.5 kB 00:00
extras/primary_db | 19 kB 00:00
percona | 951 B 00:00
percona/primary | 15 kB 00:00
percona 48/48
updates | 3.4 kB 00:00
updates/primary_db | 2.5 MB 00:03
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-XtraDB-Cluster-client.x86_64 1:5.5.30-23.7.4.406.rhel6 will be installed
--> Processing Dependency: Percona-XtraDB-Cluster-shared for package: 1:Percona-XtraDB-Cluster-client-5.5.30-23.7.4.406.rhel6.x86_64
---> Package Percona-XtraDB-Cluster-server.x86_64 1:5.5.30-23.7.4.406.rhel6 will be installed
--> Processing Dependency: xtrabackup >= 1.9.0 for package: 1:Percona-XtraDB-Cluster-server-5.5.30-23.7.4.406.rhel6.x86_64
--> Processing Dependency: Percona-XtraDB-Cluster-galera for package: 1:Percona-XtraDB-Cluster-server-5.5.30-23.7.4.406.rhel6.x86_64
--> Processing Dependency: nc for package: 1:Percona-XtraDB-Cluster-server-5.5.30-23.7.4.406.rhel6.x86_64
--> Running transaction check
---> Package Percona-XtraDB-Cluster-galera.x86_64 0:2.5-1.150.rhel6 will be installed
---> Package Percona-XtraDB-Cluster-shared.x86_64 1:5.5.30-23.7.4.406.rhel6 will be installed
---> Package nc.x86_64 0:1.84-22.el6 will be installed
---> Package percona-xtrabackup.x86_64 0:2.1.3-608.rhel6 will be installed
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-2.1.3-608.rhel6.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: percona-xtrabackup-2.1.3-608.rhel6.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
---> Package perl-Time-HiRes.x86_64 4:1.9721-131.el6_4 will be installed
--> Processing Dependency: perl = 4:5.10.1-131.el6_4 for package: 4:perl-Time-HiRes-1.9721-131.el6_4.x86_64
--> Running transaction check
---> Package perl.x86_64 4:5.10.1-127.el6 will be updated
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 1:perl-Module-Pluggable-3.90-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 3:perl-version-0.77-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 4:perl-devel-5.10.1-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 4:perl-libs-5.10.1-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 1:perl-ExtUtils-ParseXS-2.2003.0-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: perl-Test-Simple-0.92-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 1:perl-Pod-Simple-3.13-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: perl-ExtUtils-MakeMaker-6.55-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: perl-Test-Harness-3.17-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: perl-CGI-3.51-127.el6.x86_64
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 1:perl-Pod-Escapes-1.04-127.el6.x86_64
---> Package perl.x86_64 4:5.10.1-131.el6_4 will be an update
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Running transaction check
---> Package perl-CGI.x86_64 0:3.51-127.el6 will be updated
---> Package perl-CGI.x86_64 0:3.51-131.el6_4 will be an update
---> Package perl-ExtUtils-MakeMaker.x86_64 0:6.55-127.el6 will be updated
---> Package perl-ExtUtils-MakeMaker.x86_64 0:6.55-131.el6_4 will be an update
---> Package perl-ExtUtils-ParseXS.x86_64 1:2.2003.0-127.el6 will be updated
---> Package perl-ExtUtils-ParseXS.x86_64 1:2.2003.0-131.el6_4 will be an update
---> Package perl-Module-Pluggable.x86_64 1:3.90-127.el6 will be updated
---> Package perl-Module-Pluggable.x86_64 1:3.90-131.el6_4 will be an update
---> Package perl-Pod-Escapes.x86_64 1:1.04-127.el6 will be updated
---> Package perl-Pod-Escapes.x86_64 1:1.04-131.el6_4 will be an update
---> Package perl-Pod-Simple.x86_64 1:3.13-127.el6 will be updated
---> Package perl-Pod-Simple.x86_64 1:3.13-131.el6_4 will be an update
---> Package perl-Test-Harness.x86_64 0:3.17-127.el6 will be updated
---> Package perl-Test-Harness.x86_64 0:3.17-131.el6_4 will be an update
---> Package perl-Test-Simple.x86_64 0:0.92-127.el6 will be updated
---> Package perl-Test-Simple.x86_64 0:0.92-131.el6_4 will be an update
---> Package perl-devel.x86_64 4:5.10.1-127.el6 will be updated
---> Package perl-devel.x86_64 4:5.10.1-131.el6_4 will be an update
---> Package perl-libs.x86_64 4:5.10.1-127.el6 will be updated
---> Package perl-libs.x86_64 4:5.10.1-131.el6_4 will be an update
---> Package perl-version.x86_64 3:0.77-127.el6 will be updated
---> Package perl-version.x86_64 3:0.77-131.el6_4 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================
 Package Arch Version Repository Size
=============================================================================================================================
Installing:
 Percona-XtraDB-Cluster-client x86_64 1:5.5.30-23.7.4.406.rhel6 percona 6.2 M
 Percona-XtraDB-Cluster-server x86_64 1:5.5.30-23.7.4.406.rhel6 percona 15 M
Installing for dependencies:
 Percona-XtraDB-Cluster-galera x86_64 2.5-1.150.rhel6 percona 1.1 M
 Percona-XtraDB-Cluster-shared x86_64 1:5.5.30-23.7.4.406.rhel6 percona 664 k
 nc x86_64 1.84-22.el6 base 57 k
 percona-xtrabackup x86_64 2.1.3-608.rhel6 percona 6.7 M
 perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
 perl-DBI x86_64 1.609-4.el6 base 705 k
 perl-Time-HiRes x86_64 4:1.9721-131.el6_4 updates 47 k
Updating for dependencies:
 perl x86_64 4:5.10.1-131.el6_4 updates 10 M
 perl-CGI x86_64 3.51-131.el6_4 updates 208 k
 perl-ExtUtils-MakeMaker x86_64 6.55-131.el6_4 updates 292 k
 perl-ExtUtils-ParseXS x86_64 1:2.2003.0-131.el6_4 updates 44 k
 perl-Module-Pluggable x86_64 1:3.90-131.el6_4 updates 39 k
 perl-Pod-Escapes x86_64 1:1.04-131.el6_4 updates 31 k
 perl-Pod-Simple x86_64 1:3.13-131.el6_4 updates 211 k
 perl-Test-Harness x86_64 3.17-131.el6_4 updates 230 k
 perl-Test-Simple x86_64 0.92-131.el6_4 updates 111 k
 perl-devel x86_64 4:5.10.1-131.el6_4 updates 421 k
 perl-libs x86_64 4:5.10.1-131.el6_4 updates 577 k
 perl-version x86_64 3:0.77-131.el6_4 updates 50 k

Transaction Summary
=============================================================================================================================
Install 9 Package(s)
Upgrade 12 Package(s)

Total download size: 43 M
Is this ok [y/N]: y
Downloading Packages:
(1/21): Percona-XtraDB-Cluster-client-5.5.30-23.7.4.406.rhel6.x86_64.rpm | 6.2 MB 00:01
(2/21): Percona-XtraDB-Cluster-galera-2.5-1.150.rhel6.x86_64.rpm | 1.1 MB 00:00
(3/21): Percona-XtraDB-Cluster-server-5.5.30-23.7.4.406.rhel6.x86_64.rpm | 15 MB 00:02
(4/21): Percona-XtraDB-Cluster-shared-5.5.30-23.7.4.406.rhel6.x86_64.rpm | 664 kB 00:00
(5/21): nc-1.84-22.el6.x86_64.rpm | 57 kB 00:00
(6/21): percona-xtrabackup-2.1.3-608.rhel6.x86_64.rpm | 6.7 MB 00:01
(7/21): perl-5.10.1-131.el6_4.x86_64.rpm | 10 MB 00:37
(8/21): perl-CGI-3.51-131.el6_4.x86_64.rpm | 208 kB 00:00
(9/21): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00
(10/21): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:00
(11/21): perl-ExtUtils-MakeMaker-6.55-131.el6_4.x86_64.rpm | 292 kB 00:00
(12/21): perl-ExtUtils-ParseXS-2.2003.0-131.el6_4.x86_64.rpm | 44 kB 00:00
(13/21): perl-Module-Pluggable-3.90-131.el6_4.x86_64.rpm | 39 kB 00:00
(14/21): perl-Pod-Escapes-1.04-131.el6_4.x86_64.rpm | 31 kB 00:00
(15/21): perl-Pod-Simple-3.13-131.el6_4.x86_64.rpm | 211 kB 00:00
(16/21): perl-Test-Harness-3.17-131.el6_4.x86_64.rpm | 230 kB 00:00
(17/21): perl-Test-Simple-0.92-131.el6_4.x86_64.rpm | 111 kB 00:00
(18/21): perl-Time-HiRes-1.9721-131.el6_4.x86_64.rpm | 47 kB 00:00
(19/21): perl-devel-5.10.1-131.el6_4.x86_64.rpm | 421 kB 00:01
(20/21): perl-libs-5.10.1-131.el6_4.x86_64.rpm | 577 kB 00:01
(21/21): perl-version-0.77-131.el6_4.x86_64.rpm | 50 kB 00:00
-----------------------------------------------------------------------------------------------------------------------------
Total 841 kB/s | 43 MB 00:52
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Importing GPG key 0xC105B9DE:
 Userid : CentOS-6 Key (CentOS 6 Official Signing Key) <email address hidden>
 Package: centos-release-6-3.el6.centos.9.x86_64 (@anaconda-CentOS-201207061011.x86_64/6.3)
 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Is this ok [y/N]: y
warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
Importing GPG key 0xCD2EFD2A:
 Userid : Percona MySQL Development Team <email address hidden>
 Package: percona-release-0.0-1.x86_64 (installed)
 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-percona
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test

Transaction Check Error:
  file /usr/share/mysql/charsets/Index.xml from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/english/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/estonian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/french/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/german/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/greek/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/hungarian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/italian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/japanese/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/korean/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/norwegian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/polish/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/portuguese/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/romanian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/russian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/serbian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/slovak/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/spanish/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/swedish/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
  file /usr/share/mysql/ukrainian/errmsg.sys from install of Percona-XtraDB-Cluster-server-1:5.5.30-23.7.4.406.rhel6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64

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

Changed in percona-xtradb-cluster:
milestone: none → 5.5.31-24.8
assignee: nobody → Ignacio Nin (ignacio-nin)
status: New → Triaged
Vadim Yevsyukov (q-vadim) wrote :

Worked around by running:
$ yum erase mysql-libs-5.1.61-4.el6.x86_64

Probably just mention the case in the guide?

Ignacio Nin (ignacio-nin) wrote :

Hello,

As mentioned by Vadim, mysql-libs was preinstalled and it conflicts with our shared package.

We should Conflict: with it at the package level so rpm doesn't even try to run the transaction (i.e. cleaner error) so we're still taking in the bug -- but the workaround will still be the same: mysql-libs or any other remnant of a mysql install needs to be removed prior to installing PXC (or PS for that matter).

Thanks!

Changed in percona-xtradb-cluster:
importance: Undecided → Medium
Changed in percona-xtradb-cluster:
status: Triaged → In Progress
Ignacio Nin (ignacio-nin) wrote :

Percona-Server-shared-55 does The Right Thing® in this case.

Porting the fix from 5.5.

Changed in percona-xtradb-cluster:
status: In Progress → Fix Committed
Changed in percona-xtradb-cluster:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers