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.
Yes, I very definitely did let it run out of disk space. So I am
assuming it is well and truly messed and that I need to restore the
catalog. Do you think this is true?
-------------------------------------------------------------------------
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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
