cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: AW: postgres, idle in transaction
Date Tue, 24 Apr 2007 14:21:17 GMT

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

Mime
View raw message