[ZODB-Dev] plone and postgres "connection problems"
Laurence Rowe
l at lrowe.co.uk
Mon Apr 19 14:50:22 EDT 2010
I've had this issue reported to me in the context of zope.sqlalchemy,
but have been unable to reproduce it. Others have also seen it, but as
far as I am aware have not been able to reproduce it:
http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg146522.html
As there have now been three sightings, in the context of SQLAlchemy,
Django, and plain dbapi2 usage (RelStorage). I suspect it is a real
issue with Psycopg2, however until it can be reproduced I'm not
hopeful it can be fixed.
Laurence
On 19 April 2010 19:34, lista administracion <reference.list at gmail.com> wrote:
> Hi
>
> 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
>
>
> We have
> 2 Servers with Apache/Plone
> Ram 4 Gigas
> RedHat 5.4
> Apache 2.2.3
> Plone 3.3.4
> RelStorage-1.4.0b3
>
> 1 Server with Postgres
> Ram 4 Gigas
> RedHat 5.4
> Postgres 8.1.18
>
> Configuration.
>
> -- Conexion DB
> <relstorage>
> blob-dir var/blobs
> <postgresql>
> dsn dbname='plone' user='admin' host='10.9.33.128'
> password='password123'
> </postgresql>
> </relstorage>
>
> Recently modify these parameters in both servers and now it takes about 3
> days to fail.
>
> blob-dir var/blobs
> cache-local-mb 512
> cache-prefix prod
> cache-delta-size-limit 5000
> commit-lock-timeout 10
> poll-interval 60
> pack-dry-run true
> pack-batch-timeout 8
> pack-duty-cycle 0.3
> pack-max-delay 30
>
> 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:
> http://www.zope.org/Wikis/ZODB/
>
> ZODB-Dev mailing list - ZODB-Dev at zope.org
> https://mail.zope.org/mailman/listinfo/zodb-dev
>
>
More information about the ZODB-Dev
mailing list