Hi everyone,
I've got a corrupted catalog on a bad disk and could really use some advice
on how to proceed.
I'm very new to bacula (and pretty new to sysadmin after many years
programming), and have inherited a bacula system that's been untended for a
year and a half or more.
It's running Bacula 3.0.1, which I know is very old.
There's about 30TB of data backed up across about 5 jobs.
**** the issue
I'm seeing the error in bacula logs:
ERR=Duplicate entry '1828889455' for key 1
running dbcheck yields:
"Query failed: SELECT File.FileId,Job.JobId FROM File LEFT OUTER JOIN Job ON
(File.JobId=Job.JobId) WHERE Job.JobId IS NULL LIMIT 300000: ERR=Table
'./bacula/File' is marked as crashed and should be repaired".
But running 'myisamchk -r -q File.MYI' yields:
"myisamchk: error: - check record delete-chain
Can't read delete-link at filepos: 13937713076
myisamchk: error: Quick-recover aborted; Run recovery without switch 'q'
Updating MyISAM file: File.MYI
MyISAM-table 'File.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or
by not using the --quick (-q) flag"
Before running a more full recovery, I tried copying the database, but got
this error:
"cp: reading `File.MYD': Input/output error"
This seems to be a disk error, but I ran 'xfs_repair' anyway but it didn't
fix anything, not surprising.
Catalog backups:
There's a script running on the machine that backs up the catalog nightly to
another disk using /usr/lib/bacula/make_catalog_backup and I have several
days worth of these. This disc is backed up by bacula too. HOWEVER, looking
at catalog.txt log (in the same dir as these backups, it looks like a log
from make_catalog_backup ), it shows this error's been happening since Nov
2012, so my recent catalog dumps aren't going to be good.
**** what's next?
After replacing the bad disk:
Can i reconstruct the catalog just from the backup data itself? It's on
tapes, fwiw. How do I go about doing this?
If I can get one of the old catalog dumps off one of the backup tapes, can I
recontruct from that even though there have been backups since then?
Do I resolve this with Bacula 3.0.1 before upgrading to the latest? Seems to
make sense.
Any suggestions or insights would be greatly appreciated!
Thanks,
Michael
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
