>>>>> 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
nope, it's not
appendix{su-root}(*)[51]: nm /opt/postgresql-8.2.4/lib/libpq.a | grep
pthread_mutex_loc
appendix{su-root}(*)[52]:
but i didn't think that is a problem if I configured bacula w/o batch inserts
is it?
here is my bacula_config:
Configuration on Tue Oct 12 14:50:46 CEST 2010:
Host: sparc-sun-solaris2.10 -- solaris 5.10
Bacula version: Bacula 5.0.3 (04 August 2010)
Source code location: .
Install binaries: /opt/bacula-5.0.3/sbin
Install libraries: /opt/bacula-5.0.3/lib
Install config files: /opt/bacula-5.0.3/etc
Scripts directory: /opt/bacula-5.0.3/etc
Archive directory: /tmp
Working directory: /opt/bacula-5.0.3
PID directory: /var/run
Subsys directory: /var/run/subsys
Man directory: ${datarootdir}/man
Data directory: /opt/bacula-5.0.3/share
Plugin directory: /opt/bacula-5.0.3/lib
C Compiler: gcc 3.4.6
C++ Compiler: /usr/local/bin/g++ 3.4.6
Compiler flags: -g -O2 -Wall -fno-strict-aliasing -fno-exceptions
-fno-rtti
Linker flags:
Libraries: -lpthread -lresolv -lnsl -lsocket -lxnet -lintl
-lresolv -lrt
Statically Linked Tools: no
Statically Linked FD: no
Statically Linked SD: no
Statically Linked DIR: no
Statically Linked CONS: no
Database type: PostgreSQL
Database port: 5432
Database lib: -L/opt/postgresql-8.2.4/lib -lpq
Database name: backup
Database user: bacula
Job Output Email: bac...@mail.de
Traceback Email: r...@localhost
SMTP Host Address: localhost
Director Port: 9101
File daemon Port: 9102
Storage daemon Port: 9103
Director User: bacula
Director Group: backup
Storage Daemon User: bacula
Storage DaemonGroup: backup
File Daemon User:
File Daemon Group:
SQL binaries Directory /opt/postgresql-8.2.4/bin
Large file support: yes
Bacula conio support: yes -lncurses
readline support: no
TCP Wrappers support: no
TLS support: no
Encryption support: no
ZLIB support: yes
enable-smartalloc: yes
enable-lockmgr: no
bat support: no
enable-gnome: no
enable-bwx-console: no
enable-tray-monitor: no
client-only: no
build-dird: yes
build-stored: yes
Plugin support: yes
AFS support: no
ACL support: yes
XATTR support: yes
Python support: no
Batch insert enabled: no
__EOC__
------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
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
