ius-coredev team mailing list archive

[BJ Dierkes <wdierkes@xxxxxxxxxxxxx>]

On Jan 18, 2010, at 3:26 PM, Jim Barrick wrote:

> BJ,
> 
> I'm a bit new at this, but learning quickly.

Not a problem at all.


> 
> Yes, I can follow these instructions.  But why would I not remowe the 
> existing instance of perl-DBD-MySQL first?  (Consistent with the general 
> upgrade approach IUS advises for PHP, etc).
> 

The issue is something to do with how Yum is resolving dependencies in
the shell:

STOCK:

$ rpm -q --requires mysql-server | grep perl-DBD-MySQL
perl-DBD-MySQL  

IUS MySQL 5.1:

$ rpm -q --requires mysql51-server | grep perl-DBD-MySQL
perl-DBD-MySQL  


If you had no mysql installed at all, and issues 'yum install mysql51 mysql51-server mysql51-devel' the perl-DBD-MySQL dependency gets added as you would expect and all is well.  That said, I believe what is really happening is that the only thing installed that requires perl-DBD-MySQL is mysql-server:

$ rpm -q --whatrequires perl-DBD-MySQL
mysql-server-5.0.77-4.el5_4.1


Therefore, if you remove something with Yum it will also remove the dependencies if nothing else installed relies on them which I believe is happening with the mysql51 upgrade process.  The reason we suggested using the --shell is because I didn't want to be quoted as telling anyone to 'rpm -e --nodeps ...' something before installing from IUS, but one could also do it that way if one so chooses.  However, using the --shell process anding perl-DBD-MySQL to the install is recommended.  

I am going to update the wiki with that info now.

---
BJ Dierkes
Linux Systems Engineer IV / [RH]acker
Infrastructure Services [OS & Applications]
Rackspace Hosting

-- 
mysql51 upgrade issue with perl-DBD-MySQL
https://bugs.launchpad.net/bugs/508426
You received this bug notification because you are a member of IUS Core
Development, which is subscribed to IUS Community Project.

Status in IUS Community Project: Confirmed

Bug description:
It appears that we found bug 434120 recurring with 5.1.41 x86_64 in an attempt to upgrade 5.077 on Centos 5.4.  Error transcript is almost identical issue reported by:

[Ius-coredev] [Bug 434120] Re: MySQL 5.1.39 Source Update
Rudd-O
Tue, 01 Dec 2009 11:41:00 -0800 

Here's the tail of the session...

--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
---> Package mysqlclient15.x86_64 0:5.0.85-1.ius.el5 set to be updated
---> Package mysqlclient15-devel.x86_64 0:5.0.85-1.ius.el5 set to be updated
---> 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
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be erased
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.6.1-36.el5_4.1 set to be updated
--> Processing Dependency: krb5-libs = 1.6.1-36.el5_4.1 for package: krb5-devel
--> 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 mysql51-server.x86_64 0:5.1.41-2.ius.el5 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be erased
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
---> 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
--> Processing Dependency: krb5-libs = 1.6.1-36.el5 for package: krb5-workstation
---> Package krb5-libs.i386 0:1.6.1-36.el5_4.1 set to be updated
---> Package krb5-libs.x86_64 0:1.6.1-36.el5_4.1 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
---> Package mysql51-server.x86_64 0:5.1.41-2.ius.el5 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be erased
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
--> Running transaction check
---> Package krb5-workstation.x86_64 0:1.6.1-36.el5_4.1 set to be updated
---> Package libsepol-devel.x86_64 0:1.15.2-2.el5 set to be updated
---> Package mysql51-server.x86_64 0:5.1.41-2.ius.el5 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be erased
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
--> Finished Dependency Resolution
mysql51-server-5.1.41-2.ius.el5.x86_64 from ius has depsolving problems
  --> Missing Dependency: perl-DBD-MySQL is needed by package mysql51-server-5.1.41-2.ius.el5.x86_64 (ius)
mysql51-server-5.1.41-2.ius.el5.x86_64 from ius has depsolving problems
  --> Missing Dependency: perl-DBD-MySQL is needed by package mysql51-server-5.1.41-2.ius.el5.x86_64 (ius)
Error: Missing Dependency: perl-DBD-MySQL is needed by package mysql51-server-5.1.41-2.ius.el5.x86_64 (ius)
> transaction run
--> Running transaction check
---> Package mysql51-server.x86_64 0:5.1.41-2.ius.el5 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be erased
--> Processing Dependency: perl-DBD-MySQL for package: mysql51-server
--> Finished Dependency Resolution
mysql51-server-5.1.41-2.ius.el5.x86_64 from ius has depsolving problems
  --> Missing Dependency: perl-DBD-MySQL is needed by package mysql51-server-5.1.41-2.ius.el5.x86_64 (ius)
mysql51-server-5.1.41-2.ius.el5.x86_64 from ius has depsolving problems
  --> Missing Dependency: perl-DBD-MySQL is needed by package mysql51-server-5.1.41-2.ius.el5.x86_64 (ius)
Error: Missing Dependency: perl-DBD-MySQL is needed by package mysql51-server-5.1.41-2.ius.el5.x86_64 (ius)
> quit