Re: [cx-oracle-users] DRCP connections not being returned to the pool

[David S. <ds...@ds...>]

Thanks for the quick reply. In a previous test I had a 'del cur' and 'del
con' right before the sleep and it still wasn't working.  I'm wondering now
if it's possibly because of the test.

I am using 5.1.1.  I did download the code from the SF website, but the
only call to OCIServerDetach is in Connection_Free.  Should it also be in
Connection_Close?



On Thu, Mar 21, 2013 at 3:57 PM, Amaury Forgeot d'Arc <ama...@gm...>wrote:

> 2013/3/21 David Stanek <ds...@ds...>
>
>> We are seeing a strange issue where DRCP connections are not being
>> returned to the pool even after the connection is closed. My sample code (
>> http://pastebin.com/UB5cPtsZ) shows a really simple example where I
>> create more processes than I have connections in the pool. I expected the
>> connection to be available for reuse by the time the child process sleeps.
>> Then I would expect to see a stream of output and the processes would all
>> exit in about 10 seconds.
>>
>> What I'm actually seeing is every process making a connection, but the
>> queries for processes above the number of connections in the pool block
>> until some of the processes die. So every 10 seconds or so a few more
>> queries run.
>>
>> Does the process really need to die for the connection to be released?
>>
>
> It has been a while, but I remember that at some point con.close() would
> call OCISessionEnd but not OCIServerDetach.
> Only the object destructor would call OCIServerDetach.
> You could try a "del con" just before the sleep.
>
> Looking at the HISTORY, this was fixed in version 5.1.1.
> Are you using an older version?
>
> --
> Amaury Forgeot d'Arc
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>


-- 
David
blog: http://www.traceback.org
twitter: http://twitter.com/dstanek
www: http://dstanek.com