Bug 102703 - Psycopg adapter for zope does not auto-reconnect
Bug#: 102703 Product:  Gentoo Linux Version: unspecified Platform: All
OS/Version: Linux Status: RESOLVED Severity: normal Priority: P2
Resolution: FIXED Assigned To: net-zope@gentoo.org Reported By: paul@linx.net
Component: Ebuilds
URL: 
Summary: Psycopg adapter for zope does not auto-reconnect
Keywords:  
Status Whiteboard: 
Opened: 2005-08-16 05:24 0000
Description:   Opened: 2005-08-16 05:24 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

------- Comment #1 From Alastair Tse (RETIRED) 2005-11-05 06:43:31 0000 ------- 
a zope problem?

------- Comment #2 From Radoslaw Stachowiak 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.