[Zope] ZServer *still* dying - help?

Mayers, Philip J p.mayers@ic.ac.uk
Thu, 5 Apr 2001 17:33:27 +0100


Sorry - yes, I'm still calling the SQL method, but am passing empty strings
for the named parameters instead. I'll try it without calling the method
now...

Regards,
Phil

+----------------------------------+
| Phil Mayers, Network Support     |
| Centre for Computing Services    |
| Imperial College                 |
+----------------------------------+  

-----Original Message-----
From: Chris McDonough [mailto:chrism@digicool.com]
Sent: 05 April 2001 17:32
To: Mayers, Philip J; zope@zope.org
Subject: Re: [Zope] ZServer *still* dying - help?


Can you clarify?  Are you still calling the SQL method?

----- Original Message -----
From: "Mayers, Philip J" <p.mayers@ic.ac.uk>
To: "'Chris McDonough'" <chrism@digicool.com>; "Mayers, Philip J"
<p.mayers@ic.ac.uk>; <zope@zope.org>
Sent: Thursday, April 05, 2001 12:30 PM
Subject: RE: [Zope] ZServer *still* dying - help?


> Yes.
>
> It's now crashing if I pass *any* named parameters. This can't be a
corrupt
> ZODB (I exported the site as XML, rebuilt the entire of Zope from fresh,
> then reinstalled and reimpored)
>
> Regards,
> Phil
>
> +----------------------------------+
> | Phil Mayers, Network Support     |
> | Centre for Computing Services    |
> | Imperial College                 |
> +----------------------------------+
>
> -----Original Message-----
> From: Chris McDonough [mailto:chrism@digicool.com]
> Sent: 05 April 2001 17:11
> To: Mayers, Philip J; zope@zope.org
> Subject: Re: [Zope] ZServer *still* dying - help?
>
>
> Does the problem happen without the SQL call?  E.g., can you just pass
> show_html >8 parameters of dummy data and have it crash?
>
> ----- Original Message -----
> From: "Mayers, Philip J" <p.mayers@ic.ac.uk>
> To: <zope@zope.org>
> Sent: Thursday, April 05, 2001 12:07 PM
> Subject: [Zope] ZServer *still* dying - help?
>
>
> > :o(
> >
> > The situation is this - I have a database-driven website that backs onto
a
> > Postgres 7.1RC1 server - this does not affect the problem, the same
thing
> > happens with a 7.0.3 and 7.0.2 server on either the same or different
> > machines.
> >
> > I have tried using PoPy/ZPoPyDA or psycopg/ZPsycopgDA - the same problem
> > occurs with both.
> >
> > I have been able to reproduct this on a minimal install of 2.3.1 (no
other
> > products).
> >
> > What's happening - I have a PythonScript that does this:
> >
> > m = container.machine.SQL_get(machineid=machineid)[0]
> > print container.machine.show_html(context,REQUEST,
> >                                   param1=m.param1,
> >                                   param2=m.param2,
> >                                   param3=m.param3,
> >                                   param4=m.param4,
> >                                   param5=m.param5,
> >                                   param6=m.param6,
> >                                   param7=m.param7,
> >                                   param8=m.param8,
> >                                   param9=m.param9,
> >                                   param0=m.param0)
> > return printed
> >
> > show_html is a DTML document. When called at "high" speed (2-3 times a
> > second) by URL traversal (i.e. GETing
> > http://site.name/Zope/path/pythonscript?machineid=whatever) this causes
> > either (in order of likelihood):
> >
> > 1) The 4 child threads of ZServer to die, leaving only the top-level and
> > child thread, and a core file
> > 2) *One* of the child threads to die, causing the rest of Zope to
> completely
> > hang (hung inside a SIGSTOP)
> > 3) The entire thing to bomb out
> >
> > *But*, if I reduce the number of named parameters to the DTML method
(when
> > of course it doesn't render properly) then everything's OK. The current
> code
> > dies if there are >8 named parameters. But it seems to vary. I thought
> that
> > the parameters had to be records from an SQL query, but now I'm not so
> sure.
> >
> > If anyone has any ideas, I'd be glad to hear them. Failing that, I'm
> giving
> > up :o)
> >
> > Regards,
> > Phil
> >
> > +----------------------------------+
> > | Phil Mayers, Network Support     |
> > | Centre for Computing Services    |
> > | Imperial College                 |
> > +----------------------------------+
> >
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
> >
>