Re: [Bacula-users] Can't fill Filename
2008-04-23 09:59:00
Hi Dan, Hi Frank,
thanks for the really fast response.
I've also thought about to switch from MySQL to Postgres but don't know
if it really solve this problem. I will try!
As I have written in my first mail, I've already done the suggested
repair process. Sadly but true, I've forgotten to catch the output
(there was nothing to repair, the tabel was fine) and send attach it to
mail first mail. If the current backupjob is over (in ~20 hours) I will
do it again and post it to you.
Bye
Daniel
Am Mittwoch, den 23.04.2008, 09:27 -0400 schrieb Frank Sweetser:
> Dan Langille wrote:
> > Daniel Wedewardt wrote:
> >> Hi,
> >>
> >> I've got a serious problem with my bacula backup. Sometimes it happens,
> >> that a backup fail with the following error message:
> >>
> >> 23-Apr 10:43 backup-dir JobId 4873: Fatal error: Can't fill Filename
> >> table Query failed: INSERT INTO Filename (Name) SELECT a.Name FROM
> >> (SELECT DISTINCT Name FROM batch) AS a WHERE NOT EXISTS (SELECT Name
> >> FROM Filename AS f WHERE f.Name = a.Name): ERR=Incorrect key file for
> >> table './bacula/Filename.MYI'; try to repair it
>
> The 'try to repair' message means that your tables are corrupted, and you
> need
> to start a repair operation on them.
>
> http://dev.mysql.com/doc/refman/5.0/en/repair.html
>
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|