rpm dependency on "mysql" no longer satisfied by Oracle MySQL 5.5.29 packages

Confirmed.

(with MySQL-server-5.5.29-1.linux2.6.x86_64.rpm installed prior)

sudo yum install xtrabackup
Loaded plugins: auto-update-debuginfo, fastestmirror, presto, security, upgrade-helper
Loading mirror speeds from cached hostfile
 * base: mirrors.hns.net.in
 * centosplus: mirrors.hns.net.in
 * elrepo: mirror.solvention.de
 * elrepo-extras: mirror.solvention.de
 * elrepo-kernel: mirror.solvention.de
 * epel: mirrors.ispros.com.bd
 * epel-debuginfo: mirrors.ispros.com.bd
 * epel-source: mirrors.ispros.com.bd
 * extras: mirrors.hns.net.in
 * fasttrack: mirrors.hns.net.in
 * updates: mirrors.hns.net.in
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup.x86_64 0:2.0.4-484.rhel6 will be installed
--> Processing Dependency: mysql for package: percona-xtrabackup-2.0.4-484.rhel6.x86_64
--> Running transaction check
---> Package mysql.x86_64 0:5.1.66-2.el6_3 will be installed
--> Processing Conflict: MySQL-server-5.5.29-1.linux2.6.x86_64 conflicts mysql
--> Processing Conflict: mysql-5.1.66-2.el6_3.x86_64 conflicts MySQL
--> Finished Dependency Resolution
Error: MySQL-server conflicts with mysql
Error: mysql conflicts with MySQL-server
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Here is what the provides shows: http://sprunge.us/fBdg

The Percona Server in the right installs fine whereas the MySQL
server fails as above.

I was planning to try out Percona-xtrabackup, but I am not willing to put anything compiled from source on production servers.

5.5.29 is the official version from Oracle, and a fix seems to be very simple - does the team have plans to deal with this bug?

Just a note, the current "provides" for the Oracle MySQL:

$> rpm --provides -q MySQL-server-5.5.29
MySQL
MySQL-server
adt_null.so()(64bit)
auth.so()(64bit)
auth_socket.so()(64bit)
auth_test_plugin.so()(64bit)
config(MySQL-server) = 5.5.29-1.el6
libdaemon_example.so()(64bit)
msqlormysql
mypluglib.so()(64bit)
qa_auth_client.so()(64bit)
qa_auth_interface.so()(64bit)
qa_auth_server.so()(64bit)
semisync_master.so()(64bit)
semisync_slave.so()(64bit)
MySQL-server = 5.5.29-1.el6
MySQL-server(x86-64) = 5.5.29-1.el6

rpm -q --provides -p MySQL-client-5.5.30-1.linux2.6.x86_64.rpm
MySQL-client
MySQL-client = 5.5.30-1.linux2.6

raghu archie:~ [74]% rpm -q --provides Percona-Server-client-55-5.5.27-rel28.1.296.rhel6.x86_64
MySQL
MySQL-client
mysql
mysql-client
Percona-Server-client-55 = 5.5.27-rel28.1.296.rhel6
Percona-Server-client-55(x86-64) = 5.5.27-rel28.1.296.rhel6

raghu archie:~ [75]% rpm -q --requires percona-xtrabackup-2.0.2-461.rhel6.x86_64
mysql
rpmlib(FileDigests) <= 4.6.0-1
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
rpmlib(CompressedFileNames) <= 3.0.4-1
rpmlib(PayloadIsXz) <= 5.2-1

So, adding MySQL-client or /usr/bin/mysql to Xtrabackup's
Requires should do.

