Hi all, Bacula catalog in Postgress has become corrupted it seems due to disk errors. I can still make a backup, but cannot dump the catalog anymore.
It does write most of the catalog, but doesn't complete. This occurs after a lot of full backups this weekend, so I am not fond of deleting the catalog and reloading the one from friday. The catalog resides on an ordinary IDE disk. Does anyone have a suggestion as to how I can best rescue the system - how can I get the full catalog copied over to a new disk and continue to run? I have been thinking of simply restarting the server, then it would repair the disk structure if possible, but how can I best prepare for the scenario that it won't and can't start or that the repair will destroy the catalog? Errors here: 04-Sep 13:24 adm-backup-dir: RunBefore: pg_dump: ERROR: could not read block 202758 of relation 1663/17230/2194377: Success 04-Sep 13:24 adm-backup-dir: RunBefore: pg_dump: SQL command to dump the contents of table "file" failed: PQendcopy() failed. 04-Sep 13:24 adm-backup-dir: RunBefore: pg_dump: Error message from server: ERROR: could not read block 202758 of relation 1663/17230/2194377: Success 04-Sep 13:24 adm-backup-dir: RunBefore: pg_dump: The command was: COPY public.file (fileid, fileindex, jobid, pathid, filenameid, markid, lstat, md5) TO stdout; 04-Sep 13:24 adm-backup-dir: BackupCatalog.2006-09-04_13.22.45 Fatal error: RunBeforeJob error: ERR=Child exited with code 1 There are hardware errors in syslog: Sep 4 13:24:12 adm-backup kernel: hda: dma_intr: status=0x51 { DriveReady SeekComplete Error } Sep 4 13:24:12 adm-backup kernel: hda: dma_intr: error=0x40 { UncorrectableError }, LBAsect=344781, sector=344775 Sep 4 13:24:12 adm-backup kernel: ide: failed opcode was: unknown Sep 4 13:24:12 adm-backup kernel: end_request: I/O error, dev hda, sector 344775 -- Regards Steen ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users