On 30/07/10, Dan Langille (dan AT langille DOT org) wrote:
> On 7/30/2010 3:53 AM, Rory Campbell-Lange wrote:
> >
> > Fatal error: sql_create.c:843 Batch end postgresql.c:748 error ending
> > batch mode: ERROR: could not extend relation 1663/17472/17828:
> > wrote only 4096 of 8192 bytes at block 98374
> > HINT: Check free disk space.
...
> >The database itself is only just over 500MB.
>
> I think you're suggesting Bacula used up 3.4GB in a query..
>
> How many files are you backing up?
7,643,966 files taking up 7.265 T of space on tape.
...
> Umm, or it could be a problem with the way you have your computer
> system configured. :) It's a matter of perspective. In a 6.5TB
> backup, I'm going to guess there are a large number of files, given
> that var filled up. Can you extend var? Or create a symlink to
> another filesystem to give PostgreSQL the space it needs.
I'm intrigued about this batch file. Where is it and how big is it? I
can increase the size of /var, or move the postgresql database mount
point, but it is difficult to know how much size it may require.
> > Is it not possible to change this
> >arrangement to use sequential inserts instead?
>
> Look at the Spool Attributes directive. Set it to know. This way,
> the details of each file will be added to the database right after
> that file is backed up.
I turned off spooling and set the Spool Attributes directive to no and
reran the backup. The backup job completes but the database insert bails
out.
clwbackup-dir JobId 8: Fatal error: sql_create.c:894 Fill File table
Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId,
LStat, MD5)SELECT batch.FileIndex, bat ch.JobId, Path.PathId,
Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batc
h.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
I don't understand why bacula isn't writing to the database
continuously. Why is a batch file needed?
--
Rory Campbell-Lange
rory AT campbell-lange DOT net
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|