[Zope] Zope hangs hangs hangs...

Jim Kutter jim at ebizq.net
Wed Oct 22 15:39:50 EDT 2003


I had the same problems in RH9. After setting my threads to 1, and the
interval check timer to 22 (pystones/250), the problem seemed to go
away.

It's a dedicated development box, so it's not heavily taxed - you may
not be able to get away with the same settings I did...

-jim

-----Original Message-----
From: zope-bounces+jim=ebizq.net at zope.org
[mailto:zope-bounces+jim=ebizq.net at zope.org] On Behalf Of Jakub
Wisniowski
Sent: Wednesday, October 22, 2003 6:44 AM
To: zope at zope.org
Subject: [Zope] Zope hangs hangs hangs...


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 )



More information about the Zope mailing list