Which RedHat. RH9 has some known problems--see the archives for much discussion. On Wed, 22 Oct 2003, Jakub Wisniowski wrote:
Hi
I'm experiencing some problems with my Zope. It is Zope 2.6.0 sitting on RedHat and connected to Oracle DB via DCOracle. The problem is that sometimes Zope hangs.
There are tens of users in my app, and there are also some long lasting db queries, so I have total number of zope threads set to 15 and zodb cache poool size set to 25. But there is no rule (I can't find any rule) for hanging like heavy load or sth - it just happens.
This is pretty mysterious for me, because there is nothing in event log except a series of conflict errors, then:
2003-10-21T12:39:18 INFO(0) ZODB conflict error at addr (481 conflicts since startup at 2003-10-21T02:00:05) ------ 2003-10-21T12:39:24 INFO(0) ZODB conflict error at addr2 (482 conflicts since startup at 2003-10-21T02:00:05) ------ 2003-10-21T12:39:26 INFO(0) ZODB conflict error at addr3 (483 conflicts since startup at 2003-10-21T02:00:05) ------ <-- Zope hanging here 2003-10-21T12:56:34 INFO(0) Z2 Caught signal SIGTERM <-- restart here ------ 2003-10-21T12:56:34 INFO(0) Z2 Closing all open ZODB databases ------ 2003-10-21T12:56:34 INFO(0) Z2 Shutting down
and then system start informations.
In z2.log there is also a pause in requests - it looks like:
127.0.0.1 - Anonymous [21/Oct/2003:12:40:35 +0200] "GET /addr HTTP/1.1" 302 339 "" "Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)" 127.0.0.1 - Anonymous [21/Oct/2003:12:56:40 +0200] "GET /addr HTTP/1.1" 302 339 "" "Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)"
And most descriptive detailed log:
Start WIn WOut WEnd Tot S OSize Code Act URL 2003-10-21T12:39:42 0 1 0 1 E 21690 200 0 urls 2003-10-21T12:39:42 0 0 0 0 E 282 302 0 ... 2003-10-21T12:39:45 0 0 0 0 E 14318 200 0 ... 2003-10-21T12:39:46 0 2 0 2 E 58170 200 2 ... 2003-10-21T12:39:46 0 5 0 5 E 21743 200 4 2003-10-21T12:39:48 0 NA NA 0 I NA NA 152 urls 2003-10-21T12:39:50 0 1 0 1 E 13904 200 1 ... 2003-10-21T12:39:50 0 13 0 13 E 101528 200 9 ... 2003-10-21T12:39:50 0 13 0 13 E 101528 200 11 ... 2003-10-21T12:39:51 0 1 0 1 E 1790 200 1 ... 2003-10-21T12:39:52 0 0 0 0 E 26499 200 0 ... 2003-10-21T12:39:53 0 0 0 0 E 7728 302 0 2003-10-21T12:39:53 0 1 0 1 E 14049 302 0 2003-10-21T12:39:53 0 4 0 4 E 84388 200 2 2003-10-21T12:39:54 0 1 0 1 E 18137 200 0 2003-10-21T12:39:57 0 1 0 1 E 11716 200 1 urls 2003-10-21T12:39:58 0 1 0 1 E 18322 302 0 ... 2003-10-21T12:39:59 0 3 0 3 E 15407 200 0 ... 2003-10-21T12:40:03 0 1 0 1 E 26706 200 1 2003-10-21T12:40:04 0 NA NA 0 I NA NA 138 urls 2003-10-21T12:40:05 0 NA NA 0 I NA NA 137 ... 2003-10-21T12:40:05 0 1 0 1 E 8084 200 2 ... 2003-10-21T12:40:05 0 2 0 2 E 14568 302 2 ... 2003-10-21T12:40:06 0 NA NA 0 I NA NA 134 ... 2003-10-21T12:40:07 0 NA NA 0 I NA NA 133 ... 2003-10-21T12:40:08 0 NA NA 0 I NA NA 132 ... 2003-10-21T12:40:12 0 NA NA 0 I NA NA 131 ... 2003-10-21T12:40:14 0 NA NA 0 I NA NA 130 2003-10-21T12:40:18 0 NA NA 0 I NA NA 129 2003-10-21T12:40:32 0 NA NA 0 I NA NA 126 2003-10-21T12:40:32 0 NA NA 0 I NA NA 127 2003-10-21T12:40:32 0 NA NA 0 I NA NA 128 2003-10-21T12:40:34 0 1 0 1 E 339 302 0 2003-10-21T12:40:37 0 NA NA 0 I NA NA 124 2003-10-21T12:40:39 0 NA NA 0 I NA NA 123 2003-10-21T12:40:41 0 NA NA 0 I NA NA 122 2003-10-21T12:40:43 0 NA NA 0 I NA NA 121 2003-10-21T12:40:45 0 NA NA 0 I NA NA 119 2003-10-21T12:40:45 0 NA NA 0 I NA NA 120 ... ... ... 2003-10-21T12:55:25 0 NA NA 0 I NA NA 4 urls 2003-10-21T12:55:49 0 NA NA 0 I NA NA 3 ... 2003-10-21T12:55:52 0 NA NA 0 I NA NA 2 ... 2003-10-21T12:56:03 0 NA NA 0 I NA NA 1 ... 2003-10-21T12:56:09 0 NA NA 0 I NA NA 0 ... 2003-10-21T12:56:37 NA NA NA 0 U NA NA 0 System startup 2003-10-21T12:56:40 0 0 0 0 E 339 302 0 urls 2003-10-21T12:56:41 0 0 0 0 E 873 302 1 ... 2003-10-21T12:56:41 0 0 0 0 E 339 302 0 ... 2003-10-21T12:56:41 0 0 0 0 E 873 302 0 ... 2003-10-21T12:56:41 0 0 0 0 E 1672 500 0 ...
What can I read from these? Is any of these logs descriptive enough to say what is wrong with my Zope? How to do more investigation? I've got some more Zope instances that works perfectly stable in similar configuration but not with Oracle database, maybe this is a source of these hangs?
Thanks
-- Jakub Wisniowski
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )