[Bacula-users] Fwd: Re: job scheduling snafoo

[Hugo <ma...@hu...>]

>>>>> 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:        ba...@ma...
    Traceback Email:         root@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
Bac...@li...
https://lists.sourceforge.net/lists/listinfo/bacula-users