Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Daniele Varrazzo

Daniele Varrazzo

Account owner

Daniele Varrazzo's latest activity

Wednesday, September 19 2012
127 psycopg2 extension fails to compile with clang was updated in psycopg
  • Daniele Varrazzo
    • State changed from new to open
    by Daniele Varrazzo at 5:49 PM

    Provide a patch then. You are the clang user.
126 Possible bug in cursor iterator was updated in psycopg
  • Daniele Varrazzo
    • State changed from new to invalid
    by Daniele Varrazzo at 5:48 PM

    Talked with the guy: he was using the cursor for other queries too, clearing the internal state.
  • Daniele Varrazzo
    Daniele Varrazzo commented at 3:53 PM

    It is more likely that you are calling execute on one cursor and iterating on another one.
125 Pool broken for zope was updated in psycopg
  • Daniele Varrazzo
    Daniele Varrazzo commented at 2:01 PM

    Oh, I see. In PG the serializable and repeatable read used to be the same, since 9.0 iirc serializable became stronger and the previous semantics is available a...
Tuesday, September 18 2012
86 KeyError on psycopg2.extras.register_hstore() was updated in psycopg
  • Daniele Varrazzo
    • State changed from hold to resolved
    by Daniele Varrazzo at 8:03 PM

    This issue was fixed in my devel. To be released in 2.4.6.

    Duplicate of issue #114.
125 Pool broken for zope was updated in psycopg
  • Daniele Varrazzo
    Daniele Varrazzo commented at 5:25 PM

    Thank you for the analysis, Wolfgang.

    As you describe it, seems that most of the mess happens in ZPsycopgDA/db.py

    • inconsistent isolation level
    • resetting the cl...
  • Daniele Varrazzo
    Daniele Varrazzo commented at 12:32 PM

    An optional solution would be to replace entirely PersistentConnectionPool.putconn and not invoke _putconn, but it leads to some code duplication.

    For me, any s...
  • Daniele Varrazzo
    Daniele Varrazzo commented at 12:14 PM

    Attached proposed patch to fix the issue
  • Daniele Varrazzo
    Daniele Varrazzo created the ticket at 12:13 PM

    Apparently the connection pool rolling back connections in transaction (ticket #62) has broken the zope adapter (see ticket #123 and ML message http://archives....
123 ZPsycopgDA2 was updated in psycopg
  • Daniele Varrazzo
    Daniele Varrazzo commented at 12:16 PM

    Open ticket #125 to track the issue of the rollback with psycopg 2.4.5. Wolfgang, can you please test the patch attached? Thank you.