The psycopg adapter does not reconnect if a postgresql database restarts for any reason. The autoreconnect feature was available in older versions in psycopg, but is no longer in current versions. See: http://mail.zope.org/pipermail/zope/2005-April/157990.html The patch they suggest seems to work fine, so i dont see why it shouldnt be incorporated in the ebuild Reproducible: Always Steps to Reproduce: 1. start the psycopg connection to database from zope 2. restart the database 3. test the connection by issuing an sql statement from testing window or by runing a zsql method. It will fail because the connection to the database is no longer active. Actual Results: connection to the db is no longer active Expected Results: the psycopg should attempt to reconnect to the database. http://mail.zope.org/pipermail/zope/2005-April/157990.html
a zope problem?
zpsycopgda has been updated in portage to 1.1.21 which should solve the problem (upstream reports that it was solved in 1.1.19). In case of problems please reopen the bug. Thank You for Your support and patience.
