>>>>> 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
