Re: AW: postgres, idle in transaction

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Apr 24 2007 - 10:21:17 EDT

  • Next message: Oilid Adsi: "AW: AW: postgres, idle in transaction"

    On Apr 24, 2007, at 5:17 PM, Andrus Adamchik wrote:

    > Interesting... Looking at your log I see this:
    >
    > 15:33:08.267 (2) FE=> Parse(stmt=S_1,query="BEGIN",oids={})
    > .....
    > 15:33:08.268 (2) FE=> Parse(stmt=null,query="SELECT ....
    > ....
    > 15:33:28.461 (2) FE=> Parse(stmt=S_2,query="COMMIT",oids={})
    >
    >
    > So transaction is clearly committed. But of course connection is
    > not closed. It is returned to the pool instead. Still looks like a
    > driver bug to me.
    >
    > Andrus

    Sorry, you said "sometimes". Just noticed that the first case indeed
    doesn't commit. Just thought of another potential source of leaks -
    Cayenne iterated queries. Are you using any of those?

    http://cayenne.apache.org/doc/iterating-through-data-rows.html

    Andrus

    This archive was generated by hypermail 2.0.0 : Tue Apr 24 2007 - 10:21:51 EDT