[Zope] Zope hangs hangs hangs...

Wed Oct 22 15:26:53 EDT 2003

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 at 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 )
> 