[debian-mysql] Bug#686803: upgrade from 5.5.24+dfsg-4 to 5.5.24+dfsg-7 failed: "dependency problems - leaving unconfigured"

Thu Sep 6 00:56:33 UTC 2012

Package: mysql-server-5.5
Version: 5.5.24+dfsg-4
Severity: important

A routine upgrade tracking wheezy has gone wrong. I'm not quite sure
exactly what's up, but this is what I see:

$ sudo apt-get upgrade
[sudo] password for wookey: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these.
The following packages have unmet dependencies:
 mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.24+dfsg-4) but 5.5.24+dfsg-7 is installed
E: Unmet dependencies. Try using -f.

The original upgrade was the last month-or-so of wheezy updates,
inlcuding:
[UPGRADE] libmysqlclient-dev:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UPGRADE] libmysqlclient18:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UPGRADE] mysql-client:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UPGRADE] mysql-client-5.5:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UPGRADE] mysql-common:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UPGRADE] mysql-server:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UPGRADE] mysql-server-5.5:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UPGRADE] mysql-server-core-5.5:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7

That failed with mysql-server-5.5 not installing, as above.

So now we are left with:
Aptitude 0.6.8: log report
Thu, Sep  6 2012 01:20:36 +0100

IMPORTANT: this log only lists intended actions; actions which fail due to
dpkg problems may not be completed.

Will install 1 packages, and remove 0 packages.
82.9 kB of disk space will be used
===============================================================================
[UPGRADE] mysql-server-5.5:amd64 5.5.24+dfsg-4 -> 5.5.24+dfsg-7
[UNCONFIGURED] mysql-server:amd64

following the apt-get install -f suggestion we get:

sudo apt-get install -f
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
  mysql-server-5.5
Suggested packages:
  tinyca
The following packages will be upgraded:
  mysql-server-5.5
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
Need to get 0 B/2,150 kB of archives.
After this operation, 82.9 kB of additional disk space will be used.
Do you want to continue [Y/n]? 
dpkg: dependency problems prevent configuration of mysql-server-5.5:
 mysql-server-5.5 depends on mysql-server-core-5.5 (= 5.5.24+dfsg-4); however:
  Version of mysql-server-core-5.5 on system is 5.5.24+dfsg-7.

dpkg: error processing mysql-server-5.5 (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

clearly mysql-server-5.5 wants upgrading from 5.5.24+dfsg-4 to
5.5.24+dfsg-7 to match mysql-server-core-5.5, but the fact that -core
has already been updated seems to have broken things.

If you have any suggestions for what to poke it would be appreciated
as I can't install anything right now.

Or if you need more info to diagnose this.

Here is some apt-cache policy output in case that helps. Looks
reasonable to me. 

$ apt-cache policy mysql-server
mysql-server:
  Installed: 5.5.24+dfsg-7
  Candidate: 5.5.24+dfsg-7
  Version table:
     5.5.24+dfsg-8 0
        500 http://ftp.uk.debian.org/debian/ unstable/main amd64 Packages
 *** 5.5.24+dfsg-7 0
        990 http://ftp.uk.debian.org/debian/ testing/main amd64 Packages
        100 /var/lib/dpkg/status

$ apt-cache policy mysql-server-5.5
mysql-server-5.5:
  Installed: 5.5.24+dfsg-4
  Candidate: 5.5.24+dfsg-7
  Version table:
     5.5.24+dfsg-8 0
        500 http://ftp.uk.debian.org/debian/ unstable/main amd64 Packages
     5.5.24+dfsg-7 0
        990 http://ftp.uk.debian.org/debian/ testing/main amd64 Packages
 *** 5.5.24+dfsg-4 0
        100 /var/lib/dpkg/status

$ apt-cache policy mysql-server-core-5.5
mysql-server-core-5.5:
  Installed: 5.5.24+dfsg-7
  Candidate: 5.5.24+dfsg-7
  Version table:
     5.5.24+dfsg-8 0
        500 http://ftp.uk.debian.org/debian/ unstable/main amd64 Packages
 *** 5.5.24+dfsg-7 0
        990 http://ftp.uk.debian.org/debian/ testing/main amd64 Packages
        100 /var/lib/dpkg/status

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.2.0-3-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.46
ii  initscripts            2.88dsf-31
ii  libc6                  2.13-35
ii  libdbi-perl            1.622-1
ii  libgcc1                1:4.7.1-7
ii  libstdc++6             4.7.1-7
ii  lsb-base               4.1+Debian7
ii  mysql-client-5.5       5.5.24+dfsg-7
ii  mysql-common           5.5.24+dfsg-7
ii  mysql-server-core-5.5  5.5.24+dfsg-7
ii  passwd                 1:4.1.5.1-1
ii  perl                   5.14.2-12
ii  psmisc                 22.19-1

Versions of packages mysql-server-5.5 recommends:
ii  heirloom-mailx [mailx]  12.5-2
ii  libhtml-template-perl   2.91-1

Versions of packages mysql-server-5.5 suggests:
pn  tinyca  <none>

-- debconf information:
  mysql-server/error_setting_password:
  mysql-server-5.5/postrm_remove_databases: false
  mysql-server-5.5/nis_warning:
  mysql-server-5.5/really_downgrade: false
  mysql-server-5.5/start_on_boot: true
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb: