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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
