[Zope] RE:ZServer dying

Francisco Eduardo Webber webber@uptime.at
Wed, 28 Mar 2001 20:02:24 GMT


Hi folks,
like Sven & Philip
i have to report similar strange happenings on our server

Profile:
RH Linux 7.0 on a Compaq Alpha
1Gig Ram
Zope 2.3.0
Postgres 7.0.3
w_pcgi configuration with Zope.cgi and Apache=20
psycopg Postgres DA

we tried also PoPy as DA connector but still the same result ...
it seems to me, if all those cases are related, that RH7.0 and Postgres =

are used on all machines where this phenomen occurs.

we have on this server an average hitcount of 3000 hits per hour
so i suppose you can imagine that it is not really funny to restart a=20=

production server=20
every hour.

zope runs under 6 python threads ...
 7119 nobody     1   0 27848  27M  3440 S     0.2  1.3   0:12 python
 7124 nobody     0   0 27848  27M  3440 S     0.0  1.3   0:00 python
 7125 nobody    10   0 27848  27M  3440 S     5.2  1.3   0:34 python
 7126 nobody     0   0 27848  27M  3440 S     0.0  1.3   0:27 python
 7127 nobody     0   0 27848  27M  3440 S     0.0  1.3   0:34 python
 7128 nobody     0   0 27848  27M  3440 S     0.0  1.3   0:25 python
 7143 postgres   5   0  6200 6200  4240 S     2.9  0.3   3:01 postmaster=

 8455 postgres   0   0  5840 5840  4136 S     0.0  0.2   0:20 postmaster=

 7118 root       0   0  5056 5056  2216 S     0.0  0.2   0:00 python
 2511 apache     1   0  4344 4344  3896 S     0.0  0.2   0:00 httpd
 2998 apache     3   0  4344 4344  3896 S     0.0  0.2   0:00 httpd
 4755 apache     0   0  4344 4344  3896 S     0.0  0.2   0:00 httpd
 6600 apache     0   0  4344 4344  3896 S     0.0  0.2   0:00 httpd
 3573 apache     2   0  4336 4336  3896 S     0.0  0.2   0:00 httpd
 4327 apache     1   0  4336 4336  3896 S     0.0  0.2   0:00 httpd
 8726 apache     0   0  4336 4336  3896 S     0.0  0.2   0:00 httpd
 6231 apache     0   0  4320 4320  3880 S     0.0  0.2   0:00 httpd
 7414 apache     2   0  4320 4320  3880 S     0.0  0.2   0:00 httpd
 7780 apache     4   0  4320 4320  3880 S     0.0 ..................

the memory usage of the python threads grows slowly but constantly until=
=20
zope dies ....

has anyone a hint?
What would be the best method to locate the memory leak?

Thank you

Francisco Webber