From: | Stephan Richter <srichter(at)cbu(dot)edu> |
---|---|
To: | zope(at)zope(dot)org, pygresql(at)vex(dot)net, pgsql-general(at)postgresql(dot)org |
Subject: | PyGres DB Connection in Zope drops when many Users are added (UserDB) |
Date: | 2000-04-25 06:19:25 |
Message-ID: | 4.3.1.0.20000425004338.00a997a0@mail.cbu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Unfortunately I was unable to reproduce the error outside of business
hours, so I had never the chance to inspect the issue in detail. I
personally do not think it is PostGreSQL or Zope, since I would have read
more about it.
I have to mention, that PyGres is not thread safe and by default Zope uses
more than one thread if required. So could that be the issue? How do I
setup Zope in a way, that it uses only one thread? Also, I do not use any
of the caching features in Zope SQL Methods either.
Any ideas are appriciated.
THANK YOU ALL IN ADVANCE!!!
Regards,
Stephan
--
Stephan Richter - (901) 573-3308 - srichter(at)cbu(dot)edu
CBU - Physics & Chemistry; Framework Web - Web Design & Development
PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2000-04-25 07:56:52 | Re: Revisited: Transactions, insert unique. |
Previous Message | Manuel Lemos | 2000-04-25 05:31:00 | Re: Connecting website with SQL-database..... |