[Bug 980189] Re: [SRU] Database not upgraded while upgrading bacula

Thu Jun 14 16:03:43 UTC 2012

** Description changed:

  [Impact]
  Users of bacula upgrading from either 10.04 or 11.10 to 12.04 end up with a non-functional bacula-director as the database is not upgraded as part of the package installation process.  This causes bacula-director to fail on startup.

  [Test Case]
- (oneiric base server install) 
+ (oneiric base server install)
  sudo apt-get install mysql-server
  sudo apt-get install bacula-server
  (check /var/log/bacula/log for error messages - may)
  sudo do-release-upgrade
  ...
- sudo cat /var/log/bacula
+ sudo cat /var/log/bacula/log

  14-Jun 16:45 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  14-Jun 16:45 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".
  14-Jun 16:45 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  14-Jun 16:45 bacula-dir ERROR TERMINATION
  Please correct configuration file: /etc/bacula/bacula-dir.conf

  [Regression Potential]
  The changes to the package as in the dbconfig-common upgrade handling for postgresql, sqllite and mysql database types.  A new upgrade is defined for 5.2.5-0ubuntu6.1 to upgrade the schema from version 12->14.  This same fix is applied in quantal which ensures it only get applied once as an upgrade passes 5.2.5-0ubuntu6.1

  [Original Bug Report]
  Upgrading a bacula server from Ubuntu oneiric to precise upgrades bacula from 5.0.3 to 5.5.1, but misses the necessary database upgrade:

  12-Apr 21:19 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  12-Apr 21:19 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".
  12-Apr 21:19 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  12-Apr 21:19 bacula-dir ERROR TERMINATION
  Please correct configuration file: /etc/bacula/bacula-dir.conf

  In tune bacula-director doesn't start any more. Instructions how to
  upgrade the database manualy are missing.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.04
  Package: bacula-director-pgsql 5.2.5-0ubuntu6
  ProcVersionSignature: Ubuntu 3.2.0-23.36-virtual 3.2.14
  Uname: Linux 3.2.0-23-virtual x86_64
  ApportVersion: 2.0.1-0ubuntu2
  Architecture: amd64
  Date: Thu Apr 12 21:22:21 2012
  InstallationMedia: Ubuntu-Server 10.04.1 LTS "Lucid Lynx" - Release amd64 (20100816.2)
  ProcEnviron:
   TERM=screen-bce
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: bacula
  UpgradeStatus: Upgraded to precise on 2012-04-12 (0 days ago)

** Description changed:

  [Impact]
  Users of bacula upgrading from either 10.04 or 11.10 to 12.04 end up with a non-functional bacula-director as the database is not upgraded as part of the package installation process.  This causes bacula-director to fail on startup.

  [Test Case]
  (oneiric base server install)
  sudo apt-get install mysql-server
  sudo apt-get install bacula-server
- (check /var/log/bacula/log for error messages - may)
  sudo do-release-upgrade
  ...
  sudo cat /var/log/bacula/log

  14-Jun 16:45 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  14-Jun 16:45 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".
  14-Jun 16:45 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  14-Jun 16:45 bacula-dir ERROR TERMINATION
  Please correct configuration file: /etc/bacula/bacula-dir.conf

  [Regression Potential]
  The changes to the package as in the dbconfig-common upgrade handling for postgresql, sqllite and mysql database types.  A new upgrade is defined for 5.2.5-0ubuntu6.1 to upgrade the schema from version 12->14.  This same fix is applied in quantal which ensures it only get applied once as an upgrade passes 5.2.5-0ubuntu6.1

  [Original Bug Report]
  Upgrading a bacula server from Ubuntu oneiric to precise upgrades bacula from 5.0.3 to 5.5.1, but misses the necessary database upgrade:

  12-Apr 21:19 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  12-Apr 21:19 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".
  12-Apr 21:19 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 14, got 12
  12-Apr 21:19 bacula-dir ERROR TERMINATION
  Please correct configuration file: /etc/bacula/bacula-dir.conf

  In tune bacula-director doesn't start any more. Instructions how to
  upgrade the database manualy are missing.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.04
  Package: bacula-director-pgsql 5.2.5-0ubuntu6
  ProcVersionSignature: Ubuntu 3.2.0-23.36-virtual 3.2.14
  Uname: Linux 3.2.0-23-virtual x86_64
  ApportVersion: 2.0.1-0ubuntu2
  Architecture: amd64
  Date: Thu Apr 12 21:22:21 2012
  InstallationMedia: Ubuntu-Server 10.04.1 LTS "Lucid Lynx" - Release amd64 (20100816.2)
  ProcEnviron:
   TERM=screen-bce
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: bacula
  UpgradeStatus: Upgraded to precise on 2012-04-12 (0 days ago)

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to bacula in Ubuntu.
https://bugs.launchpad.net/bugs/980189

Title:
  [SRU] Database not upgraded while upgrading bacula

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/980189/+subscriptions