102703 2005-08-16 05:24 0000 Psycopg adapter for zope does not auto-reconnect 2005-12-11 11:38:53 0000 1 1 1 Unclassified Gentoo Linux Ebuilds unspecified All Linux RESOLVED FIXED P2 normal --- 1 paul@linx.net net-zope@gentoo.org jsaker@americanrelay.com python@gentoo.org paul@linx.net 2005-08-16 05:24:09 0000 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 liquidx@gentoo.org 2005-11-05 06:43:31 0000 a zope problem? radek@gentoo.org 2005-12-11 11:38:53 0000 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.