Frank Sweetser wrote:
Jeff Dickens wrote:Apparently I've messed up my catalog. It began when I ran the system disk (with the database on it) out of disk, big time. Rats.Symptoms: Jobs fail like this: 17-Jul 00:43 packrat-dir: Start Backup JobId 7780, Job=nymph.2007-07-16_23.05.26 17-Jul 00:43 nymph-fd: DIR and FD clocks differ by -2 seconds, FD automatically adjusting. 17-Jul 00:43 packrat-sd: Recycled volume "nymph-diff-0002" on device "nymph-filedev" (/bacula/nymph), all previous data lost. 17-Jul 00:43 packrat-dir: Volume used once. Marking Volume "nymph-diff-0002" as Used. 17-Jul 00:43 packrat-dir: nymph.2007-07-16_23.05.26 Fatal error: sql_create.c:845 sql_create.c:845 query SELECT FilenameId FROM Filename WHERE Name='printers.conf' failed: Can't open file: 'Filename.MYI' (errno: 145) 17-Jul 00:43 packrat-dir: nymph.2007-07-16_23.05.26 Fatal error: sql_create.c:870 sql_create.c:870 insert INSERT INTO Filename (Name) VALUES ('printers.conf') failed: Can't open file: 'Filename.MYI' (errno: 145)This is absolutely a lower level database problem. First thing to check for is make sure that the underlying filesystem is good - no kernel errors, and you haven't run out of disk space. If nothing obvious pops up there, the next step would be to run a mysql repair on the table to see what's recoverable. http://dev.mysql.com/doc/refman/5.0/en/repair.html Once you get things stable, you'll want to run a dbcheck on the catalog to check for any missing records.
I think I have fixed the database issues. Does this look like nothing should have been lost? [EMAIL PROTECTED] bacula]# myisamchk -r -t /bacula2/tmp Filename.MYI - recovering (with sort) MyISAM-table 'Filename.MYI' Data records: 747376 - Fixing index 1 Found block that points outside data file at 23494648 - Fixing index 2 [EMAIL PROTECTED] bacula]# myisamchk Filename.MYI Checking MyISAM file: Filename.MYI Data records: 747376 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links [EMAIL PROTECTED] bacula]# [EMAIL PROTECTED] bacula]# And bacula can do a "list files" now ! *list files jobid=7706 +-----------------------------------------------------+ | Filename | +-----------------------------------------------------+ | /etc/ | | /etc/dhcpd.conf | | /etc/prelink.cache | | /etc/cups/certs/ | | /etc/cups/certs/0 | | /etc/cups/ppd/ | | /etc/cups/ | | /etc/cups/classes.conf | | /etc/cups/cupsd.conf | | /etc/cups/printers.conf | | /etc/samba/smbpasswd | | /etc/dnscache/log/main/ | | /etc/dnscache/log/main/current | | /etc/dnscache/log/main/@400000004696f2c32d7a47d4.s | | /etc/dnscache/log/main/@400000004696fb7628002e54.s | | /etc/dnscache/log/main/@400000004696e47b1aacc9ec.s | | /etc/dnscache/log/main/@400000004696e17734a47e6c.s | | /etc/dnscache/log/main/@400000004696eb7c0a4a7004.s | | /etc/dnscache/log/main/@40000000469700661e02c704.s | | /etc/dnscache/log/main/@40000000469701320b6af74c.s | | /etc/dnscache/log/main/@400000004696e0870fddc674.s | | /etc/dnscache/log/main/@400000004696f311091aba04.s | | /etc/dnscache/root/servers/ | | /etc/dnscache/root/servers/intranet.seamanpaper.com | | /etc/dnscache/supervise/ | | /etc/dnscache/supervise/status | | /etc/dnscache/supervise/control | +-----------------------------------------------------+ +-------+-------+---------------------+------+-------+----------+-----------+-----------+ | JobId | Name | StartTime | Type | Level | JobFiles | JobBytes | JobStatus | +-------+-------+---------------------+------+-------+----------+-----------+-----------+ | 7,706 | nymph | 2007-07-13 00:36:02 | B | D | 27 | 1,085,061 | T | +-------+-------+---------------------+------+-------+----------+-----------+-----------+ * Thanks for steering me in the right direction!
------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/
_______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
