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
> 
> Mostly it happens while backing up a hugh amount of data (3-5tb). 
> My System: Debian, Bacula-Dir Version 2.2.6, MySQL (Version 5, installed
> on the same system where the sd and dir is running) Backend, MyISAM DB.
> 
> I've tried a mysql "repair table Filename" but the table wasn't corrupt.
> That fit's with the circumstance, that other backupjobs are working very
> well. 
> 
> Hope someone can help.

My first suggestion, which not extremely helpful, is to use PostgreSQL, 
not anything else.

I wonder what a dbcheck will show on your db.

Hopefully, someone else will have a better idea of why this is messing 
up.  It looks, to me, like a MySQL issue, not a Bacula issue.

-- 
Dan Langille

BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference:     http://www.pgcon.org/

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