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

[James Page]

** Description changed:

- 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:
+ [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
+ 
+ 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
+  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