Re: [Bacula-users] Strange problem with Bacula

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

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

Cheers and thanks again

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