Bacula-users

Re: [Bacula-users] Problem inserting into table "batch"?

2009-10-12 11:23:58
Subject: Re: [Bacula-users] Problem inserting into table "batch"?
From: Frank Sweetser <fs AT WPI DOT EDU>
To: Jon Schewe <jpschewe AT mtu DOT net>
Date: Mon, 12 Oct 2009 11:19:53 -0400
On 10/12/2009 11:08 AM, Jon Schewe wrote:
> Frank Sweetser wrote:

>> 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.
>>
> I just checked 1 and the account has permissions. I've got 1.4GB
> available in /tmp. I would expect this to be enough space. What
> information is all put in this table?

The table acts as a buffer for all of the catalog metadata (list of files 
backed up, and their various attributes).  It's hard to say whether or not 
that's enough space, as it's really a function of how many files you're 
backing up.

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