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.
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
-------------------------------------------------------------------------
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
