Mailing List Archive

On 2006-06-07 at 16:17:13 [+0200], Davis Mr MR <m.r.davis@cranfield.ac.uk>
wrote:
> Hi,
>
> My connection to Postgres keeps failing every couple of hours. I did
> read that there was a problem with some versions of this. I'm using
> 2.0b6 at the moment.
>
> Does anyone have a version number that I can try that will re-establish
> a connection on failure.

Michael,

if you look at the DA (db.py) source you will see that it actually tries to
reconnect if no connection is available so the problem must be somewhere
else. PostgreSQL connections themselves don't timeout but if the database
is on a network and the connection is dropped then the DA may well think it
is connected when it isn't. This is difficult to solve in the DA and you
need to know why the connection is being dropped first.

Charlie
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Hi Charlie,

I was afriad of that. Looks like the firewall is killing it, and it is
not telling the DA.

Will need to speak to our network people.

Thanks for your help.
Cheers
Michael

-----Original Message-----
From: Charlie Clark [mailto:charlie@egenix.com]
Sent: 07 June 2006 15:53
To: Davis Mr MR
Cc: zope-db@zope.org
Subject: Re: [Zope-DB] ZPsycopgDA connection failing


On 2006-06-07 at 16:17:13 [+0200], Davis Mr MR
<m.r.davis@cranfield.ac.uk>
wrote:
> Hi,
>
> My connection to Postgres keeps failing every couple of hours. I did
> read that there was a problem with some versions of this. I'm using
> 2.0b6 at the moment.
>
> Does anyone have a version number that I can try that will
> re-establish a connection on failure.

Michael,

if you look at the DA (db.py) source you will see that it actually tries
to reconnect if no connection is available so the problem must be
somewhere else. PostgreSQL connections themselves don't timeout but if
the database is on a network and the connection is dropped then the DA
may well think it is connected when it isn't. This is difficult to solve
in the DA and you need to know why the connection is being dropped
first.

Charlie

--
This message has been scanned for viruses and
dangerous content by the Cranfield MailScanner, and is
believed to be clean.

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db