mysql51-5.1.41-1.ius.el5.x86_64 from ius has depsolving problems ---> mysql51 conflicts with mysql50

[sugor09]

[root@dev7 vmops-management-dist]# yum install -y mysql51-server mysql51
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * addons: mirror.facebook.net
 * base: mirror.nic.uoregon.edu
 * epel: mirror.umoss.org
 * extras: mirrors.easynews.com
 * ius: dl.iuscommunity.org
 * updates: mirror.nic.uoregon.edu
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql51.x86_64 0:5.1.41-1.ius.el5 set to be updated
--> Processing Dependency: mysqlclient15-devel for package: mysql51
--> Processing Dependency: mysqlclient15 for package: mysql51
---> Package mysql51-server.x86_64 0:5.1.41-1.ius.el5 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
--> Running transaction check
---> Package mysql50.x86_64 0:5.0.88-1.ius.el5 set to be updated
---> Package mysql50-devel.x86_64 0:5.0.88-1.ius.el5 set to be updated
--> Processing Dependency: openssl-devel for package: mysql50-devel
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Running transaction check
---> Package openssl-devel.x86_64 0:0.9.8e-12.el5 set to be updated
--> Processing Dependency: zlib-devel for package: openssl-devel
--> Processing Dependency: krb5-devel for package: openssl-devel
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.6.1-36.el5 set to be updated
--> Processing Dependency: libselinux-devel for package: krb5-devel
--> Processing Dependency: e2fsprogs-devel for package: krb5-devel
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel
---> Package zlib-devel.x86_64 0:1.2.3-3 set to be updated
--> Running transaction check
---> Package e2fsprogs-devel.x86_64 0:1.39-23.el5 set to be updated
---> Package keyutils-libs-devel.x86_64 0:1.2-1.el5 set to be updated
---> Package libselinux-devel.x86_64 0:1.33.4-5.5.el5 set to be updated
--> Processing Dependency: libsepol-devel >= 1.15.2-1 for package: libselinux-devel
--> Running transaction check
---> Package libsepol-devel.x86_64 0:1.15.2-2.el5 set to be updated
--> Processing Conflict: mysql51 conflicts mysql < 5.1
--> Processing Conflict: mysql51 conflicts mysql50
--> Processing Conflict: mysql50 conflicts mysql51
--> Finished Dependency Resolution
mysql51-5.1.41-1.ius.el5.x86_64 from ius has depsolving problems
  --> mysql51 conflicts with mysql50
mysql50-5.0.88-1.ius.el5.x86_64 from ius has depsolving problems
  --> mysql50 conflicts with mysql51
Error: mysql51 conflicts with mysql50
Error: mysql50 conflicts with mysql51
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
[root@dev7 vmops-management-dist]#

I see the same error even after a yum update.

[BJ Dierkes (derks)]

Do you have mysql50 installed? Can you provide the output of "rpm -qa | grep -i mysql"?

[BJ Dierkes (derks)]

Nevermind... confirmed:

[root@centos5-2 ~]# rpm -qa | grep mysql
[root@centos5-2 ~]# echo $?

[root@centos5-2 ~]# yum install mysql51 mysql51-server
epel | 3.4 kB 00:00
aaad8b1e3323490e8d92b6c5cdea04f96263749b-primary.sqlite.bz2 | 2.7 MB 00:01
base | 2.1 kB 00:00
updates | 1.9 kB 00:00
primary.sqlite.bz2 | 320 kB 00:00
addons | 951 B 00:00
Could not retrieve mirrorlist http://dl.iuscommunity.org/mirrorlist?repo=ius-el5&arch=x86_64 error was
[Errno 14] HTTP Error 500: Internal Server Error
ius | 1.9 kB 00:00
primary.sqlite.bz2 | 91 kB 00:00
extras | 1.1 kB 00:00
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package mysql51.x86_64 0:5.1.41-1.ius.el5 set to be updated
--> Processing Dependency: mysqlclient15-devel for package: mysql51
--> Processing Dependency: mysqlclient15 for package: mysql51
---> Package mysql51-server.x86_64 0:5.1.41-1.ius.el5 set to be updated
--> Running transaction check
---> Package mysql50.x86_64 0:5.0.88-1.ius.el5 set to be updated
---> Package mysql50-devel.x86_64 0:5.0.88-1.ius.el5 set to be updated
--> Processing Conflict: mysql51 conflicts mysql < 5.1
--> Processing Conflict: mysql51 conflicts mysql50
--> Processing Conflict: mysql50 conflicts mysql51
--> Finished Dependency Resolution
mysql51-5.1.41-1.ius.el5.x86_64 from ius has depsolving problems
  --> mysql51 conflicts with mysql50
