Daniel Wedewardt wrote:
> 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
>>
> 
> 
>

Hi Daniel,

We see in the query error that you use the batch insert mode ...
With the size of your backup this could be the issue as a disk full the time 
the the batch insert should run.
The error could be translate to "sorry I've not more disk space to grow the 
Filename index file" :-)))

Try to have a watcher on the free space of where the tmp for mysql is write and 
where mysql data is write.



Sorry Dan but this has nothing to do with mysql ( which in my experience work 
as well as postgresql )


-- 

     Bruno Friedmann  bruno AT ioda-net DOT ch

Ioda-Net Sàrl   - www.ioda-net.ch
  2830 Vellerat - Switzerland

  Tél : ++41 32 435 7171
  Fax : ++41 32 435 7172
  gsm : ++41 78 802 6760

C'est Facile et Cool d'Évoluer en ligne : www.cfcel.com


-------------------------------------------------------------------------
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