[pkg-bacula-devel] Bug#629575: psql: FATAL: could not write init file on lenny->squeeze upgrade
ross at biostat.ucsf.edu
ross at biostat.ucsf.edu
Tue Jun 7 19:59:27 UTC 2011
Package: bacula-director-pgsql
Version: 5.0.2-2.2+b1
Severity: normal
May warrant higher severity.
May be same as 605449.
I attempted to send this earlier, but I don't think the report went out.
Upgrading from lenny to squeeze produces this message while configuring bacula-director-pgsql:
<quote>
│ An error occurred while upgrading the database:
│
│ psql: FATAL: could not write init file
│
│ Fortunately, /var/cache/dbconfig-common/backups/bacula-director-pgsql_2.4.4-1withssl.pgsql holds a backup of the database, made just before the upgrade.
│
│ If at this point you choose "retry", you will be prompted with all the configuration questions once more and another attempt will be made at performing the operation. "retry (skip questions)" will immediately attempt the │
│ operation again, skipping all questions. If you choose "abort", the operation will fail and you will need to downgrade, reinstall, reconfigure this package, or otherwise manually intervene to continue using it. │
│ Next step for database upgrade:
</quote>
The backup file also does not exist (perhaps 602431?).
I also had trouble with the initial database setup for bacula under
Lenny; it is possible those problems may have left dbconfig in an
unusual state. The resulting database has seemed usable in simple
tests; that is bacula under Lenny could make and restore backups.
I think I've had similar problems with initial setup on other Lenny
systems, but since it's old I did not pursue or report them.
The version in Lenny was locally built to enable SSL; otherwise it is
standard 2.4.4-1.
I am submitting this system from a production system, NOT the vm on
which I ran the test. The information should be similar to the
VM in its pre-upgrade (Lenny) state. Here is some information from
the VM while the error message reported above displays on the screen:
<quote>
vm-migrate07:~# date; df .
Tue Jun 7 11:06:54 PDT 2011
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 4878132 4020624 609708 87% /
vm-migrate07:~# dpkg -l 'postgres*'
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Description
+++-====================================================-====================================================-========================================================================================================================
iU postgresql 8.4.7-0squeeze2 object-relational SQL database (supported version)
un postgresql-7.4 <none> (no description available)
un postgresql-8.0 <none> (no description available)
un postgresql-8.1 <none> (no description available)
un postgresql-8.2 <none> (no description available)
ii postgresql-8.3 8.3.14-0lenny1 object-relational SQL database, version 8.3 server
iU postgresql-8.4 8.4.7-0squeeze2 object-relational SQL database, version 8.4 server
ii postgresql-client 8.4.7-0squeeze2 front-end programs for PostgreSQL (supported version)
ii postgresql-client-8.3 8.3.14-0lenny1 front-end programs for PostgreSQL 8.3
ii postgresql-client-8.4 8.4.7-0squeeze2 front-end programs for PostgreSQL 8.4
ii postgresql-client-common 113 manager for multiple PostgreSQL client versions
iU postgresql-common 113 PostgreSQL database-cluster manager
un postgresql-contrib <none> (no description available)
un postgresql-dev <none> (no description available)
un postgresql-doc <none> (no description available)
un postgresql-doc-8.3 <none> (no description available)
un postgresql-doc-8.4 <none> (no description available)
ii postgresql-server-dev-8.3 8.3.14-0lenny1 development files for PostgreSQL 8.3 server-side programming
vm-migrate07:~# dpkg -l 'bacula*'
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Description
+++-====================================================-====================================================-========================================================================================================================
iU bacula 5.0.2-2.2 network backup, recovery and verification - meta-package
iU bacula-client 5.0.2-2.2 network backup, recovery and verification - client meta-package
ii bacula-common 5.0.2-2.2+b1 network backup, recovery and verification - common support files
un bacula-common-mysql <none> (no description available)
ii bacula-common-pgsql 5.0.2-2.2+b1 network backup, recovery and verification - PostgreSQL common files
un bacula-common-sqlite3 <none> (no description available)
ii bacula-console 5.0.2-2.2+b1 network backup, recovery and verification - text console
rc bacula-console-wx 2.4.4-1withssl network backup, recovery and verification - WxWindows console
un bacula-director <none> (no description available)
ii bacula-director-common 5.0.2-2.2+b1 network backup, recovery and verification - Director common files
iF bacula-director-pgsql 5.0.2-2.2+b1 network backup, recovery and verification - PostgreSQL storage for Director
un bacula-director-sqlite3 <none> (no description available)
un bacula-doc <none> (no description available)
ii bacula-fd 5.0.2-2.2+b1 network backup, recovery and verification - file daemon
iU bacula-sd 5.0.2-2.2+b1 network backup, recovery and verification - storage daemon
iU bacula-sd-pgsql 5.0.2-2.2+b1 network backup, recovery and verification - PostgreSQL SD tools
un bacula-sd-sqlite3 <none> (no description available)
un bacula-sd-tools <none> (no description available)
iU bacula-server 5.0.2-2.2 network backup, recovery and verification - server meta-package
ii bacula-traymonitor 5.0.2-2.2+b1 network backup, recovery and verification - tray monitor
un bacula-wxconsole <none> (no description available)
</quote>
Note that I have a working 8.3 postgres database, although consistent
with 605449 the 8.4 database is not configured.
BTW, a partial solution to 605449 is a release note advising the
installation of 8.4 (locally or remotely as appropriate) before
installing/upgrading bacula. The trick is getting that information
somewhere people will see it in time. Also, perhaps because of
dependencies it is not possible to upgrade postgres without upgrading
bacula at the same time.
-- System Information:
Debian Release: 5.0.8
APT prefers oldstable
APT policy: (500, 'oldstable'), (50, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-2-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages bacula-director-pgsql depends on:
ii bacula-director-common 2.4.4-1withssl network backup, recovery and verif
ii dbconfig-common 1.8.39 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.24 Debian configuration management sy
ii libc6 2.7-18lenny7 GNU C Library: Shared libraries
ii libgcc1 1:4.3.2-1.1 GCC support library
ii libpq5 8.3.14-0lenny1 PostgreSQL C client library
ii libssl0.9.8 0.9.8g-15+lenny11 SSL shared libraries
ii libstdc++6 4.3.2-1.1 The GNU Standard C++ Library v3
ii libwrap0 7.6.q-16 Wietse Venema's TCP wrappers libra
ii postgresql-client 8.3.14-0lenny1 front-end programs for PostgreSQL
ii postgresql-client-8.2 8.2.7-2+b1 front-end programs for PostgreSQL
ii postgresql-client-8.3 8.3.14-0lenny1 front-end programs for PostgreSQL
ii python2.5 2.5.2-15+lenny1 An interactive high-level object-o
Versions of packages bacula-director-pgsql recommends:
ii postgresql 8.3.14-0lenny1 object-relational SQL database (su
ii postgresql-8.2 8.2.7-2+b1 object-relational SQL database, ve
ii postgresql-8.3 8.3.14-0lenny1 object-relational SQL database, ve
Versions of packages bacula-director-pgsql suggests:
pn postgresql-contrib <none> (no description available)
ii postgresql-doc 8.3.14-0lenny1 documentation for the PostgreSQL d
-- debconf information excluded
More information about the pkg-bacula-devel
mailing list