Bacula-users

[Bacula-users] Can't fill Filename

2008-04-23 09:10:12
Subject: [Bacula-users] Can't fill Filename
From: Daniel Wedewardt <daniel.wedewardt AT native-instruments DOT de>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 23 Apr 2008 15:09:20 +0200
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.

Bye


Daniel
-- 
Daniel Wedewardt
IT Manager | Systems | Operations

Tel +49-30-611035-1711
Fax -49-30-611035-2711
daniel.wedewardt AT native-instruments DOT de

NATIVE INSTRUMENTS GmbH
Schlesische Str. 28
10997 Berlin, Germany
http://www.native-instruments.com

***

KORE 2 - the universal sound platform becomes the Super Instrument
=> http://www.native-instruments.com/kore.info

Beatport SYNC - the free audio player with DJ functionality
=> http://www.native-instruments.com/beatportsync.info

->>>>>> NATIVE INSTRUMENTS - The Future of Sound <<<<<<-

Registergericht: Amtsgericht Charlottenburg
Registernummer: HRB 72458
UST.-ID.-Nr. DE 20 374 7747
Geschaeftsfuehrer: Daniel Haver, Stephan Schmitt


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

<Prev in Thread] Current Thread [Next in Thread>