[Bacula-users] Update of bacula 3.0.3 -> 5.0.1 sqlite3 failure

I'm working on updating my v3.0.3 to 5.0.1 code base here. I'm running under ubuntu 8.04 LTS server (64bit) and running sqlite3. bacula is manually compiled.

The new version of code compiles fine w/ shared libraries (ran into a problem w/ static & the tools but will look at that later). Anyway after compiled and installed
I tried to update the old sqlite database running the script as mentioned in the documents:

root@loki:/opt/bacula/etc# ./update_bacula_tables
Altering SQLite tables

This script will update a Bacula SQLite 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
Depending on the size of your database,
this script may take several minutes to run.

SQL error near line 44: no such index: inx4
SQL error near line 46: index file_jpf_idx already exists

-------------

I tried with the specific script as well:

root@loki:/opt/bacula/etc# ./update_sqlite3_tables

This script will update a Bacula SQLite 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
Depending on the size of your database,
this script may take several minutes to run.

SQL error near line 2: duplicate column name: HasCache
SQL error near line 3: duplicate column name: Reviewed
SQL error near line 4: duplicate column name: Comment
SQL error near line 5: duplicate column name: HasCache
SQL error near line 6: duplicate column name: Reviewed
SQL error near line 7: duplicate column name: Comment
SQL error near line 9: duplicate column name: Severity
SQL error near line 17: table PathHierarchy already exists
SQL error near line 24: index pathhierarchy_ppathid already exists
SQL error near line 27: table PathVisibility already exists
SQL error near line 36: index pathvisibility_jobid already exists
SQL error near line 39: index basefiles_jobid_idx already exists
SQL error near line 44: no such index: inx4
SQL error near line 46: index file_jpf_idx already exists
------------

This is a standard install of the DB w/ bacula 3.0.3 (i.e. no indexes or other changes to the database).

Any ideas?

Steve

I

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users