(However, this dependency won't be needed for long, since because of https://blueprints.launchpad.net/percona-xtrabackup/+spec/use-dbd-mysql-in-innobackupex the dependency from XB 2.1 onwards will be on perl DBD MySQL (much like percona-toolkit))

Adding the summary of discussion with Alexey.

The current dependencies of percona-xtrabackup are as follows:
[root@centos58_01 ~]# yum deplist percona-xtrabackup
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
 * base: mirror.awo-ha-mk.de
 * epel: mirrors.n-ix.net
 * extras: centos.mirror.linuxwerk.com
 * updates: centos.mirror.linuxwerk.com
Finding dependencies:
package: percona-xtrabackup.x86_64 2.0.5-499.rhel5
  dependency: mysql
   provider: mysql.i386 5.0.95-3.el5
   provider: mysql.x86_64 5.0.95-3.el5
   provider: mysql.i386 5.0.95-5.el5_9
   provider: mysql.x86_64 5.0.95-5.el5_9
   provider: Percona-SQL-client-50.x86_64 5.0.92-b23.85.rhel5
   provider: Percona-Server-client-55.x86_64 5.5.29-rel29.4.401.rhel5
   provider: Percona-Server-client-51.x86_64 5.1.67-rel14.3.506.rhel5
   provider: Percona-XtraDB-Cluster-client.x86_64 1:5.5.29-23.7.2.389.rhel5

The problem is that starting MySQL version 5.5.29 the MySQL-server RPM no loner meets the dependency, as it no longer provides "mysql":
[root@centos58_01 ~]# rpm -qp MySQL-server-5.5.30-1.rhel5.x86_64.rpm --provides
MySQL
MySQL-server
adt_null.so()(64bit)
auth.so()(64bit)
auth_socket.so()(64bit)
auth_test_plugin.so()(64bit)
config(MySQL-server) = 5.5.30-1.rhel5
libdaemon_example.so()(64bit)
libtcmalloc_minimal.so.0()(64bit)
msqlormysql
mypluglib.so()(64bit)
qa_auth_client.so()(64bit)
qa_auth_interface.so()(64bit)
qa_auth_server.so()(64bit)
semisync_master.so()(64bit)
semisync_slave.so()(64bit)
MySQL-server = 5.5.30-1.rhel5

The MySQL-client package provides the following:
[root@centos58_01 ~]# rpm -qp MySQL-client-5.5.30-1.rhel5.x86_64.rpm --provides
MySQL-client
MySQL-client = 5.5.30-1.rhel5

We cannot simply change the dependency of percona-xtrabackup to mysql-client because the mysql client that ships with centos 5 does not provide mysql-client. A solution could be to change to "Requires: /usr/bin/mysql"

Just to clarify on the DBD dep in future, I think XB 2.0.x will still be depedent on mysql client and XB 2.1 will be on DBD, DBD dependency may not be backported to XB 2.0.x

What about depending on MySQL-client?

Percona-Server has been Provide:ing in both 5.1 and 5.5, since it's provided by Oracle's and we aim for compatibility.

Ignacio depending on MySQL-client will cause problems with clients that ship with for example CentOS 5 because they do not provide MySQL-client

Ignacio, a bit of context on what I was saying.

Provides from a MySQL client package that ships with CentOS 5.8:
[root@centos58_01 ~]# rpm -qp mysql-5.0.95-5.el5_9.x86_64.rpm --provides
config(mysql) = 5.0.95-5.el5_9
libmysqlclient.so.15()(64bit)
libmysqlclient.so.15(libmysqlclient_15)(64bit)
libmysqlclient_r.so.15()(64bit)
libmysqlclient_r.so.15(libmysqlclient_15)(64bit)
mysql = 5.0.95-5.el5_9

Provides from a MySQL client package that ships with CentOS 6.3:
[root@centos6_01 ~]# rpm -qp mysql-5.1.67-1.el6_3.x86_64.rpm --provides
mysql = 5.1.67-1.el6_3
mysql(x86-64) = 5.1.67-1.el6_3

So if the requires of XtraBackup is changed to MySQL-client or mysql-client, then percona-xtrabackup will still have dependency issues.

Hi,try:

1) Download mysql-community-libs-compat from mysql (https://dev.mysql.com/downloads/mysql/)
rpm -i mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm

2) Install perl-DBD-MySQL
yum install perl-DBD-MySQL

3) Install percona-xtrabackup
yum install percona-xtrabackup

Hi,

This bug was resolved 4 years ago, do you still having issues? If so, please file new bug report, describe your issues, provide commands you are using and their output. Thanks.

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