Re: [Bacula-users] Strange problem with Bacula

Cedric Tefft wrote:
> Reynier Pérez Mira wrote:
>> Hi:
>>
>> Cedric Tefft wrote:
>>> Reynier Pérez Mira wrote:
>>> Probably /tmp.  Run "show variables where Variable_name = 'tmpdir';"
>>> in mysql to find out for sure.
>>
>> I use PostgreSQL instead of MySQL. What this query should return? How
>> I can run the same query in Postgres? I suspect it may be a thing of
>> the postgres tablespaces because I use the default tablespace.
> I don't know what the equivalent would be in Postgres, or if there is an
> equivalent.  What you're looking for is the directory Postgres uses when
> it needs to write temporary tables to disk.  I suggest checking the
> Postgres manual and/or Google.
>>
>>
>> I tought this lines are a little suspicious, don't you think?
>>
>> 23-Sep 03:17 serverbacula-dir JobId 2215: Fatal error:
>> sql_create.c:825 Fill File table Query failed: INSERT INTO File
>> (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT
>> batch.FileIndex, batch.JobId, Path.PathId,
>> Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
>> (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
>> Filename.Name): ERR=ERROR:  could not write to hash-join temporary
>> file: No space left on device
> Well, it's an ERROR message, so it's definitely not good, but
> "suspicious"?  No.
>>
>>> Be aware that if the problem really is a lack of temp space, you
>>> would probably only see /tmp at or near capacity WHILE bacula is
>>> actively trying to update the database (i.e. not before or after).
>>
>> So /tmp will be full capacity WHILE bacula try to save data? Is that
>> what you said?
> Yes.
> 

All of this come due to the use of batch-insert option ( compile option )
So to "accelerate" the insert of records into the db, bacula-dir write each 
record during the backup
into Batch temp table. After all records are written to the sd, dir try to make 
one big transaction with the db.

So during the backup this file is written on disk normally into /tmp perharps 
elsewhere /var/lib/bacula
don't know exactly where.
As your postgresql claim to not have suffisant space for hash-join temporary 
file you should also check
where postgresql is working /var/lib/pgsql under openSUSE for example ...



-- 

     Bruno Friedmann


------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; 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&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users