mysql50-5.0.88-1.ius.el5.x86_64 from ius has depsolving problems
  --> mysql50 conflicts with mysql51
Error: mysql51 conflicts with mysql50
Error: mysql50 conflicts with mysql51

This might be a regression with mysql50-5.0.88 .....

[BJ Dierkes (derks)]

Unfortunately this is a regression... that somehow made it back into mysql50-5.0.88 ... likely happened during a harddrive crash where I wasn't able to commit bzr changes.

[wdierkes@220805-mock00 mysql50]$ bzr diff SPECS/mysql50.spec
=== modified file 'SPECS/mysql50.spec'
--- SPECS/mysql50.spec 2009-11-24 23:29:16 +0000
+++ SPECS/mysql50.spec 2009-12-01 19:48:04 +0000
@@ -46,7 +46,7 @@

 Name: %{name}
 Version: 5.0.88
-Release: 1.ius%{?dist}
+Release: 2.ius%{?dist}
 Summary: MySQL client programs and shared libraries.
 License: GPL
 Vendor: IUS Community Project
@@ -91,7 +91,6 @@
 Obsoletes: mysql-client mysql-perl
 Conflicts: MySQL

-Provides: mysqlclient15 = %{version}-%{release}
 Provides: %{real_name} = %{version}-%{release}
 Conflicts: %{real_name} < %{basever}
 Conflicts: mysql51
@@ -160,7 +159,6 @@
 Requires: openssl-devel
 Conflicts: MySQL-devel
 Provides: %{real_name}-devel = %{version}-%{release}
-Provides: mysqlclient15-devel = %{version}-%{release}
 Conflicts: %{real_name}-devel < %{base_ver}
 Conflicts: mysql51-devel

@@ -744,6 +742,9 @@

 %changelog
+* Tue Dec 01 2009 BJ Dierkes <email address hidden> - 5.0.88-2.ius
+- No longer provide mysqlclient/mysqlclient-devel (regression)
+
 * Tue Nov 23 2009 BJ Dierkes <email address hidden> - 5.0.88-1.ius
 - Latest sources from upstream.
 - Removed Patch223: mysql-5.0.85-disabled-tests.patch

You can get around this by adding 'exclude=mysql50*' to your ius.repo yum config ... mysql50-5.0.88-2.ius is currently building with this fix... and should be pushed out promptly (hopefully before eob today).

[sugor09 (sumita-gorla)]

Hello BJ

[root@dev7 vmops-management-dist]# rpm -qa |grep -i mysql
[root@dev7 vmops-management-dist]#
I do not have anythign installed right now.

On Tue, Dec 1, 2009 at 11:40 AM, BJ Dierkes <email address hidden> wrote:

