[pkg-bacula-devel] Bug#1108272: bacula-director-pgsql: update_postgresql_tables script fails due to bad shell quoting

[Wouter Verhelst]

Hi Sven,

On Thu, Jun 26, 2025 at 07:03:38AM +0200, Sven Hartge wrote:
> On 24.06.25 18:18, Wouter Verhelst wrote:
> 
> > I installed the bacula director from backports, so that my laptop (which
> > runs unstable) can still be backed up to my server (which runs stable).
> > 
> > After the upgrade to bacula 15, I noticed that my director was no longer
> > running. Checking the logs, I found the following:
> > 
> > 24-jun 18:00 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 1026, got 1024
> > 24-jun 18:00 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".
> > 24-jun 18:00 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 1026, got 1024
> > 24-jun 18:00 bacula-dir ERROR TERMINATION
> 
> Interesting that the Upgrade Script via dbconfig did not run. Have you
> configured the bacula packages to not use dbconfig? Or has some sequence
> caused it to fail?

So debconf-show bacula-director-pgsql shows me this, amongst others:

* bacula-director-pgsql/dbconfig-upgrade: false

Which indicates that perhaps, somehow, it is indeed disabled. This is
not what I wanted.

I don't remember manually setting this option. When I run
"dpkg-reconfigure -plow bacula-director-pgsql" to correct it, it asks me
if I want to *reinstall* the database (which I read as "throw away
everything in your catalog away and start from scratch", which is a hard
"no"), but does not ask me the question about upgrading.

This feels wrong on so many levels. I'm not sure whether this is decided
in dbconfig-common or in bacula, but if the latter, please fix that :-)

> Could you check apts history or term logs to check of anything related to
> the upgrade?

Given the above, I doubt it matters anymore, but regardless, the output
of "grep bacula /var/lib/dpkg.log" on the machine follows. Note that it
mentions "13.0.4-1", as I initially upgraded to the unstable version
before there was a version in backports. I don't know whether this is
relevant or not.

