Mysql55-devel package dependancy tree is broken

[Philip Eatherington]

Found this today when some of our automation broke on CentOS 6.4 servers.

mysql55-devel requires mysqlclient16 as a dependancy, but the two conflict on file /usr/share/aclocal/mysql.m4. Here's the full output:

[root@phil-cent-test ~]# yum install mysql55-devel
Loaded plugins: downloadonly, fastestmirror, priorities
Loading mirror speeds from cached hostfile
 * base: mirror.rackspace.com
 * community_base: mirrors.loosefoot.com
 * community_extras: mirrors.loosefoot.com
 * community_updates: mirrors.loosefoot.com
 * cr: mirror.rackspace.com
 * epel: mirror.rackspace.com
 * extras: mirror.rackspace.com
 * ius: mirror.rackspace.com
 * updates: mirror.rackspace.com
drivesrvr | 951 B 00:00
7650 packages excluded due to repository priority protections
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-devel.x86_64 0:5.5.33-1.ius.el6 will be installed
--> Processing Dependency: mysql55-libs = 5.5.33-1.ius.el6 for package: mysql55-devel-5.5.33-1.ius.el6.x86_64
--> Processing Dependency: mysql55 = 5.5.33-1.ius.el6 for package: mysql55-devel-5.5.33-1.ius.el6.x86_64
--> Processing Dependency: openssl-devel for package: mysql55-devel-5.5.33-1.ius.el6.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: mysql55-devel-5.5.33-1.ius.el6.x86_64
--> Running transaction check
---> Package mysql55.x86_64 0:5.5.33-1.ius.el6 will be installed
--> Processing Dependency: mysqlclient16 for package: mysql55-5.5.33-1.ius.el6.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql55-5.5.33-1.ius.el6.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql55-5.5.33-1.ius.el6.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql55-5.5.33-1.ius.el6.x86_64
---> Package mysql55-libs.x86_64 0:5.5.33-1.ius.el6 will be installed
---> Package openssl-devel.x86_64 0:1.0.0-27.el6_4.2 will be installed
--> Processing Dependency: zlib-devel for package: openssl-devel-1.0.0-27.el6_4.2.x86_64
--> Processing Dependency: pkgconfig for package: openssl-devel-1.0.0-27.el6_4.2.x86_64
--> Processing Dependency: krb5-devel for package: openssl-devel-1.0.0-27.el6_4.2.x86_64
--> Processing Dependency: /usr/bin/pkg-config for package: openssl-devel-1.0.0-27.el6_4.2.x86_64
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.10.3-10.el6_4.4 will be installed
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.10.3-10.el6_4.4.x86_64
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.10.3-10.el6_4.4.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.10.3-10.el6_4.4.x86_64
---> Package libaio.x86_64 0:0.3.107-10.el6 will be installed
---> Package mysqlclient16.x86_64 0:5.1.61-1.ius.el6 will be installed
---> Package pkgconfig.x86_64 1:0.23-9.1.el6 will be installed
---> Package zlib-devel.x86_64 0:1.2.3-29.el6 will be installed
--> Running transaction check
---> Package keyutils-libs-devel.x86_64 0:1.4-4.el6 will be installed
---> Package libcom_err-devel.x86_64 0:1.41.12-14.el6_4.2 will be installed
---> Package libselinux-devel.x86_64 0:2.0.94-5.3.el6_4.1 will be installed
--> Processing Dependency: libsepol-devel >= 2.0.32-1 for package: libselinux-devel-2.0.94-5.3.el6_4.1.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.0.94-5.3.el6_4.1.x86_64
--> Running transaction check
---> Package libsepol-devel.x86_64 0:2.0.41-4.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================================
 Package Arch Version Repository Size
=======================================================================================================================
Installing:
 mysql55-devel x86_64 5.5.33-1.ius.el6 ius 170 k
Installing for dependencies:
 keyutils-libs-devel x86_64 1.4-4.el6 community_base 28 k
 krb5-devel x86_64 1.10.3-10.el6_4.4 community_updates 494 k
 libaio x86_64 0.3.107-10.el6 community_base 21 k
 libcom_err-devel x86_64 1.41.12-14.el6_4.2 community_updates 32 k
 libselinux-devel x86_64 2.0.94-5.3.el6_4.1 community_updates 136 k
 libsepol-devel x86_64 2.0.41-4.el6 community_base 64 k
 mysql55 x86_64 5.5.33-1.ius.el6 ius 9.1 M
 mysql55-libs x86_64 5.5.33-1.ius.el6 ius 783 k
 mysqlclient16 x86_64 5.1.61-1.ius.el6 ius 3.8 M
 openssl-devel x86_64 1.0.0-27.el6_4.2 community_updates 1.1 M
 pkgconfig x86_64 1:0.23-9.1.el6 community_base 70 k
 zlib-devel x86_64 1.2.3-29.el6 community_base 44 k

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

Total size: 16 M
Installed size: 64 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test

Transaction Check Error:
  file /usr/share/aclocal/mysql.m4 conflicts between attempted installs of mysql55-devel-5.5.33-1.ius.el6.x86_64 and mysqlclient16-5.1.61-1.ius.el6.x86_64

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

[bharper (bharper)]

Hello Philip,

Thanks for reporting this bug. I did ran into this issue during my testing and I thought it got corrected. I will look into this issue.

What mysql packages were installed before attempting to install mysql55-devel?

-Ben

[Philip Eatherington (philip-eatherington)]

Hey Ben,

There are no mysql package installed at this point. The first thing our automation does is to take out the mysql-libs and mysql that are for 5.1, then tries to install devel.

[root@phil-cent-test ~]# rpm -qa *mysql*
[root@phil-cent-test ~]#

-Phil

[bharper (bharper)]

Both the mysql55-devel and mysqlclient16 packages owned the /usr/share/aclocal/mysql.m4 file. It has been like this for the life of both packages. It has never been as issue as files within both packages have been the same. With MySQL 5.5.33, this file got changed. It was decided that we would take the path of least resistance (which we might need to reconsider) with the follow patch for the mysqlclient16 package:

https://github.com/iuscommunity-pkg/mysqlclient16/blob/99b1638d1511c65a787bddac008ce9b73f3b754d/SOURCES/mysql.m4.patch

The updated mysql55 package got pushed to the stable repos last night, but the mysqlclient16 packaged did not. I am manually running our script that pushes packages into the stable repo. Typically it takes about 3.5 hours to complete. This bug will get updated when the script completes.

Sorry for any confusion this might have caused.

-Ben

[bharper (bharper)]

The script has completed and I was able to install mysql55-devel. Please note it might take up to 24 hours for all the mirrors to get updated.

-Ben