Re: [Bacula-users] Fatal error inserting into "batch" table.

When running the first full backup of my largest host "pris", the
backup failed with this output:

17-Apr 16:26 gaff-dir JobId 1: Fatal error: sql_create.c:732
sql_create.c:732 insert INSERT INTO batch VALUES
(2094743,1,'/home/gary/devel/LMS7.0.0/src/lib/.svn/prop-base/','WebImportCycleRatings.pm.svn-base','P4A
EMXG IEk B Pt Pt A i BAA I BIBr+D BHITLl BHITLm A A
E','JebC91WLdIQADU0JDepbkg') failed:
Incorrect key file for table '/tmp/#sql136f_26_0.MYI'; try to repair it

This message here shows that the temporary table 'batch' showed up as being corrupted. Usually this means that the partition holding /tmp ran out of disk space during the backup.

Thank you!

That was exactly the problem. I made my /tmp filesystem much larger. Now Bacula seems to be running very well.

Thanks again,
Toby.

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