Francisco Eduardo Webber wrote:
Hi folks, like Sven & Philip i have to report similar strange happenings on our server
Profile: RH Linux 7.0 on a Compaq Alpha 1Gig Ram Zope 2.3.0 Postgres 7.0.3 w_pcgi configuration with Zope.cgi and Apache psycopg Postgres DA
My Profile: SuSE Linux 6.3 256MB Ram Zope 2.3.1b1 Postgres 7.0.2 ZServer psycopg,ZPyGreSQLDA After a long psycopg install session last night I give up in frustration and switch back to ZPyGreSQLDA. Directly after installing psycopg the DA seems to work. I did some performance tests. If the connection is already established psycopg is not faster then ZPyGreSQLDA. But there is the same issue with ZSQLMethod's 'Maximum rows to retrieve' property. IMHO this prop is simply useless because you get a definitely wrong result if you have more rows in your db then configured on the DA. I can't see the benefit of a fast but wrong query result ... ZPyGreSQLDA simply ignores this prop ;-) How ever ... after restarting the server I was in trouble. ZServer died on the first query I made on psycopg. I started postmaster on debug level 3 but could not figure out the problem :( On psql I could do queries with no problem. But both psycopg AND ZPyGreSQLDA did not work. After uninstalling psycopg and restarting Zope ZPyGreSQLDA works fine.
we tried also PoPy as DA connector but still the same result ... it seems to me, if all those cases are related, that RH7.0 and Postgres are used on all machines where this phenomen occurs.
Both psycopg and PoPy seems to have a problem on initialisation.
we have on this server an average hitcount of 3000 hits per hour so i suppose you can imagine that it is not really funny to restart a production server every hour.
I saw the discussion on this list about the various postgres DA's but we have ZPyGreSQLDA on a intranet ERP system for more than one year with no problems.
has anyone a hint? To use ZPyGreSQLDA on Zope 2.3 you have to patch addConnectionForm method in DA.py
addConnectionForm=HTMLFile('Shared/DC/ZRDB/dtml/connectionAdd',defau.... ^^^^ -- _______________________________________________________________________ Andreas Heckel andreas@easyleading.org LINUX is like a wigwam...no gates...no windows and an apache inside ;-)