Hi <br><br>We have two servers with Plone that point to the same database [Postgres 8] so that if one fails the other working. <br><br>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) <br>
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.<br><br>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<br>
<br>The solution restart plone or kill the process as follows<br><br>postgres 23267 0.0 0.1 2172016 7768 ? S 10:17 0:00 postgres: ploneadmin plonetesting 10.9.33.116(45189) idle in transaction<br>kill -15 23267<br>
<br><br>We have<br>2 Servers with Apache/Plone<br>Ram 4 Gigas<br>RedHat 5.4<br>Apache 2.2.3<br>Plone 3.3.4<br>RelStorage-1.4.0b3<br><br>1 Server with Postgres <br>Ram 4 Gigas<br>
RedHat 5.4<br>Postgres 8.1.18<br><br>Configuration.<br><br>-- Conexion DB<br> <relstorage><br> blob-dir var/blobs<br> <postgresql><br> dsn dbname='plone' user='admin' host='10.9.33.128' password='password123'<br>
</postgresql><br> </relstorage><br> <br>Recently modify these parameters in both servers and now it takes about 3 days to fail.<br><br> blob-dir var/blobs<br> cache-local-mb 512<br>
cache-prefix prod<br> cache-delta-size-limit 5000<br> commit-lock-timeout 10<br> poll-interval 60<br> pack-dry-run true<br> pack-batch-timeout 8<br> pack-duty-cycle 0.3<br>
pack-max-delay 30<br><br>We do not know if the problem is plone, postgres or network<br>I hope someone can advise something.<br><br>thanks in advance. <br>