[Zope] Problem with Z Psycopg

[Barry Pederson]

Dieter Maurer wrote:
> Jason Leach wrote at 2005-4-4 15:15 -0700:
> 
>>I'm having a problem with Z Psycopg.  From time to time (quite often)
>>it looses the connection with the database and I get:
>>  Site Error
>>  An error was encountered while publishing this resource.
>>  Error Type: OperationalError
>>  Error Value: no connection to the server
> 
> 
> Usually, this means that the postgres server process died...

I checked my pgsql logs, and it seemed like the zope connection was dying first,
and then later on pgsql showed an unexpected EOF.  So I don't think it's the
postgres server dying first.


>>Then I have to login then close and open the connection.  It then
>>works for a while before bailing again.
> 
> 
> I do not have to do this because "ZPsycopgDA" automatically
> reconnects when an "OperationalError" is raised.
> Thus, this is strange.

Like I mentioned in another post - it looks like that feature was removed in the
ZpsycopgDA that comes with psycopg 1.1.11 or 1.1.12  I've tried patching the
auto-reconnect back in, and so far so good.  Looks like a couple connections
recently died, but the site is still going OK.

	Barry