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

[Jim Abramson]

> Paul Browning wrote:
> 
> > I won't attempt to summarise the technical background because
> > I'm not privvy to the complete picture. Just to say that the
> > recent threads on zope-db at zope.org very much echo our experiences
> > (and in some cases _are_ our experience although relayed by
> > a third party - Chris W: feel free to say more!).
> 
> Well, there are three broad problem areas that I'm looking to fix:
> 
> - 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.

> - Zope hangs due to Oracle servers not responding. Something somewhere should be 
> timing out and it ain't currently ;-)
> 
> Who else is experiencing any or all of these problems?

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. I've had to do some major backflips to 
get around that one.

a more constructive gripe, though:
I didn't join this list until the era of new-zope-site, which sadly seems to have 
been the end of the dco2 tracker. When will it be revived? Seems like it would 
be as useful to the process of making improvements, as it would be to 'consumers' 
like me for finding or sharing workarounds to the problems that exist. (Of course, 
not to slight the helpfulness and vigor of the list community, but a list is neither
an ideal place to store testing/feedback/analyses, nor a fun place to search for it.)