Bug 697

Summary: Update of package libmysqlservices blocked by package libmysql16
Product: Mageia Reporter: Dave Hodgins <davidwhodgins>
Component: RPM PackagesAssignee: Mageia Bug Squad <bugsquad>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: Normal CC: balcaen.john, dmorganec
Version: Cauldron   
Target Milestone: ---   
Hardware: i586   
OS: Linux   
Whiteboard:
Source RPM: mysql-5.5.10-6.mga1.src.rpm CVE:
Status comment:
Attachments: Output of urpmi --auto-update --debug
Output of urpmi --auto-update --debug after reverting gvfs

Description Dave Hodgins 2011-04-08 04:43:04 CEST
From urpmi --auto-select ...

libmysqlservices-5.5.10-6.mga1.i586 (in order to keep libmysql16-5.1.55-0.1mdv2010.2.i586)
Comment 1 John Balcaen 2011-04-08 05:51:49 CEST
You're using urpmi --auto-select or urpmi --auto-select --keep ?

CC: (none) => balcaen.john

Comment 2 Dave Hodgins 2011-04-08 09:19:44 CEST
The actual command I use is ...
urpmi --auto-select --keep --resume --noclean --allow-force --allow-nodeps

Yes, I was using --keep, although I've forgotten why I had it in there.

I've now removed the --keep, but still get ...

[root@hodgins ~]# ./autoselect 
urpmi --auto-select --resume --noclean --allow-force --allow-nodeps
+ urpmi --auto-select --resume --noclean --allow-force --allow-nodeps
Some requested packages cannot be installed:
boo-0.9.3-3.mga1.noarch (in order to keep banshee-2.0.0-1mdv2010.2.i586)
gkrellm-2.3.5-1.mga1.i586 (in order to keep gkrellm-plugins-mms-2.3.4-3mdv2010.1.i586)
java-1.6.0-openjdk-1.6.0.0-14.b22.1.mga1.i586 (in order to keep java-1.6.0-openjdk-plugin-1.6.0.0-13.1.9.6.1.mga1.i586)
java-1.6.0-openjdk-devel-1.6.0.0-14.b22.1.mga1.i586 (due to conflicts with java-1.6.0-openjdk-1.6.0.0-14.b22.1.mga1.i586, trying to promote java-1.6.0-openjdk)
libgoogle-data-mono-1.6.0.0-2.mga1.noarch (in order to keep banshee-2.0.0-1mdv2010.2.i586)
libmysqlservices-5.5.10-6.mga1.i586 (in order to keep libmysql16-5.1.55-0.1mdv2010.2.i586)
libopensc3-0.12.0-3.mga1.i586 (in order to keep mozilla-plugin-opensc-0.11.13-1.1mdv2010.2.i586)
libquicktime-1.2.2-2.mga1.i586 (in order to keep libquicktime-faad-1.1.5-2plf2010.1.i586)
ruby-atk-0.90.8-1.mga1.i586 (due to conflicts with ruby-glib2-0.90.8-1.mga1.i586, trying to promote ruby-glib2)
ruby-glib2-0.90.8-1.mga1.i586 (in order to keep ruby-gdkpixbuf2-0.19.2-2mdv2010.1.i586)
ruby-pango-0.90.8-1.mga1.i586 (due to conflicts with ruby-glib2-0.90.8-1.mga1.i586, trying to promote ruby-glib2)
speech_tools-2.1-2.mga1.i586 (in order to keep libspeech_tools1-1.2.96-12mdv2010.1.i586)
tomoyo-tools-2.3.0-2.mga1.i586 (in order to keep tomoyo-gui-0.05-2mdv2010.1.i586)
Continue installation anyway? (Y/n) y
[root@hodgins ~]#

So the --keep doesn't seem to be a factor.
Comment 3 John Balcaen 2011-04-08 12:19:01 CEST
Could you attach the result of
urpmi --auto-update --debug
Comment 4 John Balcaen 2011-04-08 13:25:46 CEST
could you also provide your /etc/urpmi/skip.list ?
Comment 5 Dave Hodgins 2011-04-08 21:47:15 CEST
Created attachment 213 [details]
Output of urpmi --auto-update --debug

The skip list contains ...
dvd+rw-tools
cdrkit
cdrkit-isotools
cdrkit-genisoimage
Comment 6 Dave Hodgins 2011-04-08 22:04:54 CEST
Just fyi, I removed those packages from the skip list, and installed mageia
versions of those packages, but the urpmi --auto-select still fails for
libmysqlservices as before.
Comment 7 Ahmad Samir 2011-04-08 23:37:37 CEST
A bit off-topic:
gvfs-1.6.7-1.mga1.i586 (in order to keep libgvfs0-1.7.2-2.mga1.i586)

you'll need to revert this one manually c.f. https://www.mageia.org/pipermail/mageia-dev/20110408/003910.html

Could you attach the output of:
urpme --test libmysql16
Comment 8 Dave Hodgins 2011-04-09 00:42:18 CEST
I haven't reverted yet, as ibiblio.org is still showing gvfs-1.7.2-2.

