Re: [Zope] Zope / DCOracle / ZOracleDA / Oracle 7.3.3 crash/respawn problem
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 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope / DCOracle / ZOracleDA / Oracle 7.3.3 crash/respawn problem
Dieter, thank you. 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? It doesn't seem to happen when a database access isn't involved. Back to the drawing board.. Thank you for your help, though.. Chris [EMAIL PROTECTED] Dieter Maurer wrote: > > Chris Beaumont writes: > > I am using the most recent versions of (Linux) DCOracle and ZOracleDA to > > connect my Zope (2.1.6) installation to a copy of Oracle 7.3.3 running > > on another (Solaris) machine > > > > Basically, Zope is occasionally crashing when an SQL query is made. > > > > Compilation tips, or a stable combination of ZOracleDA/DCOracle that I > > can use... > You may try to compile DCOracle without the "-DCOracle8" (or similar) > option. > > Our problems disappeared after we did this (even though, we > connected to Oracle 8.1.6). > > Dieter > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope / DCOracle / ZOracleDA / Oracle 7.3.3 crash/respawn problem
Chris Beaumont writes: > I am using the most recent versions of (Linux) DCOracle and ZOracleDA to > connect my Zope (2.1.6) installation to a copy of Oracle 7.3.3 running > on another (Solaris) machine > > Basically, Zope is occasionally crashing when an SQL query is made. > > Compilation tips, or a stable combination of ZOracleDA/DCOracle that I > can use... You may try to compile DCOracle without the "-DCOracle8" (or similar) option. Our problems disappeared after we did this (even though, we connected to Oracle 8.1.6). Dieter ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )