RESOLUTION: Re: [ZODB-Dev] more lockup information / zope2.9.6+zodb3.6.2

[Paul Williams]

It sounds like we have the same problem.  We had contracted Tres Seaver
write us a keepalive tool to ping the server periodically.  This has
fixed our problem and we haven't had a problem in 8 days.  We used to
have this problem at least once a day.

The biggest thing is that it is seen by some as a bug in Zope or Python
since we fixed it with a keepalive.  How do we definitively clear Zeo
infrastructure?  Is it somehow linked to python code not recognizing the
connection loss or is this strictly an iptables issue.  Is it a bug in
iptables or just a mis-configuration?

Thanks,
Paul Williams


-----Original Message-----
From: zodb-dev-bounces+pwilliams=diamonddata.com at zope.org
[mailto:zodb-dev-bounces+pwilliams=diamonddata.com at zope.org] On Behalf
Of Alan Runyan
Sent: Sunday, April 15, 2007 11:52 AM
To: Dieter Maurer
Cc: zodb-dev at zope.org
Subject: RESOLUTION: Re: [ZODB-Dev] more lockup information /
zope2.9.6+zodb3.6.2

Thanks to Jim, Theune, Dieter and all others who weighed in on this
thread.

The problem:  ZEO Clients would lock up randomly requiring restart.

The hints: Lots of 'Connection timed out' and 'No route to host' in
ZEO Server log files.

The solution: The machine the ZEO server was running iptables.  Even
though it was
allowing the zeo server port 8100; it was filtering on all interfaces.
 I simply changed rules so port 8100 would not filter the internal
network interface - at all.  ZEO listens specifically on internal
ip/port 8100.

System has been stable for several days; without zeo server logs
containing any connection errors.  I had never had this problem before
because.. well.. we use firewalls on our customers (external
interfaces and our internal interfaces never have filtering) and this
particular sysadmin was running iptables on all public/private
interfaces; locking the machine down as much as possible.

Thanks again guys!

-- 
Alan Runyan
Enfold Systems, Inc.
http://www.enfoldsystems.com/
phone: +1.713.942.2377x111
fax: +1.832.201.8856
_______________________________________________
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev at zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev