Bacula-users

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

2008-04-17 09:32:23
Subject: Re: [Bacula-users] Fatal error inserting into "batch" table.
From: Frank Sweetser <fs AT WPI DOT EDU>
To: Toby McLaughlin <toby AT jarpy DOT net>
Date: Thu, 17 Apr 2008 09:28:42 -0400
Toby McLaughlin wrote:
> Hello,
> 
> I'm new to Bacula and struggling with a crash when backing up my
> largest server. The crash is thankfully repeatable. I hope that you
> can help and that I am not simply reporting my own failings.
> 
> I'm running the current Debian/testing binaries (2.2.8-8) on x86
> against Debian's MySQL 5.0.51a-3
> 
> 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.

-- 
Frank Sweetser fs at wpi.edu  |  For every problem, there is a solution that
WPI Senior Network Engineer   |  is simple, elegant, and wrong. - HL Mencken
     GPG fingerprint = 6174 1257 129E 0D21 D8D4  E8A3 8E39 29E3 E2E8 8CEC

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