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.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

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