cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: postgres, idle in transaction
Date Tue, 24 Apr 2007 15:20:25 GMT
I just uploaded a patched 1.2 build with Cayenne connection pool  
rolling back transactions before returning them to the pool. Can you  
try it out (of course resetting DBCP data source back to Cayenne):

http://people.apache.org/~aadamchik/patched/cayenne-nodeps-1.2.3-dev.jar

I don't have too much hope this will fix it... but still worth a try.

Andrus


On Apr 24, 2007, at 5:28 PM, Oilid Adsi wrote:

>> -----Urspr√ľngliche Nachricht-----
>> Von: Andrus Adamchik [mailto:andrus@objectstyle.org]
>> Gesendet: Dienstag, 24. April 2007 16:21
>> An: user@cayenne.apache.org
>> Betreff: Re: 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?
>
> No, we are not using performIteratedQuery() with postgres.
>
> Is there another possibility to debug this problem or verify if  
> this is maybe a cayenne or jdbc-postgres bug?
>
> Oilid
>


Mime
View raw message