[Zope3-Users] recovering from a lost db connection

[Roy Mathew]

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.