[root@hodgins ~]# urpme --test libmysql16
To satisfy dependencies, the following 12 packages will be removed (26MB):
  gambas2-gb-db-mysql-2.22.0-1mdv2010.1.i586
   (due to missing libmysqlclient.so.16)
  gambas2-ide-2.22.0-1mdv2010.1.i586
   (due to unsatisfied gambas2-gb-db-mysql == 2.22.0)
  libmysql-devel-5.1.55-0.1mdv2010.2.i586
   (due to unsatisfied libmysql16 == 5.1.55-0.1mdv2010.2,
    due to unsatisfied libmysql16 == 5.1.55-0.1mdv2010.2)
  libmysql16-5.1.55-0.1mdv2010.2.i586
  ntop-4.0-1mdv2010.1.i586
   (due to missing libmysqlclient_r.so.16)
  php-mysql-5.3.6-0.1mdv2010.2.i586
   (due to missing libmysqlclient.so.16)
  php-mysqli-5.3.6-0.1mdv2010.2.i586
   (due to missing libmysqlclient.so.16)
  php-pdo_mysql-5.3.6-0.1mdv2010.2.i586
   (due to missing libmysqlclient.so.16)
  php-pear-MDB2_Driver_mysql-1.5.0-0.0.b2.2.mga1.noarch
   (due to missing php-mysql)
  php-pear-MDB2_Driver_mysqli-1.5.0-0.0.b2.2.mga1.noarch
   (due to missing php-mysqli)
  phpmyadmin-3.3.10-0.1mdv2010.2.noarch
   (due to missing php-mysql)
  task-lamp-php-2009.1-2.mga1.noarch
   (due to missing php-mysql)
Remove 12 packages? (y/N) y
testing removal of gambas2-gb-db-mysql-2.22.0-1mdv2010.1.i586 gambas2-ide-2.22.0-1mdv2010.1.i586 libmysql-devel-5.1.55-0.1mdv2010.2.i586 libmysql16-5.1.55-0.1mdv2010.2.i586 ntop-4.0-1mdv2010.1.i586 php-mysql-5.3.6-0.1mdv2010.2.i586 php-mysqli-5.3.6-0.1mdv2010.2.i586 php-pdo_mysql-5.3.6-0.1mdv2010.2.i586 php-pear-MDB2_Driver_mysql-1.5.0-0.0.b2.2.mga1.noarch php-pear-MDB2_Driver_mysqli-1.5.0-0.0.b2.2.mga1.noarch phpmyadmin-3.3.10-0.1mdv2010.2.noarch task-lamp-php-2009.1-2.mga1.noarch
Removal is possible
Comment 9 Dave Hodgins 2011-04-10 19:23:04 CEST
Created attachment 223 [details]
Output of urpmi --auto-update --debug after reverting gvfs

After reverting gvfs to 1.6.7-1, libmysqlservices is still blocked by
libmysql16.
Comment 10 John Balcaen 2011-04-11 13:09:55 CEST
A fast summary:
the mysqlservice.so file was wrongly included in the libmysql16 package, this file  has been removed & put in his own package (liblmysqlservice) in mageia.
However it seems that you have several package still linked to libmysql16 which are not available on mageia ( gambas packages for example or nop),due to that dependency libmysql16 can't be removed cleanly (especially since we added a conflict against this package in libmysqlservices).   
A workaround is to remove the mysql-devel package (this one is pulling libmysqlservices package) to upgrade your box to mageia.
We need to import ntop/gambas so thoses packages can also be upgraded.
Comment 11 D Morgan 2011-08-12 23:54:16 CEST
what about this  bug in current cauldron ?

CC: (none) => dmorganec

Comment 12 Dave Hodgins 2011-08-13 01:03:48 CEST
# urpmi mysql-devel
The following package has to be removed for others to be upgraded:
libmysql16-5.1.55-0.1mdv2010.2.i586
 (due to conflicts with libmysqlservices-5.5.13-3.mga2.i586) (y/N) y
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch   
(medium "Core Release")
  libmysql-devel                 5.5.13       3.mga2        i586    
  libmysqlservices               5.5.13       3.mga2        i586    
4.4MB of additional disk space will be used.
1.4MB of packages will be retrieved.
Proceed with the installation of the 2 packages? (Y/n) y


    http://distrib-coffee.ipsl.jussieu.fr/pub/linux/Mageia/distrib/cauldron/i586/media/core/release/libmysqlservices-5.5.13-3.mga2.i586.rpm
    http://distrib-coffee.ipsl.jussieu.fr/pub/linux/Mageia/distrib/cauldron/i586/media/core/release/libmysql-devel-5.5.13-3.mga2.i586.rpm
installing libmysqlservices-5.5.13-3.mga2.i586.rpm libmysql-devel-5.5.13-3.mga2.i586.rpm from /var/cache/urpmi/rpms
Preparing...                     #################################################################################
      1/2: libmysqlservices      #################################################################################
      2/2: libmysql-devel        #################################################################################
removing package libmysql16-5.1.55-0.1mdv2010.2.i586

Status: NEW => RESOLVED
Resolution: (none) => FIXED