Stephan Richter wrote:
Hello everyone,
This is a help message to every mailing list, I think this issue could be related to. We are in production and 5000 flyers (45000 follow) were sent out and the site keeps giving problems.
I use: Zope 2.1.4, PyGres 2.x, Apache, and PostGres 7.0RC1
The issue: It seems like that whenever "many" (10, I know that is not much) people sign up at the same time on our Web Site (http://www.plandepot.com), we loose the DB connection. The connection is simple restored, when disconnecting and the reconnecting the database.
And that's exactly how we quick-fixed it :) def getUser(self, name): """Return the named user object or None if no such user exists""" try: # koos elluäratamisega try: ob=self.sqlUserQuery(username=name) except: conn = getattr(self,self.conn_id) conn.connect(conn.connection_string) ob=self.sqlUserQuery(username=name) except: return None if not ob: return None ob=ob[0] return User(sqlattr(ob, 'username'), sqlattr(ob, 'password'), sqlattr(ob, 'roles'), sqlattr(ob, 'domains')) It does not find or solve the original problem, but at least it revives it automatically -------------- Hannu