[Zope-dev] Curiously Zope Hanging

[Paul Zwarts]

I've had this problem as well, although I changed from ZPopPy to
psycopg0.99.4 which solved the problem. What I found in REdhat Linux 7.1,
where the ps -ef command now queries more info from its children, I finally
saw the status of my dbms threads. The Zope hanging maybe wasnt zope
directly. It still translated requests BUT I saw in ps -ef:

postgresql db01 UPDATE waiting.....

This is where the hang is. Several emails from Dieter just confused me more.
Something about Zope not having imlicit commits on transactions, so you had
to make sure a <dtml-call transaction().commit()> was placed somehwere. This
seemed to solve some problems at the time for me although I got alot of :

Warning: COMMIT, No transacion in progress


Hope I confused you a bit more. Maybe we can get somewhere eventaully ;_)

Paz



-----Original Message-----
From: zope-dev-admin@zope.org [mailto:zope-dev-admin@zope.org]On Behalf
Of Andre Schubert
Sent: Thursday, July 12, 2001 2:48 PM
To: steve@spvi.com
Cc: zope
Subject: Re: [Zope-dev] Curiously Zope Hanging


Hi Steve,

Immunix Redhat 6.2
Zope 2.3.3
Postgres 7.1.2

I'am running Zope with -M -D and with Stupid_log_file. But i don't find a
problem.
When Zope hangs, then there is one Thread Running and if i trace this Thread
nothing
happens.

as

Steve Spicklemire schrieb:

> Hi Andre,
>
>         What OS? I've had lots of trouble with Postgres and threads on
FreeBSD. Have
> you tried starting Zope with '-D' to see if threads are an issue?
>
> -steve
>
> Andre Schubert wrote:
> >
> > Hi all,
> >
> > I have a problem with my Zope, he hangs unexpectly if i view a special
> > Method which generates Diagrams with data from a PostgresDB.
> > The data are selected by a timespan( default is 24 Hours ).
> > The Method works as descripted bellow:
> >
> > First when i call foo, then the HTML-Code is rendered with some
> > images-tags, which are generated by selects.
> > The image tags are calling the method foo which returns image data.
> >
> > If i want my diagrams from 2001-06-01 5:00 to 2001-06-01 12:05
> > everything works fine.
> > If i want my diagrams from 2001-06-01 5:00 to 2001-06-01 12:10 Zope
> > hangs, no exception no log entry, Zope only hangs.
> > If i want my diagrams from 2001-06-01 5:05 to 2001-06-01 12:10 which is
> > the same timespan as example 1 Zope hangs too, no exception no log
> > entry, Zope only hangs.
> >
> > If i view the postgres logs the nothing happens.
> >
> > Could anyone help me to find the problem or the place Zope is hanging
> >
> > thanks as
> >
> > P.S.: Exact the same problem occurs when i you another PostgresDA ????
> >
> > _______________________________________________
> > Zope-Dev maillist  -  Zope-Dev@zope.org
> > http://lists.zope.org/mailman/listinfo/zope-dev
> > **  No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope )
>
> _______________________________________________
> Zope-Dev maillist  -  Zope-Dev@zope.org
> http://lists.zope.org/mailman/listinfo/zope-dev
> **  No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope )


_______________________________________________
Zope-Dev maillist  -  Zope-Dev@zope.org
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )