[Zope] ZServer *still* dying - help?

[Chris McDonough]

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