Re: [Bacula-users] Strange problem with Bacula

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.


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