> Do you have mysql50 installed? Can you provide the output of "rpm -qa |
> grep -i mysql"?
>
> ** Branch linked: lp:ius/mysql51
>
> --
> mysql51-5.1.41-1.ius.el5.x86_64 from ius has depsolving problems --->
> mysql51 conflicts with mysql50
> https://bugs.launchpad.net/bugs/490983
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in IUS Community Project: New
>
> Bug description:
> [root@dev7 vmops-management-dist]# yum install -y mysql51-server mysql51
> Loaded plugins: fastestmirror
> Loading mirror speeds from cached hostfile
> * addons: mirror.facebook.net
> * base: mirror.nic.uoregon.edu
> * epel: mirror.umoss.org
> * extras: mirrors.easynews.com
> * ius: dl.iuscommunity.org
> * updates: mirror.nic.uoregon.edu
> Setting up Install Process
> Resolving Dependencies
> --> Running transaction check
> ---> Package mysql51.x86_64 0:5.1.41-1.ius.el5 set to be updated
> --> Processing Dependency: mysqlclient15-devel for package: mysql51
> --> Processing Dependency: mysqlclient15 for package: mysql51
> ---> Package mysql51-server.x86_64 0:5.1.41-1.ius.el5 set to be updated
> --> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
> --> Running transaction check
> ---> Package mysql50.x86_64 0:5.0.88-1.ius.el5 set to be updated
> ---> Package mysql50-devel.x86_64 0:5.0.88-1.ius.el5 set to be updated
> --> Processing Dependency: openssl-devel for package: mysql50-devel
> ---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
> --> Running transaction check
> ---> Package openssl-devel.x86_64 0:0.9.8e-12.el5 set to be updated
> --> Processing Dependency: zlib-devel for package: openssl-devel
> --> Processing Dependency: krb5-devel for package: openssl-devel
> --> Running transaction check
> ---> Package krb5-devel.x86_64 0:1.6.1-36.el5 set to be updated
> --> Processing Dependency: libselinux-devel for package: krb5-devel
> --> Processing Dependency: e2fsprogs-devel for package: krb5-devel
> --> Processing Dependency: keyutils-libs-devel for package: krb5-devel
> ---> Package zlib-devel.x86_64 0:1.2.3-3 set to be updated
> --> Running transaction check
> ---> Package e2fsprogs-devel.x86_64 0:1.39-23.el5 set to be updated
> ---> Package keyutils-libs-devel.x86_64 0:1.2-1.el5 set to be updated
> ---> Package libselinux-devel.x86_64 0:1.33.4-5.5.el5 set to be updated
> --> Processing Dependency: libsepol-devel >= 1.15.2-1 for package:
> libselinux-devel
> --> Running transaction check
> ---> Package libsepol-devel.x86_64 0:1.15.2-2.el5 set to be updated
> --> Processing Conflict: mysql51 conflicts mysql < 5.1
> --> Processing Conflict: mysql51 conflicts mysql50
> --> Processing Conflict: mysql50 conflicts mysql51
> --> Finished Dependency Resolution
> mysql51-5.1.41-1.ius.el5.x86_64 from ius has depsolving problems
> --> mysql51 conflicts with mysql50
> mysql50-5.0.88-1.ius.el5.x86_64 from ius has depsolving problems
> --> mysql50 conflicts with mys...

[Rudd-O (rudd-o)]

You should know that the smart package manager succeeds in installing the package even with this (unless the fix got actually uploaded in the last few minutes). You should also know that the smart package manager installs mysqlclient15-devel for some reason:

Installing packages (3):
  mysql51-5.1.41-1.ius.el5@x86_64
    Requires:
      mysql51-5.1.41-1.ius.el5@x86_64 (installed)
      mysqlclient15-devel-5.0.85-1.ius.el5@x86_64 (installed)
      mysqlclient15-5.0.85-1.ius.el5@x86_64 (installed)
    Required By:
      mysql51-5.1.41-1.ius.el5@x86_64 (installed)
  mysqlclient15-5.0.85-1.ius.el5@x86_64
    Required By:
      mysqlclient15-devel-5.0.85-1.ius.el5@x86_64 (installed)
      mysql51-5.1.41-1.ius.el5@x86_64 (installed)
  mysqlclient15-devel-5.0.85-1.ius.el5@x86_64
    Requires:
      mysqlclient15-5.0.85-1.ius.el5@x86_64 (installed)
    Required By:
      mysql51-5.1.41-1.ius.el5@x86_64 (installed)

