My last backup job failed because the catalog database ran of room on the disk. I see the section of the manual about database maintenance, but I have a concern and a question.
The concern is that my catalog is now messed up, not just for that particular job but in general. What state is it in? Will it be OK, at least if the database (postgres) utilities say the database is OK? My reading of the logs is that the actual backup (to disk--a different one from the catalog) is OK. Is it? If so, could I restore the catalog entries by using one of the restore utilities and the backup? Here's part of the job log from bacula: 08-Oct 07:32 corn-sd: Job write elapsed time = 07:08:23, Transfer rate = 168.8 K bytes/second 08-Oct 07:32 corn-fd: ClientAfterJob: run command "super cyrus-resume" 08-Oct 07:32 corn-fd: ClientAfterJob: Starting Cyrus IMAPd: cyrmaster. 08-Oct 07:37 corn-dir: Cyrus.2007-10-08_00.05.02 Fatal error: Can't fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name) : ERR= Note that it got to the run after job, and that the failure is reported 5 minutes (!) after everything else seemed to finish. Here are the postgres logs: 2007-10-08 00:24:01 PDT ERROR: table "delcandidates" does not exist 2007-10-08 00:24:01 PDT STATEMENT: DROP TABLE DelCandidates 2007-10-08 00:24:01 PDT ERROR: index "delinx1" does not exist 2007-10-08 00:24:01 PDT STATEMENT: DROP INDEX DelInx1 2007-10-08 00:24:01 PDT ERROR: index "delinx1" does not exist 2007-10-08 00:24:01 PDT STATEMENT: DROP INDEX DelInx1 2007-10-08 05:02:03 PDT LOG: incomplete startup packet 2007-10-08 07:37:08 PDT ERROR: could not write to hash-join temporary file: No space left on device 2007-10-08 07:37:08 PDT STATEMENT: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name) 2007-10-08 07:37:10 PDT ERROR: table "delcandidates" does not exist 2007-10-08 07:37:10 PDT STATEMENT: DROP TABLE DelCandidates 2007-10-08 07:37:10 PDT ERROR: index "delinx1" does not exist 2007-10-08 07:37:10 PDT STATEMENT: DROP INDEX DelInx1 2007-10-08 07:37:11 PDT ERROR: index "delinx1" does not exist 2007-10-08 07:37:11 PDT STATEMENT: DROP INDEX DelInx1 By the way, are all those other errors normal? ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
