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® 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/devconf _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users