Debian Postgres security update to 13.17 broke bacula

It seems there was a medium security update released for postgresql-13
on Debian bookworm (oldstable), and right after that bacula stopped
working due to "no connection to the server".  For example, got this
e-mail about the catalog backup:

> 15-Nov 20:36 hind-dir JobId 0: Fatal error: bdb.h:143 bdb.h:143 query SELECT ClientId,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Name='hind-fd' failed:
> no connection to the server
>
> 15-Nov 20:37 hind-dir JobId 0: Error: sql_create.c:568 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('hind-fd','',1,18144000,18144000) failed. ERR=no connection to the server
>
> 15-Nov 20:38 hind-dir JobId 0: Fatal error: Could not create Client record. ERR=Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (0,'2024-11-15 20:37:40','hind-dir JobId 0: Error: sql_create.c:568 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES (''hind-fd'','''',1,18144000,18144000) failed. ERR=no connection to the server
>
> '): ERR=no connection to the server

All other jobs are also failing due to similar errors :(  Yet, the
server appears to be running normally:

> ● [email protected] - PostgreSQL Cluster 13-main
>      Loaded: loaded (/lib/systemd/system/[email protected];
> enabled-runtime; vendor preset: enabled)
>      Active: active (running) since Fri 2024-11-15 06:47:24 MST; 3
> days ago
>    Main PID: 669430 (postgres)
>       Tasks: 7 (limit: 38544)
>      Memory: 18.5M
>         CPU: 4min 3.208s
>      CGroup:
> /system.slice/system-postgresql.slice/[email protected]
>              ├─669430 /usr/lib/postgresql/13/bin/postgres -D
> /var/lib/postgresql/13/main -c
> config_file=/etc/postgresql/13/main/postgresql.conf
>              ├─669519 postgres: 13/main: checkpointer
>              ├─669520 postgres: 13/main: background writer
>              ├─669521 postgres: 13/main: walwriter
>              ├─669522 postgres: 13/main: autovacuum launcher
>              ├─669523 postgres: 13/main: stats collector
>              └─669524 postgres: 13/main: logical replication launcher
>
> Nov 15 06:47:22 hind systemd[1]: Starting PostgreSQL Cluster 13-main...
> Nov 15 06:47:24 hind systemd[1]: Started PostgreSQL Cluster 13-main.

What do?

-- 
The University of Arizona block 'A' logo.
	*Chandler Sobel-Sorenson*
Sr. Systems Administrator
Arizona Genomics Institute
School of Plant Sciences—Research
THE UNIVERSITY OF ARIZONA

Thomas W. Keating Bioresearch Bldg. | Rm. 200A24
1657 E. Helen St. | Tucson, AZ 85721
Office: 520-626-9589 <tel:520-626-9589> | Cell: 520-907-4352
<tel:520-907-4352>

[email protected] <mailto: [email protected]>
Pronouns: he/him/his
*www.genome.arizona.edu* <https://www.genome.arizona.edu/>

	Integrity, Compassion, Exploration, Adaptation, Inclusion,
Determination <https://brand.arizona.edu/signature>




_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users