Jeff Dickens wrote:
> 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?
I'd still do a dbcheck to make sure, but that looks good. The safest thing to
do at this point would be to just run a round of full backups to make sure
there's a good baseline for everything.
--
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