2025-06-22 15:29:27 upgrade bacula-director:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:27 status half-configured bacula-director:amd64 13.0.4-1
2025-06-22 15:29:27 status unpacked bacula-director:amd64 13.0.4-1
2025-06-22 15:29:27 status half-installed bacula-director:amd64 13.0.4-1
2025-06-22 15:29:27 status unpacked bacula-director:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:28 upgrade bacula-director-pgsql:all 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:28 status half-configured bacula-director-pgsql:all 13.0.4-1
2025-06-22 15:29:28 status unpacked bacula-director-pgsql:all 13.0.4-1
2025-06-22 15:29:28 status half-installed bacula-director-pgsql:all 13.0.4-1
2025-06-22 15:29:29 status unpacked bacula-director-pgsql:all 15.0.3-1~bpo12+1
2025-06-22 15:29:29 upgrade bacula-bscan:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:29 status half-configured bacula-bscan:amd64 13.0.4-1
2025-06-22 15:29:29 status unpacked bacula-bscan:amd64 13.0.4-1
2025-06-22 15:29:29 status half-installed bacula-bscan:amd64 13.0.4-1
2025-06-22 15:29:29 status unpacked bacula-bscan:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:29 upgrade bacula-common-pgsql:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:29 status half-configured bacula-common-pgsql:amd64 13.0.4-1
2025-06-22 15:29:29 status unpacked bacula-common-pgsql:amd64 13.0.4-1
2025-06-22 15:29:29 status half-installed bacula-common-pgsql:amd64 13.0.4-1
2025-06-22 15:29:29 status unpacked bacula-common-pgsql:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:29 upgrade bacula-sd:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:29 status half-configured bacula-sd:amd64 13.0.4-1
2025-06-22 15:29:30 status unpacked bacula-sd:amd64 13.0.4-1
2025-06-22 15:29:30 status half-installed bacula-sd:amd64 13.0.4-1
2025-06-22 15:29:30 status unpacked bacula-sd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:30 upgrade bacula-tray-monitor:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:30 status half-configured bacula-tray-monitor:amd64 13.0.4-1
2025-06-22 15:29:30 status unpacked bacula-tray-monitor:amd64 13.0.4-1
2025-06-22 15:29:30 status half-installed bacula-tray-monitor:amd64 13.0.4-1
2025-06-22 15:29:30 status unpacked bacula-tray-monitor:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:31 upgrade bacula-fd:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:31 status half-configured bacula-fd:amd64 13.0.4-1
2025-06-22 15:29:31 status unpacked bacula-fd:amd64 13.0.4-1
2025-06-22 15:29:31 status half-installed bacula-fd:amd64 13.0.4-1
2025-06-22 15:29:31 status unpacked bacula-fd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:31 upgrade bacula-console-qt:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:31 status half-configured bacula-console-qt:amd64 13.0.4-1
2025-06-22 15:29:31 status unpacked bacula-console-qt:amd64 13.0.4-1
2025-06-22 15:29:31 status half-installed bacula-console-qt:amd64 13.0.4-1
2025-06-22 15:29:31 status unpacked bacula-console-qt:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:31 upgrade bacula-console:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:31 status half-configured bacula-console:amd64 13.0.4-1
2025-06-22 15:29:32 status unpacked bacula-console:amd64 13.0.4-1
2025-06-22 15:29:32 status half-installed bacula-console:amd64 13.0.4-1
2025-06-22 15:29:32 status unpacked bacula-console:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:32 upgrade bacula-common:amd64 13.0.4-1 15.0.3-1~bpo12+1
2025-06-22 15:29:32 status half-configured bacula-common:amd64 13.0.4-1
2025-06-22 15:29:32 status unpacked bacula-common:amd64 13.0.4-1
2025-06-22 15:29:32 status half-installed bacula-common:amd64 13.0.4-1
2025-06-22 15:29:33 status unpacked bacula-common:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:33 configure bacula-common:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:33 status unpacked bacula-common:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:33 status half-configured bacula-common:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:34 status installed bacula-common:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:34 configure bacula-sd:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:34 status unpacked bacula-sd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:34 status half-configured bacula-sd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:41 status installed bacula-sd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:41 configure bacula-console-qt:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:41 status unpacked bacula-console-qt:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:41 status half-configured bacula-console-qt:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:42 status installed bacula-console-qt:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:42 configure bacula-console:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:42 status unpacked bacula-console:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:42 status half-configured bacula-console:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:42 status installed bacula-console:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:42 configure bacula-fd:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:42 status unpacked bacula-fd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:42 status half-configured bacula-fd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 status installed bacula-fd:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 configure bacula-tray-monitor:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:44 status unpacked bacula-tray-monitor:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 status half-configured bacula-tray-monitor:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 status installed bacula-tray-monitor:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 configure bacula-common-pgsql:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:44 status unpacked bacula-common-pgsql:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 status half-configured bacula-common-pgsql:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 status installed bacula-common-pgsql:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 configure bacula-bscan:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:44 status unpacked bacula-bscan:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 status half-configured bacula-bscan:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 status installed bacula-bscan:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:44 configure bacula-director-pgsql:all 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:44 status unpacked bacula-director-pgsql:all 15.0.3-1~bpo12+1
2025-06-22 15:29:45 status half-configured bacula-director-pgsql:all 15.0.3-1~bpo12+1
2025-06-22 15:29:46 status installed bacula-director-pgsql:all 15.0.3-1~bpo12+1
2025-06-22 15:29:46 configure bacula-director:amd64 15.0.3-1~bpo12+1 <none>
2025-06-22 15:29:46 status unpacked bacula-director:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:46 status half-configured bacula-director:amd64 15.0.3-1~bpo12+1
2025-06-22 15:29:48 status installed bacula-director:amd64 15.0.3-1~bpo12+1

-- 
     w at uter.{be,co.za}
wouter@{grep.be,fosdem.org,debian.org}

I will have a Tin-Actinium-Potassium mixture, thanks.