Hello Stefan,

Am 01.06.2026 um 00:29 schrieb Stefan Harbich:
Hello,
my Bacularis / Bacula installation is running on a virtual Proxmox
machine. The PostgreSQL cluster sits behind an HAProxy. The PostgreSQL
server runs on 3 nodes (etcd & Patroni). The connection between the
Bacula Catalog and the PostgreSQL cluster is encrypted via TLS. I have
this error messages for your reference.

...
31-May 23:30 bacula-dir JobId 4: Fatal error: bdb.h:146 bdb.h:146 query
SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,VolHol
eBytes,VolHoles,VolMounts,VolErrors,VolWrites,Media.MaxVolBytes,Media.V
olCapacityBytes,MediaType,VolStatus,Media.PoolId,Media.VolRetention,Med
ia.VolUseDuration,Media.MaxVolJobs,Media.MaxVolFiles,Media.Recycle,Slot
,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,V
olCloudParts,LastPartBytes,Media.LabelType,LabelDate,StorageId,Media.En
abled,LocationId,RecycleCount,InitialWrite,Media.ScratchPoolId,Media.Re
cyclePoolId,VolReadTime,VolWriteTime,Media.ActionOnPurge,Media.CacheRet
ention,Protected,UseProtect,VolEncrypted,Pool.Name FROM Media JOIN Pool
USING (PoolId) WHERE VolumeName='Full-0001' failed:
SSL SYSCALL error: EOF detected

I would say that at this point, the Director's connection to the catalog database was lost.

I would recommend to start checking logs of both HAProxy and the PostgreSQL servers.

How to trace/debug the PostgreSQL client library is something I would have to look up myself, but my experience with anything using TLS makes me reluctant to believe that this will lead anywhere -- the additional complexitity prevents my understanding what is going on, so I usually end up trying to figure out what happens outside of the connection itself.

31-May 23:31 bacula-dir JobId 4: Error: Unable to get Media record for
Volume Full-0001: ERR=Media record for Volume Name "Full-0001" not
found in Catalog.
31-May 23:32 bacula-sd JobId 4: Fatal error: Error getting Volume info:
1991 Catalog Request for vol=Full-0001 failed: Query failed: INSERT
INTO Log (JobId, Time, LogText) VALUES (4,'2026-05-31
23:31:42','bacula-dir JobId 4: Error: Unable to get Media record for
Volume Full-0001: ERR=Media record for Volume Name "Full-0001" not
found in Catalog.
'): ERR=no connection to the server

And by the way, the subsequent errors appear to be caused by the lost database connection. The short term solution is to restart the DIR and hope for the best, but hope doesn't seem like a strategy aligned with your setup :-)

Cheers,

Arno

--
Arno Lehmann

IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück



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

Reply via email to