It makes NO SENSE to me why the mysql51 package would require the lib-devel package installed, which in turn requires the lib package installed. But at least with the smart package manager the packages are installed, erm, smartly :-)

[BJ Dierkes (derks)]

mysql51 requires mysqlclient15 to resolve backward compatibility with anything built against stock mysql-5.0 (php-mysql, etc). Actually, mysql51 doesn't require it, but it makes the transition smooth for everything else that does require libmysqlclient.so.15 (mysql-5.0 libraries) so we require it in mysql51. The mysql50 package had a legacy 'Provides: mysqlclient15' that was removed in 5.0.86-2.ius but due to a harddrive crash that change was lost before I had a chance to commit it to bazaar. I verified against the source rpm that that was the only change missing.

Many apologies, mysql50-5.0.88-2.ius will be out soon fixing this conflict.

Thanks for the feedback and understanding on this.

[BJ Dierkes (derks)]

As a side note, mysql51 was tested however it was tested before mysql50-5.0.88 was pushed to testing therefore this conflict wouldn't have been apparent without testing mysql51 again.

A weekly testing report is emailed to the ius-community mailing list every Monday. You can subscribe by joining the ius-community team in launchpad and subscribing to the team mailing list. Currently we don't get any feedback on testing before we push anything.... so any help is much appreciated. ;)

[BJ Dierkes (derks)]

This is resolved for ius-el5, and ius-el4 stable... please note that it will take up to 24 hours for all mirrors to sync with dl.iuscommunity.org:

[root@centos5-2 ~]# yum clean all
Cleaning up Everything

[root@centos5-2 ~]# yum install mysql51 mysql51-server
epel | 3.4 kB 00:00
aaad8b1e3323490e8d92b6c5cdea04f96263749b-primary.sqlite.bz2 | 2.7 MB 00:00
base | 2.1 kB 00:00
primary.sqlite.bz2 | 2.0 MB 00:00
updates | 1.9 kB 00:00
primary.sqlite.bz2 | 320 kB 00:00
addons | 951 B 00:00
primary.xml.gz | 203 B 00:00
ius | 1.9 kB 00:00
primary.sqlite.bz2 | 91 kB 00:00
extras | 1.1 kB 00:00
primary.xml.gz | 117 kB 00:00
extras 290/290
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package mysql51.x86_64 0:5.1.41-1.ius.el5 set to be updated
--> Processing Dependency: mysqlclient15-devel for package: mysql51
--> Processing Dependency: mysqlclient15 for package: mysql51
---> Package mysql51-server.x86_64 0:5.1.41-1.ius.el5 set to be updated
--> Running transaction check
---> Package mysqlclient15-devel.x86_64 0:5.0.85-1.ius.el5 set to be updated
---> Package mysqlclient15.x86_64 0:5.0.85-1.ius.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================
 Package Arch Version Repository Size
====================================================================================================
Installing:
 mysql51 x86_64 5.1.41-1.ius.el5 ius 5.5 M
 mysql51-server x86_64 5.1.41-1.ius.el5 ius 11 M
Installing for dependencies:
 mysqlclient15 x86_64 5.0.85-1.ius.el5 ius 1.7 M
 mysqlclient15-devel x86_64 5.0.85-1.ius.el5 ius 187 k

Transaction Summary
====================================================================================================
Install 4 Package(s)
Update 0 Package(s)
Remove 0 Package(s)

Total download size: 18 M
Is this ok [y/N]: y
Downloading Packages:...

[sugor09 (sumita-gorla)]

Thank you.

On Tue, Dec 1, 2009 at 1:40 PM, BJ Dierkes <email address hidden> wrote:

