bacula-director-mysql *->5.2.5-0ubuntu6.1 fails to upgrade if installed alongside mysql-server and upgraded in the same transaction

[kbm]

Occurred during general update

ProblemType: Package
DistroRelease: Ubuntu 12.04
Package: bacula-director-mysql 5.2.5-0ubuntu6.1
ProcVersionSignature: Ubuntu 3.2.0-26.41-generic 3.2.19
Uname: Linux 3.2.0-26-generic x86_64
ApportVersion: 2.0.1-0ubuntu8
Architecture: amd64
Date: Wed Jul 4 21:36:14 2012
DuplicateSignature:
 Setting up forked-daapd (0.19gcd-2ubuntu1) ...
 Starting RSP and DAAP media server: invoke-rc.d: initscript forked-daapd, action "start" failed.
 dpkg: error processing forked-daapd (--configure):
  subprocess installed post-installation script returned error exit status 1
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100429)
SourcePackage: bacula
Title: package bacula-director-mysql 5.2.5-0ubuntu6.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to precise on 2012-04-26 (68 days ago)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[James Page (james-page)]

Setting up bacula-director-mysql (5.2.5-0ubuntu6.1) ...
dbconfig-common: writing config to /etc/dbconfig-common/bacula-director-mysql.conf
Use of uninitialized value $_[1] in join or string at /usr/share/perl5/Debconf/DbDriver/Stack.pm line 111, <GEN0> line 20.
creating database backup in /var/cache/dbconfig-common/backups/bacula-director-mysql_5.2.5-0ubuntu6.mysql.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
unable to connect to mysql server.
error encountered backing up the old database:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
dbconfig-common: bacula-director-mysql configure: retrying.
dbconfig-common: writing config to /etc/dbconfig-common/bacula-director-mysql.conf
Use of uninitialized value $_[1] in join or string at /usr/share/perl5/Debconf/DbDriver/Stack.pm line 111, <GEN0> line 59.
creating database backup in /var/cache/dbconfig-common/backups/bacula-director-mysql_5.2.5-0ubuntu6.mysql.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
unable to connect to mysql server.
error encountered backing up the old database:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
dbconfig-common: bacula-director-mysql configure: aborted.
dbconfig-common: flushing administrative password
dpkg: error processing bacula-director-mysql (--configure):
 subprocess installed post-installation script returned error exit status 1

[James Page (james-page)]

This looks like an upgrade ordering issue; bacula needs to upgrade its database but mysql-server is stopped at the start of the upgrade and is not yet started when the DB upgrade for bacula is attempted.

I'm not familiar with how ordering is figured out but mysql-server is just a recommends - so I don't think its guaranteed to be configured prior to bacula-director-mysql.

For reference I think this is the same problem that means that if you are installing bacula and mysql-server on the same server you must install mysql-server first....

[James Page (james-page)]

This of course only impacts upgrade where mysql-server and bacula are upgraded in the same transaction.