[Zope] Zope / DCOracle / ZOracleDA / Oracle 7.3.3 crash/respawn problem

[Dieter Maurer]

Chris Beaumont writes:
 > Unfortunately, if what you meant was to remove the -DDCOracle8 flag from
 > the end of my Setup file and recompile, that didn't do it. 
 > Zope is still crashing and restarting on perhaps one out of every 100
 > requests.
 > It seems to be more common when it hasn't been accessed in awhile, do
 > you think it could be some kind of cache issue?
I did mean -DDCOracle8 indeed.

Are you sure, that your "_oci.c" has indeed been recompiled
after your change?.
Usually changes in "setup" or "Makefile" do not lead
automatically to a recompilation.

Our problem was a memory corruption in the Oracle "logoff"
function (it has a different name, but is called during
connection close).
During each "close connection", this function released
a block of memory that was still being used.
After several such actions the system became very
unstable: most of the time SIGSEGV (at different places,
however, with peeks in the memory managegment functions)
but sometimes infinite loops, too.

Zope closes the connection, when the DA is evicted from
the cache. Therefore, the problem might well be correlated
with the DA objects not been used for a while.



Dieter