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
_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to