Your message dated Tue, 04 Jun 2013 11:51:10 +0200
with message-id <1370339470.11129.12.camel@elacunza>
and subject line Re: [pkg-bacula-devel] Bug#708238: Fatal error: Version error
for database "bacula". Wanted 14, got 12
has caused the Debian Bug report #708238,
regarding bacula-director-pgsql: Fatal error: Version error for database
"bacula". Wanted 14, got 12
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
708238: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=708238
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Hi Alexander,
Thanks for your reply. I think my bacula installation comes from lenny,
but I don't think I created the database by hand (but can't be sure
about it, was a long time ago ;) ). I don't recall upgrade problems from
lenny to squeeze either.
In any case, as bacula-director-mysql won't work with version 12, it
should at least display a warning during update, so that admin knows it
has to upgrade it by hand?
Thanks
Eneko
El mar, 04-06-2013 a las 13:20 +0400, Alexander Golovko escribió:
> severity 708238 minor
> retitle 708238 wheezy bacula Fatal error: Version error for database
> "bacula". Wanted 14, got 12
> --
>
> Hi, Teodor and Eneko!
>
> I'm sorry for long delay with reply.
>
> Thank you for your reports, but this is not a bug with package
> upgrading. Debconf information in your reports contain next info:
>
> "* bacula-director-(mysql|pgsql)/dbconfig-install: false"
>
> This line mean, that you disable automatic database creating on
> package installation. Database installation and upgrading
> handled by dbconfig-common stuff, which remember your choice about db
> creating and does not try to upgrade db in this case.
>
>
> For avoid this problem in future you should set dbconfig-common for
> handle bacula database by one of methods.
> 1. dpkg-reconfigure bacula-director-(mysql|pgsql), choose reinstall
> database and then ignore errors about already existed tables. But at
> first upgrade database, of-course.
> 2. manually change /etc/dbconfig-common/bacula-director-(mysql|pgsql)
>
>
> For upgrade database you can apply to db next file:
> /usr/share/dbconfig-common/data/bacula-director-<dbtype>/upgrade/<dbtype>/5.2.0
>
> or you can run something like this command:
> /usr/share/bacula-director/update_mysql_tables -h dbhost -u dbuser \
> -D dbname -p
>
>
> В Wed, 29 May 2013 15:09:00 +0200
> Eneko Lacunza <elacu...@binovo.es> пишет:
>
> >
> > Subject: bacula-director-mysql: I've hit this same bug too
> > Followup-For: Bug #708238
> > Package: bacula-director-mysql
> > Version: 5.2.6+dfsg-9
> >
> > Dear Maintainer,
> > *** Please consider answering these questions, where appropriate ***
> >
> > * What led up to the situation?
> > * What exactly did you do (or not do) that was effective (or
> > ineffective)?
> > * What was the outcome of this action?
> > * What outcome did you expect instead?
> >
> > *** End of the template - remove these lines ***
> >
> >
> > -- System Information:
> > Debian Release: 7.0
> > APT prefers stable
> > APT policy: (500, 'stable')
> > Architecture: amd64 (x86_64)
> >
> > Kernel: Linux 3.2.0-4-amd64 (SMP w/1 CPU core)
> > Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
> > Shell: /bin/sh linked to /bin/dash
> >
> > Versions of packages bacula-director-mysql depends on:
> > ii bacula-common 5.2.6+dfsg-9
> > ii bacula-common-mysql 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 mysql-client 5.5.31+dfsg-0+wheezy1
> > ii mysql-client-5.5 [mysql-client] 5.5.31+dfsg-0+wheezy1
> > ii ucf 3.0025+nmu3
> > ii zlib1g 1:1.2.7.dfsg-13
> >
> > Versions of packages bacula-director-mysql recommends:
> > ii mysql-server 5.5.31+dfsg-0+wheezy1
> >
> > Versions of packages bacula-director-mysql suggests:
> > ii gawk 1:4.0.1+dfsg-2.1
> >
> > -- Configuration Files:
> > /etc/bacula/scripts/delete_catalog_backup changed [not included]
> >
> > -- debconf information:
> > bacula-director-mysql/mysql/app-pass: (password omitted)
> > bacula-director-mysql/mysql/admin-pass: (password omitted)
> > bacula-director-mysql/app-password-confirm: (password omitted)
> > bacula-director-mysql/password-confirm: (password omitted)
> > bacula-director-mysql/unsafe-director-password-was-changed:
> > bacula-director-mysql/passwords-do-not-match:
> > bacula-director-mysql/mysql/admin-user: root
> > bacula-director-mysql/dbconfig-upgrade: true
> > bacula-director-mysql/purge: false
> > bacula-director-mysql/remove-error: abort
> > bacula-director-mysql/missing-db-package-error: abort
> > bacula-director-mysql/remote/newhost:
> > bacula-director-mysql/internal/skip-preseed: true
> > * bacula-director-mysql/dbconfig-install: false
> > bacula-director-mysql/db/app-user: bacula
> > bacula-director-mysql/upgrade-backup: true
> > bacula-director-mysql/database-type: mysql
> > bacula-director-mysql/install-error: abort
> > bacula-director-mysql/db/dbname: bacula
> > bacula-director-mysql/mysql/method: unix socket
> > bacula-director-mysql/remote/host:
> > bacula-director-mysql/internal/reconfiguring: false
> > bacula-director-mysql/upgrade-error: abort
> > bacula-director-mysql/dbconfig-reinstall: false
> > bacula-director-mysql/remote/port:
> > bacula-director-mysql/dbconfig-remove:
> >
> > _______________________________________________
> > pkg-bacula-devel mailing list
> > pkg-bacula-de...@lists.alioth.debian.org
> > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-bacula-devel
> >
>
>
--
Zuzendari Teknikoa / Director Técnico
Binovo IT Human Project, S.L.
Telf. 943575997
943493611
Astigarraga bidea 2, planta 6 dcha., ofi. 3-2; 20180 Oiartzun (Gipuzkoa)
www.binovo.es
--- End Message ---
