On 7/09/2012 11:37 PM, Phil Stracchino wrote:
> On 09/07/12 08:37, hymie! wrote:
>> Greetings.
>>
>> My bacula instance has, as far as I know, been running for many months
>> without issue.  Suddenly, it has generated the following SQL query which
>> crashed my SQL server:
>>
>> 05-Sep 01:14 herman-dir JobId 1955: sql_create.c:731 INSERT INTO batch 
>> VALUES 
>> (138780,1955,'/home/hymie/BrettspielWelt/rotacticalPics/levels/levels/','level_097.txt','gn
>>  YR6 IGk B y Bk A Jk BAA I BQQEgJ +60Mh BFalPG A A 
>> C','26E4+aYmrT4Wxos4e34ysA')
>>
>> As far as I can tell, there is no table named "batch".  None of my
>> bacula instances (5.0.3) have a table named "batch".  The "make-mysql-tables"
>> file also has no reference to a table named "batch".
>>
>> Can somebody tell me (or guide me to troubleshoot) what happened?
> This is a temporary table used to gather metadata for batch inserts.  It
> exists only while a job is running.
Strong suggestion that you ran out of temporary file space during the 
batch insert.  Have you moved the MySQL temp dir somewhere with lots of 
space?

     Cheers,
         Gary    B-)

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users