On 10/12/2009 10:51 AM, Jon Schewe wrote:
> Jari Fredriksson wrote:
>>> I got the error below on my backups this weekend.
>>> According to make_tables_mysql there is no table named
>>> "batch" in the database. What should the schema for this
>>> table look like? I'm using bacula 2.2.7 under OpenSUSE
>>> 11.0.
>>>
>>> 11-Oct 13:59 mn-server-dir JobId 3419: Fatal error:
>>> sql_create.c:732 sql_create.c:732 insert INSERT INTO
>>> batch VALUES
>>> (2772,3419,'/nfshomes/jschewe/projects/smite/apl/rr2-final/','rtensplit-20090924-0028.scy.log','P0C
>>> SWQH6 IHA B CcQ CcQ A jZRDgc BAA EbKLw BK0V8B BKziHW
>>> BKz2d0 A A X','QV3Vz3rvJNMZh8JPcxADow') failed: Table
>>> 'bacula.batch' doesn't exist 11-Oct 13:59 mn-server-dir
>>> JobId 3419: Fatal error: catreq.c:482 Attribute create
>>> error. sql_update.c:454
>>>
>>
>> batch is a temporary table that Bacula normally creates and drops on the
>> fly. No idea why it does not exist in your backup.
>>
>>
> It's done it two days in a row with the same filename specified. Any
> ideas on how to debug this?
>
The most common problem seems to be either 1) the mysql account that bacula is
using doesn't have permission to create the temporary table, or 2) the
partition mysql is configured to use for for tmp storage filled up, leaving no
more room for the temp table.
--
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
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
