[Zope-dev] Curiously Zope Hanging

[Steve Spicklemire]

Well, the good news is you have a reproducable symptom! 

Some suggestions:

1) Try the quer(y/ies) that cause the hang separately to make sure they return OK.

2) Create a Python script/Tiny table/Gadfly query that returns data that looks
just like the result of your postgresql query to test the rest of your system.
(these two just isolate the problem to postgres or Zope)

3) Get out the debugger and step through the publisher to see where it's
hanging.. (in -D mode you can also 'print' in python and the results will appear
on stdout of the 'start -D' process.

4) Post some real code so we can see what you're really up to (!?)

-steve

Andre Schubert wrote:
> 
> 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 )