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 )
[Zope] Zope / DCOracle / ZOracleDA / Oracle 7.3.3 crash/respawn problem
Zopatistas! ;) 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. The Oracle database is rock solid, but I have been having a problem with Zope, one I need to fix. Basically, Zope is occasionally crashing when an SQL query is made. (with valid or invalid syntax.. it doesn't matter) This happens several times a day and makes the website unavailable for two or three minutes while Zope restarts. Obviously, this will not do for a production website. I have noticed that some other people have had this problem and posted to the list in the past. Please, if you know the solution to this..and have a moment, let me know what you did, or think I should do. Compilation tips, or a stable combination of ZOracleDA/DCOracle that I can use... Reliability is very important to this project. Thank you, Chris Beaumont [EMAIL PROTECTED] ___ 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 )