>>>>> On Tue, 14 Dec 2010 16:54:12 +0100, Hugo said:
>
> Building directory tree for JobId(s) 84,85,86,87,88,89,90,92 ...
> Query failed: SELECT Path.Path, Filename.Name, Temp.FileIndex,
> Temp.JobId, LStat, MD5 FROM ( SELECT DISTINCT ON (FilenameId,
> PathId) StartTime, JobId, FileId, FileIndex, PathId, FilenameId,
> LStat, MD5 FROM (SELECT FileId, JobId, PathId, FilenameId, FileIndex,
> LStat, MD5 FROM File WHERE JobId IN (84,85,86,87,88,89,90,92)
> UNION ALL SELECT File.FileId, File.JobId, PathId, FilenameId,
> File.FileIndex, LStat, MD5 FROM BaseFiles JOIN File USING (FileId)
> WHERE BaseFiles.JobId IN (84,85,86,87,88,89,90,92) )
> AS T JOIN Job USING (JobId) ORDER BY FilenameId, PathId, StartTime DESC
> ) AS Temp JOIN Filename ON (Filename.FilenameId = Temp.FilenameId)
> JOIN Path ON (Path.PathId = Temp.PathId) WHERE FileIndex > 0 ORDER
> BY Temp.JobId, FileIndex ASC:
> ERR=could not receive data from server: Operation now in progress
>
> For one or more of the JobIds selected, no files were found,
> so file selection is not possible.
> Most likely your retention policy pruned the files.
>
> Do you want to restore all the files? (yes|no): no
> ---
>
> what seems to be the problem here? is the director
> choking on the SQL data from the server? it is a rather
> large response, the postgreSQL server needs around 2 minutes to
> answer it, and if I pipe it into a file, it is a few hundreds
> of MB big..
Looks like a bug or misfeature in PostgreSQL to me.
Is your libpq compiled with the command line argument --enable-thread-safety ?
__Martin
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|