Saga continues ([Zope-DB] DCOracle2: close connection doesn't)

[Chris Withers]

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 
> issue.

Try clearing the ZODB cache (see the Zope Control Panel). What effect does this 
have?

> 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?

cheers,

Chris