> This is resolved for ius-el5, and ius-el4 stable... please note that it
> will take up to 24 hours for all mirrors to sync with
> dl.iuscommunity.org:
>
> [root@centos5-2 ~]# yum clean all
> Cleaning up Everything
>
> [root@centos5-2 ~]# yum install mysql51 mysql51-server
> epel
> | 3.4 kB 00:00
> aaad8b1e3323490e8d92b6c5cdea04f96263749b-primary.sqlite.bz2
> | 2.7 MB 00:00
> base
> | 2.1 kB 00:00
> primary.sqlite.bz2
> | 2.0 MB 00:00
> updates
> | 1.9 kB 00:00
> primary.sqlite.bz2
> | 320 kB 00:00
> addons
> | 951 B 00:00
> primary.xml.gz
> | 203 B 00:00
> ius
> | 1.9 kB 00:00
> primary.sqlite.bz2
> | 91 kB 00:00
> extras
> | 1.1 kB 00:00
> primary.xml.gz
> | 117 kB 00:00
> extras 290/290
> Setting up Install Process
> Parsing package install arguments
> Resolving Dependencies
> --> Running transaction check
> ---> Package mysql51.x86_64 0:5.1.41-1.ius.el5 set to be updated
> --> Processing Dependency: mysqlclient15-devel for package: mysql51
> --> Processing Dependency: mysqlclient15 for package: mysql51
> ---> Package mysql51-server.x86_64 0:5.1.41-1.ius.el5 set to be updated
> --> Running transaction check
> ---> Package mysqlclient15-devel.x86_64 0:5.0.85-1.ius.el5 set to be
> updated
> ---> Package mysqlclient15.x86_64 0:5.0.85-1.ius.el5 set to be updated
> --> Finished Dependency Resolution
>
> Dependencies Resolved
>
>
> ====================================================================================================
> Package Arch Version
> Repository Size
>
> ====================================================================================================
> Installing:
> mysql51 x86_64 5.1.41-1.ius.el5
> ius 5.5 M
> mysql51-server x86_64 5.1.41-1.ius.el5
> ius 11 M
> Installing for dependencies:
> mysqlclient15 x86_64 5.0.85-1.ius.el5
> ius 1.7 M
> mysqlclient15-devel x86_64 5.0.85-1.ius.el5
> ius 187 k
>
> Transaction Summary
>
> ====================================================================================================
> Install 4 Package(s)
> Update 0 Package(s)
> Remove 0 Package(s)
>
> Total download size: 18 M
> Is this ok [y/N]: y
> Downloading Packages:
> (1/4): mysqlclient15-devel-5.0.85-1.ius.el5.x86_64.rpm
> | 187 kB 00:00
> (2/4): mysqlclient15-5.0.85-1.ius.el5.x86_64.rpm
> | 1.7 MB 00:00
> (3/4): mysql51-5.1.41-1.ius.el5.x86_64.rpm
> | 5.5 MB 00:00
> (4/4): mysql51-server-5.1.41-1.ius.el5.x86_64.rpm
> | 11 MB 00:01
>
> ----------------------------------------------------------------------------------------------------
> Total 9.3
> MB/s | 18 MB 00:01
> Running rpm_check_debug
> Running Transaction Test
> Finished Transaction Test
> Transaction Test Succeeded
> Running T...

[Rudd-O (rudd-o)]

BJ,

You rock. It works now. Ninja skills, many thanks.

[Rudd-O (rudd-o)]

one more question: why is mysqlclient15-devel required by a yum install mysql51??? I don't think .h files are needed to run the clients, right? There's an extra unnecessary dep there, and it might cause lots of devel stuff to get pulled in a non-devel machine.

[BJ Dierkes (derks)]

That is a bit of a legacy process, and looking back I think it was decided to install both as a convenience should anything require it from stock packages. That said, if anything is going to be compiled with mysql51 installed you'd want to, and would be compiling against MySQL 5.1 and not mysqlclient15-devel header files.

If you could report a separate bug report regarding 'removing unnecessary dependency of mysqlclient15-devel' I will look into removing and testing it out. You can also submit a merge request:

See http://wiki.iuscommunity.org/Doc/DeveloperGuide#Contributing_Packages_or_Changes