We have two servers with Plone that point to the same database [Postgres 8]
so that if one fails the other working.
The problem is that at least once a day left to answer my Plone few minutes
(it is in white or takes a long to respond)
and cause apache send Proxy Error, this is solved but it is only annoying
for we users to wait 5 to 10 minutes not counting the lack of availability
of the page.
We find that when it fails, PostgreSQL maintains a connection and keeps a
long time as "in transaction" and after about 10 minutes this connection
automatically terminates. this causes plone fail,at least 10 minutes
The solution restart plone or kill the process as follows
postgres 23267 0.0 0.1 2172016 7768 ? S 10:17 0:00 postgres:
ploneadmin plonetesting 10.9.33.116(45189) idle in transaction
kill -15 23267
2 Servers with Apache/Plone
Ram 4 Gigas
1 Server with Postgres
Ram 4 Gigas
-- Conexion DB
dsn dbname='plone' user='admin' host='10.9.33.128'
Recently modify these parameters in both servers and now it takes about 3
days to fail.
We do not know if the problem is plone, postgres or network
I hope someone can advise something.
thanks in advance.
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org