db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From adkumar <a...@slb.com>
Subject Re: Possible Connection Leak
Date Thu, 03 Jul 2003 19:41:51 GMT
I do not see any SQL Exceptions thrown by my query.  And I do not see any
reason why it should happen on every 44th or 45th time. Not always.!!

I moved to jdbc24pool and it works fine.

You are right, some one should look at this and try to fix it.

Thanks,
Anil

Jenny Brown wrote:

>On Thu, 3 Jul 2003, adkumar wrote:
>
>  
>
>>Hi all,
>>
>>    I am testing Torques' old connection pool.
>>
>>    To test the connection I am running a query every minute. After 
>>every 45/46 minute, it looks like
>>    a new connection is made and even after connection time out, it is 
>>not released.
>>    
>>
>
>
>I would just like to add that I have also seen connection leaks
>during exception handling.  If an error occurs (SQL exception from
>a missing column or something), then Torque seems to leak that
>connection and not clean up after itself.  This happens no matter
>whether I create the connection and pass it to Torque, or whether
>I let Torque make its own connections.
>
>I don't have many details or confirmations but I have seen the
>behavior very regularly.  So, if someone is checking into pooling and
>connection cleanup, it may be useful to look into this too.
>
>
>Jenny Brown
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>  
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message