[Bug 579924] Re: Upgrading Ubuntu LTS skips database version - Fatal error: Version error for database "bacula". Wanted 12, got 10

[Tomasz]

** Description changed:

  Binary package hint: bacula
  
  After upgrading Ubuntu from 8.04 LTS to 10.04 LTS backup software Bacula
  stopped working, starting bacula-director MySQL version results in:
  
  bacula-dir JobId 0: Fatal error: Version error for database "bacula".
  Wanted 12, got 10
  
- 
- During upgrade Bacula was upgraded from 2.2 series (db version 10) to 5.0 (db version 12), dpkg.log shows.
+ During upgrade Bacula was upgraded from 2.2 series (db version 10) to
+ 5.0 (db version 12), dpkg.log shows.
  
  2010-05-12 21:16:32 upgrade bacula-director-mysql 2.2.8-5ubuntu7.2
  5.0.1-1ubuntu1
  
- 
- and /usr/share/bacula-director/update_mysql_tables upgrades only from db version 11:
+ and /usr/share/bacula-director/update_mysql_tables upgrades only from db
+ version 11:
  
  This script will update a Bacula MySQL database from version 11 to 12
-  which is needed to convert from Bacula Enterprise 2.6 to 4.0 or 
-  Standard version 3.0 to 5.0
+  which is needed to convert from Bacula Enterprise 2.6 to 4.0 or
+  Standard version 3.0 to 5.0
+ 
+ Running it for version 10 destroys database structure! Running a job
+ results in a failure, messages:
+ 
+ 13-maj 14:16 magazyn-dir JobId 0: Fatal error: sql_get.c:623 sql_get.c:623 query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge FROM Pool WHERE Pool.Name='Default' failed:
+ Unknown column 'ActionOnPurge' in 'field list'
+ 13-maj 14:16 magazyn-dir JobId 0: Fatal error: sql_get.c:623 sql_get.c:623 query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge FROM Pool WHERE Pool.Name='Default' failed:
+ Unknown column 'ActionOnPurge' in 'field list'
+ 13-maj 14:16 magazyn-dir JobId 0: Fatal error: Pool Default not in database. sql_create.c:181 pool record Default already exists
+ 13-maj 14:16 magazyn-dir JobId 0: Fatal error: sql_get.c:623 sql_get.c:623 query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge FROM Pool WHERE Pool.Name='Default' failed:
+ Unknown column 'ActionOnPurge' in 'field list'
+ 13-maj 14:16 magazyn-dir JobId 0: Fatal error: sql_get.c:623 sql_get.c:623 query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge FROM Pool WHERE Pool.Name='Default' failed:
+ Unknown column 'ActionOnPurge' in 'field list'
+ 13-maj 14:16 magazyn-dir JobId 0: Fatal error: Pool Default not in database. sql_create.c:181 pool record Default already exists
+ 13-maj 14:16 magazyn-dir JobId 0: Fatal error: sql_get.c:623 sql_get.c:623 query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge FROM Pool WHERE Pool.Name='Default' failed:
+ Unknown column 'ActionOnPurge' in 'field list'
  
  
  I expected to have the database upgraded from version 10 to 12 when upgrading Ubuntu LTS series.

-- 
Upgrading Ubuntu LTS skips database version - Fatal error: Version error for database "bacula". Wanted 12, got 10
https://bugs.launchpad.net/bugs/579924
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to bacula in ubuntu.