Percona XtraDB Cluster - HA scalable solution for MySQL

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

Reported by Frederic Descamps on 2013-09-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster
5.6
Undecided
Raghavendra D Prabhu
Trunk
Low
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 Edit Tag help
tags: added: pkg

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
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
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  Edit
Everyone can see this information.

Other bug subscribers