[pkg-bacula-devel] Bug#708238: bacula-director-pgsql: Fatal error: Version error for database "bacula". Wanted 14, got 12

[Teodor]

Package: bacula-director-pgsql
Version: 5.2.6+dfsg-9
Severity: grave

Hi,

I've upgraded from Debian 6.0 to Debian 7.0 and Bacula director does not
start after upgrade. It appears that the database was not upgraded:

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

So far I've found that /usr/share/bacula-director/update_postgresql_tables
is the script to handle the upgrade but it's not executed automatically.

Cheers


-- System Information:
Debian Release: 7.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-4-686-pae (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash

Versions of packages bacula-director-pgsql depends on:
ii  bacula-common                              5.2.6+dfsg-9
ii  bacula-common-pgsql                        5.2.6+dfsg-9
ii  bacula-director-common                     5.2.6+dfsg-9
ii  dbconfig-common                            1.8.47+nmu1
ii  debconf [debconf-2.0]                      1.5.49
ii  libc6                                      2.13-38
ii  libcap2                                    1:2.22-1.2
ii  libgcc1                                    1:4.7.2-5
ii  libpython2.7                               2.7.3-6
ii  libssl1.0.0                                1.0.1e-2
ii  libstdc++6                                 4.7.2-5
ii  libwrap0                                   7.6.q-24
ii  postgresql-client                          9.1+134wheezy3
ii  postgresql-client-8.4 [postgresql-client]  8.4.17-0squeeze1
ii  postgresql-client-9.1 [postgresql-client]  9.1.9-1
ii  ucf                                        3.0025+nmu3
ii  zlib1g                                     1:1.2.7.dfsg-13

Versions of packages bacula-director-pgsql recommends:
ii  postgresql  9.1+134wheezy3

Versions of packages bacula-director-pgsql suggests:
pn  gawk                <none>
pn  postgresql-contrib  <none>
pn  postgresql-doc      <none>

-- Configuration Files:
/etc/bacula/scripts/delete_catalog_backup [Errno 13] Permission denied: u'/etc/bacula/scripts/delete_catalog_backup'

-- debconf information:
  bacula-director-pgsql/pgsql/method: unix socket
  bacula-director-pgsql/pgsql/authmethod-admin: ident
  bacula-director-pgsql/passwords-do-not-match:
  bacula-director-pgsql/pgsql/no-empty-passwords:
  bacula-director-pgsql/upgrade-backup: true
  bacula-director-pgsql/install-error: abort
  bacula-director-pgsql/internal/reconfiguring: false
  bacula-director-pgsql/db/app-user: bacula
  bacula-director-pgsql/dbconfig-reinstall: false
  bacula-director-pgsql/dbconfig-remove:
  bacula-director-pgsql/db/dbname: bacula
  bacula-director-pgsql/remote/host:
  bacula-director-pgsql/pgsql/admin-user: postgres
  bacula-director-pgsql/pgsql/authmethod-user:
  bacula-director-pgsql/upgrade-error: abort
  bacula-director-pgsql/internal/skip-preseed: true
  bacula-director-pgsql/purge: false
  bacula-director-pgsql/database-type: pgsql
  bacula-director-pgsql/remote/port:
  bacula-director-pgsql/pgsql/changeconf: false
  bacula-director-pgsql/remote/newhost:
  bacula-director-pgsql/unsafe-director-password-was-changed:
  bacula-director-pgsql/pgsql/manualconf:
* bacula-director-pgsql/dbconfig-install: false
  bacula-director-pgsql/dbconfig-upgrade: true
  bacula-director-pgsql/missing-db-package-error: abort
  bacula-director-pgsql/remove-error: abort