[Zope-DB] Closing idle DCoracle2 Connections?

Dieter Maurer dieter at handshake.de
Fri Oct 21 13:55:55 EDT 2005


Cynthia Kiser wrote at 2005-10-20 19:09 -0700:
> ...
>I am pretty sure there is a bug in DCOracle2. If you can, try using
>DCOracle2 from the python prompt and close the connection. Now, can
>you still talk to the database? It seemed to me that I could when I
>tried that. 
>
>For my particular circumstance, this apparent leak in database
>connections is slow enough that I just restart my Zope application
>periodically. That clears the connections Oracle still thinks are
>open. FYI just closing the database connection via the ZMI does not
>release the idle connections Oracle still sees. 

It calls "close" on the connection -- but above, you tell us
that this does not really close...

And it can at most close its own connection (if this works),
there may be others in other ZODB caches (for different workers).
It is unable to reach them...


-- 
Dieter


More information about the Zope-DB mailing list