[Zope] RE:ZServer dying

[Andreas Heckel]

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