Re: Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3

On Tue, Sep 18, 2012 at 12:53 PM, Daniele Varrazzo
<daniele(dot)varrazzo(at)gmail(dot)com> wrote:
> On Fri, Aug 3, 2012 at 2:42 PM, Richard Harley <richard(at)scholarpack(dot)com> wrote:
>> We had the exact same problem with psycopg2/zope2.10/pg9 but could not find
>> a satisfactory solution.
>>
>> There are no problems with psycopg1 apart from it being old and unsupported
>> :)
>
> Sorry, I missed these messages. The problem is probably in the pool
> rolling back open transactions since psycopg 2.4.3.
>
> I need some help with testing this issue: ok for you to test some
> patch I will provide?

So, here it is. The patch attached assumes zope always uses
psycopg.pool.PersistentConnectionPool or its subclasses: is this the
case?

Can you please test:

1. what happens with regular pages that got broken as in the provided
case? Desired result is that everything works as expected.

2. what happens with pages making an error? Desired result is
eventually an error in the page but further pages generated correctly.

3. what happens if the database is restarted? Desired result is
eventually an error in the first page loaded but further pages
generated correctly (the pool should restore the connection).

Thank you very much.

-- Daniele