I rised debug to 500.
Before the I issue the "list volumes" on bconsole, I see a LOT LOT of debug about postgres selects going through very fine.
Once I run the bconsole command I find this:
iserver-dir: scheduler.c:253 enter find_runs()
iserver-dir: scheduler.c:289 Got job: Enterprise Backup
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: Backup Aliseo
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: Backup ZetaFax
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: Backup Centralino
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: BackupCatalog
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:355 Leave find_runs()
iserver-dir: bsys.c:70 pthread_cond_timedwait sec=60 usec=0
iserver-dir: ua_cmds.c:1615 Open database
iserver-dir: postgresql.c:77 db_open first time
iserver-dir: bsys.c:70 pthread_cond_timedwait sec=5 usec=0
iserver-dir: bsys.c:77 pthread_cond_timedwait stat=145 ERR=Connection timed out
----------------------------------------------------------------------------------
Da: MaxxAtWork <[EMAIL PROTECTED]>
A: Gabriele Bulfon <[EMAIL PROTECTED]> bacula-users@lists.sourceforge.net
Data: 12 settembre 2006 9.54.28 CEST
Oggetto: Re: [Bacula-users] Bacula-dir and remote Postgres
Before the I issue the "list volumes" on bconsole, I see a LOT LOT of debug about postgres selects going through very fine.
Once I run the bconsole command I find this:
iserver-dir: scheduler.c:253 enter find_runs()
iserver-dir: scheduler.c:289 Got job: Enterprise Backup
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: Backup Aliseo
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: Backup ZetaFax
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: Backup Centralino
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:289 Got job: BackupCatalog
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:332 [EMAIL PROTECTED]: run_now=0 run_nh=0
iserver-dir: scheduler.c:355 Leave find_runs()
iserver-dir: bsys.c:70 pthread_cond_timedwait sec=60 usec=0
iserver-dir: ua_cmds.c:1615 Open database
iserver-dir: postgresql.c:77 db_open first time
iserver-dir: bsys.c:70 pthread_cond_timedwait sec=5 usec=0
iserver-dir: bsys.c:77 pthread_cond_timedwait stat=145 ERR=Connection timed out
|
Gabriele Bulfon - Sonicle S.r.l. Tel +39 028246016 Int. 30 - Fax +39 028243880 Via Felice Cavallotti 16 - 20089, Rozzano - Milano - ITALY http://www.sonicle.com |
----------------------------------------------------------------------------------
Da: MaxxAtWork <[EMAIL PROTECTED]>
A: Gabriele Bulfon <[EMAIL PROTECTED]> bacula-users@lists.sourceforge.net
Data: 12 settembre 2006 9.54.28 CEST
Oggetto: Re: [Bacula-users] Bacula-dir and remote Postgres
On 9/12/06, MaxxAtWork <[EMAIL PROTECTED]> wrote:
> Sorry, I'm no expert in postgres but what I would do is:
> - check google results for that postgres error
> - sniff deeper the net and have a look at packet contents, first logging a
> successful connection (e.g. that one from psql) to see what it's expected to
> be there, and then logging the problematic connection from bacula, and
> comparing the two results.
> - raise debug level in postgres (is it possible?)
>
Additionally, from postgresql.c I see that you should get some debug
info on postgres operations from bacula daemon if you raise bacula
debug to 500.
--
Maxx
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users