Saga continues ([Zope-DB] DCOracle2: close connection doesn't)
chrisw at simplistix.co.uk
Wed Oct 22 17:59:18 EDT 2003
Jim Abramson wrote:
>>- leaking of Oracle connections/sockets. This seems to be fixed by emptying the
>>ZODB cache, which feels a lot like a Zope/ZOracleDA/DCOracle2 bug to me.
>>- inability to reconnect when the server goes away under certain circumstances.
>>The ORA-01012: not logged in and ORA-03114: not connected to ORACLE errors.
>>IIRC, Matt K said there was code that should re-connect in circumstances such as
>>there. It doesn't appear to be currently working...
> I've definitely seen both of these, increasingly as of late (just as my apps are
> getting increasing traffic). I've been kicking zope, or wiggling the connection
> objects, to make things right again. I don't expect that approach to scale much
> further...and my DBAs are already bugging me about the connection-proliferation
Try clearing the ZODB cache (see the Zope Control Panel). What effect does this
> If this is a general gripe session, I'd bring up the painful problem of not being
> able to pass a date to a dco2 sp in zope.
A dco2 what?
> I've had to do some major backflips to
> get around that one.
What do they look like?
More information about the Zope-DB