What is the recommended way to recover from a db connection that is held by a Psycopgda adapter instance? If for some reason postgres goes down, I get the following error:
File "/var/lib/zope3/instances/instance.barry2007/lib/python/sqlos/adapter.py", line 83, in _runWithConnection val = meth(conn, *args) File "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/dbconnection.p ", line 351, in _queryOne self._executeRetry(conn, c, s) File "/var/lib/zope3/instances/instance.barry2007/lib/python/sqlos/adapter.py", line 77, in _executeRetry raise DatabaseException(str(exc.args)) DatabaseException: ('no connection to the server\n',). I then have no recourse but to restart the zope server. In the Java world one would put a try/catch around the the SQL operation and attempt a reconnect, but I am wondering if there is a better way (read: automatic recovery) in a z3 world. -- Thanks, Roy Mathew. _______________________________________________ Zope3-users mailing list Zope3-users@zope.org http://mail.zope.org/mailman/listinfo/zope3-users