Is there any possibility that my client postgres native libraries have problems on Solaris 10?
I hardly believe this is a network problem, becuase I have the same happening on any installation where these machines become client to postgres on another server (or PC).
I may even have to equals Solaris 10 machines, one with Director and one with Postgres, and the problems comes out.
BUT the problem never comes out when using Postgres from any TomCat web app.
What I see is that TomCat web app use pure java libraries to work with the DB.
So, I have no other Solaris native application to test on Postgres ( a part from psql itself, that works).
AND: why all the first Director statements go through?!?!?
----------------------------------------------------------------------------------
Da: Magnus Hagander <[EMAIL PROTECTED]>
A: Dan Langille <[EMAIL PROTECTED]> Gabriele Bulfon <[EMAIL PROTECTED]>
Cc: bacula-users@lists.sourceforge.net
Data: 26 settembre 2006 15.56.15 CEST
Oggetto: RE: [Bacula-users] Postgres Log
I hardly believe this is a network problem, becuase I have the same happening on any installation where these machines become client to postgres on another server (or PC).
I may even have to equals Solaris 10 machines, one with Director and one with Postgres, and the problems comes out.
BUT the problem never comes out when using Postgres from any TomCat web app.
What I see is that TomCat web app use pure java libraries to work with the DB.
So, I have no other Solaris native application to test on Postgres ( a part from psql itself, that works).
AND: why all the first Director statements go through?!?!?
|
|
|
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: Magnus Hagander <[EMAIL PROTECTED]>
A: Dan Langille <[EMAIL PROTECTED]> Gabriele Bulfon <[EMAIL PROTECTED]>
Cc: bacula-users@lists.sourceforge.net
Data: 26 settembre 2006 15.56.15 CEST
Oggetto: RE: [Bacula-users] Postgres Log
> > 2006-09-26 14:06:51 LOG: database system is ready
> > 2006-09-26 14:06:51 LOG: transaction ID wrap limit is
> 2147484148, limited by database "postgres"
> > 2006-09-26 14:06:51 LOG: autovacuum: processing database
> "bacula"
>
> There, a vacuum begins. Bacula is not doing that.
Vaccum/autovacuum cannot possibly have anything to do with this.
Standard vacuum will never affect client commands. Even vacuum full will
never affect new connections.
> > 2006-09-26 14:07:23 LOG: connection received:
> host=192.168.222.254
> > port=42477
> > 2006-09-26 14:07:23 LOG: connection authorized: user=bacula
> > database=bacula
This is what a connection normally should look like.
> Here I ran bconsole and issued "list volumes"
> > 2006-09-26 14:07:29 LOG: connection received:
> host=192.168.222.254
> > port=42479
Ok, so here's a new connection coming in.
> > 2006-09-26 14:07:29 LOG: could not receive data from client:
> Impossibile stabilire la connessione. Rifiuto persistente del
> computer di destinazione.
And this means that the TCP connection went away for some reason. Since
the actual error code is in Italian (I think? Definitly not English at
least), I can't say much more than that. But it's the kernel that told
postgresql that the connection has been closed. So the problem is not in
the PostgreSQL server installation. It can be in the OS install there,
or it can be on the client, or on the network in between.
> > 2006-09-26 14:07:29 LOG: incomplete startup packet
That's just leftover from above - probably we never received a single
byte, because the startup packet would always fit in a single Ethernet
frame, IIRC.
It might also be worthwhile to run a network sniffer on the net to see
if there is any clue as to why the connection goes away.
//Magnus
------------------------------------------------------------------------- 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
