Re: [Bacula-users] Bacula and Postgres 8.1

Gabriele Bulfon Wed, 20 Sep 2006 05:37:33 -0700

Sorry for not resending the needed informations, I already sent them when I first encountered the problem. But then I could solve this by moving the Director together with the DB (I had another Solaris machine in that situation).

I'm appending the original infos here.
On postgres, I just find this debug, after getting the error from bconsole:

LOG: unexpected EOF on client connection

Hope you can help.
Gabriele.

==============================================================================

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

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: Bill Moran <[EMAIL PROTECTED]> A: Gabriele Bulfon <[EMAIL PROTECTED]> Cc: bacula-users@lists.sourceforge.net Data: 19 settembre 2006 14.53.29 CEST Oggetto: Re: [Bacula-users] Bacula and Postgres 8.1

In response to Gabriele Bulfon <[EMAIL PROTECTED]>: > Hello, > I open again the question about Bacula working on Postgres. > This time, I really need to have Director and Postgres run on two different machines. > The reason: I only have one Solaris machine and one Windows machine, so I cannot move the Director to the Windows machine together with Postgres (as far as I know, the Director is still not supported on Windows). > What happens is that once I add the needed entries to the bacula-dir.conf to connect to the new machine (DB Address and DB Port), Director starts (and with log enabled to 500, I can see a lot of queries correctly handled), but when I run bconsole on the Director, the Director initially responds with the prompt, then any command that needs DB access (such as "list volumes") hangs for some seconds and then fails saying that it cannot connect to the DB. > If I look at the log, I can see some timeout failures. > How can I investigate more this? Why the first queries go through correctly, and then they fail with bconsole? > Please help...I really need to move the DB on the other machine.... Help: 1) Provide the logs you captured, not your interpretation of them. Nobody is going to be able to diagnose "I can see some timeout failures" 2) Bump up connection logging on the PostgreSQL server. You'll want to provide those logs as well. 3) Put some effort into formatting your emails so they're readable. -- Bill Moran Collaborative Fusion Inc.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula and Postgres 8.1

Reply via email to