Hi Cynthia,

Cynthia Kiser wrote:

When you do our own connection management, are you able to avoid
DCOracle2 leaking connections? In our Zope 2.6.1/DCOracle2-1.3b
server, we accumulate sessions where Oracle is waiting for a response
from Zope, but Zope apparently thinks it closed that connection and
opened a new one.

If you google for my name, Oracle and Zope you'll find lots of information on the problem ;-)
It's basically ZOracleDA's funny idea of connection pooling that causes the problem. Unless your ZSQL methods are hammered heavilly, you'll see plenty of unused oracle sessions. These aren't being leaked as you suggest, just not used very often. This results in "Oracle Not Connected" errors if your DBA sets a timeout on unused Oracle sessions...

Manually closing and reopening the connection does
not clean up the forgotten sessions, so I periodically (~monthly)
restart the Zope server to clean up.

Control Panel -> Database -> Main -> Flush Cache will have the same effect...

me with the impression that its connection closing function did not

It doesn't ;-)



Simplistix - Content Management, Zope & Python Consulting
           - http://www.simplistix.co.uk

Zope-DB mailing list

Reply via email to