Wrong package (rpm) dependency of xtrabackup in a specific case

Bug #1226185 reported by Frederic Descamps
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
5.5
Fix Released
Low
Raghavendra D Prabhu
5.6
Fix Released
Undecided
Raghavendra D Prabhu

Bug Description

Platform: Centos 6.4
Package manager: yum
Repository: percona and percona experimental

When installing first Percona-XtraDB-Cluster-client and then Percona-XtraDB-Cluster-server on two single statements or a single statement with both packages , yum will install percona-xtrabackup-20 as dependency of Percona-XtraDB-Cluster-server.

It should install percona-xtrabackup 2.1.4-656.rhel6.

example:

[root@percona3 mysql]# yum install Percona-XtraDB-Cluster-client Percona-XtraDB-Cluster-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.myip.be
 * epel: mirror.bytemark.co.uk
 * extras: mirror.myip.be
 * updates: mirror.myip.be
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-XtraDB-Cluster-client.x86_64 1:5.5.33-23.7.5.475.rhel6 will be installed
---> Package Percona-XtraDB-Cluster-server.x86_64 1:5.5.33-23.7.5.475.rhel6 will be installed
--> Processing Dependency: xtrabackup >= 1.9.0 for package: 1:Percona-XtraDB-Cluster-server-5.5.33-23.7.5.475.rhel6.x86_64
--> Processing Dependency: Percona-XtraDB-Cluster-galera for package: 1:Percona-XtraDB-Cluster-server-5.5.33-23.7.5.475.rhel6.x86_64
--> Running transaction check
---> Package Percona-XtraDB-Cluster-galera.x86_64 0:2.6-1.155.rhel6 will be installed
---> Package percona-xtrabackup-20.x86_64 0:2.0.8-587.rhel6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================================================================================
 Package Arch Version Repository Size
=========================================================================================================================================================================================================
Installing:
 Percona-XtraDB-Cluster-client x86_64 1:5.5.33-23.7.5.475.rhel6 percona 6.1 M
 Percona-XtraDB-Cluster-server x86_64 1:5.5.33-23.7.5.475.rhel6 percona 15 M
Installing for dependencies:
 Percona-XtraDB-Cluster-galera x86_64 2.6-1.155.rhel6 percona 1.1 M
 percona-xtrabackup-20 x86_64 2.0.8-587.rhel6 percona 7.0 M

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

Total download size: 29 M
Installed size: 119 M
Is this ok [y/N]:

If only Percona-XtraDB-Cluster-server is declared it works as expected:

[root@percona3 mysql]# yum install Percona-XtraDB-Cluster-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.myip.be
 * epel: mirror.bytemark.co.uk
 * extras: mirror.myip.be
 * updates: mirror.myip.be
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-XtraDB-Cluster-server.x86_64 1:5.5.33-23.7.5.475.rhel6 will be installed
--> Processing Dependency: xtrabackup >= 1.9.0 for package: 1:Percona-XtraDB-Cluster-server-5.5.33-23.7.5.475.rhel6.x86_64
--> Processing Dependency: Percona-XtraDB-Cluster-client for package: 1:Percona-XtraDB-Cluster-server-5.5.33-23.7.5.475.rhel6.x86_64
--> Processing Dependency: Percona-XtraDB-Cluster-galera for package: 1:Percona-XtraDB-Cluster-server-5.5.33-23.7.5.475.rhel6.x86_64
--> Running transaction check
---> Package Percona-XtraDB-Cluster-client.x86_64 1:5.5.33-23.7.5.475.rhel6 will be installed
---> Package Percona-XtraDB-Cluster-galera.x86_64 0:2.6-1.155.rhel6 will be installed
---> Package percona-xtrabackup.x86_64 0:2.1.4-656.rhel6 will be installed
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-2.1.4-656.rhel6.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.71-rel14.9.589.rhel6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================================================================================
 Package Arch Version Repository Size
=========================================================================================================================================================================================================
Installing:
 Percona-XtraDB-Cluster-server x86_64 1:5.5.33-23.7.5.475.rhel6 percona 15 M
Installing for dependencies:
 Percona-Server-shared-51 x86_64 5.1.71-rel14.9.589.rhel6 percona 2.1 M
 Percona-XtraDB-Cluster-client x86_64 1:5.5.33-23.7.5.475.rhel6 percona 6.1 M
 Percona-XtraDB-Cluster-galera x86_64 2.6-1.155.rhel6 percona 1.1 M
 percona-xtrabackup x86_64 2.1.4-656.rhel6 percona 6.8 M
 perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k

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

Total download size: 32 M
Installed size: 128 M
Is this ok [y/N]

Tags: pkg
tags: added: pkg
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

I can reproduce this http://paste.wnohang.net/c093c2 on a clean install from the packages of both release and experimental repos.

Changed in percona-xtradb-cluster:
status: New → Triaged
importance: Undecided → High
assignee: nobody → Ignacio Nin (ignacio-nin)
milestone: none → 5.5.33-23.7.6
Revision history for this message
Ignacio Nin (ignacio-nin) wrote :

Confirmed, it seems to be bad work by yum when selecting dependencies. As a workaround, please execute yum install Percona-XtraDB-Cluster-server and let the client package be installed as a dependency if it's not already installed, or specify manually percona-xtrabackup as well. Both will install 2.1 correctly in rhel6.

Changed in percona-xtradb-cluster:
importance: High → Low
milestone: 5.5.33-23.7.6 → future-5.5
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

I have also documented this in errata here: http://www.percona.com/doc/percona-xtradb-cluster/errata.html

Revision history for this message
Ignacio Nin (ignacio-nin) wrote :

Switching to Won't fix at least for now, since with the current objectives it's not possible to fix it within yum possibilities.

Changed in percona-xtradb-cluster:
status: Triaged → Won't Fix
no longer affects: percona-xtradb-cluster
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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