package bacula-director-mysql 5.2.5-0ubuntu6.1 failed to install/upgrade: ErrorMessage: subprocess installed post-installation script returned error exit status 1

[Johan Smits]

Doing a dist upgrade from Lucid 10.04 fully patched to 12.04

ProblemType: Package
DistroRelease: Ubuntu 12.04
Package: bacula-director-mysql 5.2.5-0ubuntu6.1
ProcVersionSignature: Ubuntu 2.6.32-42.95-generic-pae 2.6.32.59+drm33.24
Uname: Linux 2.6.32-42-generic-pae i686
ApportVersion: 2.0.1-0ubuntu12
Architecture: i386
Date: Sun Aug 26 13:39:55 2012
ErrorMessage: ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationMedia: Ubuntu-Server 10.04.3 LTS "Lucid Lynx" - Release i386 (20110719.2)
SourcePackage: bacula
Title: package bacula-director-mysql 5.2.5-0ubuntu6.1 failed to install/upgrade: ErrorMessage: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to precise on 2012-08-26 (0 days ago)

[James Page (james-page)]

creating database backup in /var/cache/dbconfig-common/backups/bacula-director-mysql_5.0.1-1ubuntu1.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).
unable to connect to mysql server.
error encountered backing up the old database:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
dbconfig-common: bacula-director-mysql configure: retrying.
dbconfig-common: writing config to /etc/dbconfig-common/bacula-director-mysql.conf
creating database backup in /var/cache/dbconfig-common/backups/bacula-director-mysql_5.0.1-1ubuntu1.mysql.
applying upgrade sql for 5.0.1-1ubuntu1 -> 5.2.5-0ubuntu6.1.
dbconfig-common: flushing administrative password
applying upgrade sql for 5.0.1-1ubuntu1 -> 5.2.5-0ubuntu6.1.
error encountered processing /usr/share/dbconfig-common/data/bacula-director-mysql/upgrade/mysql/5.2.5-0ubuntu6.1:
mysql said: ERROR 1050 (42S01) at line 3: Table 'RestoreObject' already exists
dbconfig-common: bacula-director-mysql configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/bacula-director-mysql.conf
Replacing config file /etc/dbconfig-common/bacula-director-mysql.conf with new version
creating database backup in /var/cache/dbconfig-common/backups/bacula-director-mysql_5.0.1-1ubuntu1.mysql.
applying upgrade sql for 5.0.1-1ubuntu1 -> 5.2.5-0ubuntu6.1.
error encountered processing /usr/share/dbconfig-common/data/bacula-director-mysql/upgrade/mysql/5.2.5-0ubuntu6.1:
mysql said: ERROR 1050 (42S01) at line 3: Table 'RestoreObject' already exists
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
dpkg: dependency problems prevent configuration of bacula-server:
 bacula-server depends on bacula-director-mysql (>= 5.2.5-0ubuntu6.1) | bacula-director; however:
  Package bacula-director-mysql is not configured yet.
  Package bacula-director is not installed.
  Package bacula-director-mysql which provides bacula-director is not configured yet.
dpkg: error processing bacula-server (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of bacula:
 bacula depends on bacula-server; however:
  Package bacula-server is not configured yet.
dpkg: error processing bacula (--configure):
 dependency problems - leaving unconfigured

[James Page (james-page)]

It looks like dbconfig-common tried to execute the upgrade twice after the initial failure to connect to mysql:

applying upgrade sql for 5.0.1-1ubuntu1 -> 5.2.5-0ubuntu6.1.
dbconfig-common: flushing administrative password
applying upgrade sql for 5.0.1-1ubuntu1 -> 5.2.5-0ubuntu6.1.

[Launchpad Janitor (janitor)]

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

[Nicola Quargentan (nicola-quargentan)]

I have the same problem.
Has anyone found a solution?

[Nicola Quargentan (nicola-quargentan)]

Ok, the answer is stupid. When asked whether to update or not the database, say no :P