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 )