Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

Percona Cluster install on clean CentOS - conflict with MySQL libs

Bug #1183669 reported by Vadim Yevsyukov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Fix Released
Medium
Ignacio Nin
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC 5.5.31-23.7.5

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
-------------

Tags: installation

Related branches

lp:~ignacio-nin/percona-xtradb-cluster/pxc-bug1183669
Raghavendra D Prabhu (community): Approve
Diff: 11 lines (+1/-0)
1 file modified
build/percona-xtradb-cluster.spec (+1/-0)
Raghavendra D Prabhu (raghavendra-prabhu)
Changed in percona-xtradb-cluster:
milestone: none → 5.5.31-24.8
assignee: nobody → Ignacio Nin (ignacio-nin)
status: New → Triaged
Revision history for this message
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?

Revision history for this message
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
Ignacio Nin (ignacio-nin)
Changed in percona-xtradb-cluster:
status: Triaged → In Progress
Revision history for this message
Ignacio Nin (ignacio-nin) wrote :

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

Porting the fix from 5.5.

Ignacio Nin (ignacio-nin)
Changed in percona-xtradb-cluster:
status: In Progress → Fix Committed
Ignacio Nin (ignacio-nin)
Changed in percona-xtradb-cluster:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.