[ZODB-Dev] plone and postgres "connection problems"

[Laurence Rowe]

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
>
>