Hi, I'm not sure whether I should be sending this to the bacula or postgres mailinglists.
I'm using Bacula 9.0.6 on Ubuntu 18.04.4 using a postgres 9.5 database (on a separate server). At some point the database server ran out of disk. I added some more disk space and rebooted the server however now I'm having strange issues. Backing up all clients seems to work fine, however the backup of the backup server catalog itself crashes the postgres database. e.g.: 22-May 00:23 backup-dir JobId 39218: shell command: run BeforeJob "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog" 22-May 00:31 backup-dir JobId 39218: BeforeJob: pg_dump: Dumping the contents of table "file" failed: PQgetCopyData() failed. 22-May 00:31 backup-dir JobId 39218: BeforeJob: pg_dump: Error message from server: SSL SYSCALL error: EOF detected 22-May 00:31 backup-dir JobId 39218: BeforeJob: pg_dump: The command was: COPY public.file (fileid, fileindex, jobid, pathid, filenameid, deltaseq, markid, lstat, md5) TO stdout; 22-May 00:32 backup-dir JobId 39218: Error: Runscript: BeforeJob returned non-zero status=1. ERR=Child exited with code 1 22-May 00:34 backup-dir JobId 39218: Error: bdb.h:130 bdb.h:130 update UPDATE Job SET JobStatus='E',Level='F',StartTime='2020-05-22 00:33:31',ClientId=1,JobTDate=1590100411,PoolId=4,FileSetId=13 WHERE JobId=39218 failed: no connection to the server It seems that every time I attempt a full dump of the database the postgres server just dies. I tried upgrading postgres to the latest version, but that doesn't make a difference. Unfortunately it took me quite a while to discover this issue so the last successfull backup of the catalog is about 2 months old. Is there anyway to recreate the bacula database? Can I restore the database from 2 months ago and then rescan all newer backups? Nico -- Nico De Ranter Operations Engineer T. +32 16 38 72 10 <http://www.esaturnus.com> <http://www.esaturnus.com> eSATURNUS Philipssite 5, D, box 28 3001 Leuven – Belgium T. +32 16 40 12 82 F. +32 16 40 84 77 www.esaturnus.com <http://www.esaturnus.com/> *For Service & Support :* Support Line Belgium: +32 2 2009897 Support Line International: +44 12 56 68 38 78 Or via email : medical.services...@sony.com
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users