[Zope] zope 'hangs' - queries only

Stephan Herschel stephan.herschel@proceryon.at
Fri, 14 Dec 2001 09:28:31 +0100


Dieter Maurer wrote:
> 
> Stephan Herschel writes:
>  > ...
>  > I created now a test function wich just sleeps for 30 seconds.
>  > While this is running i can still work with zope in another session, but
>  > only if pages are displayed which don't contain sql-queries!  All
>  > queries seem to wait until the sleep-job has ended!
>  >
>  > This seems very strange to me. Is this a problem of the DA? Or is it a
>  > problem of zope's threading mechanism? Please give me feedback.
> To me too...
> 
>   We know that the Interbase DA uses global locking, such that
>   two SQL queries cannot proceed in parallel (or interleaved).
> 
>   But a "sleep" and an SQL query should not be coupled.
> 
> Dieter

Some news on this one:
I tried the same scenario also with a mysql-DA with different results:
There was no problem issuing queries while the sleep-job was running.
So, i guess the problem is just with the thread-safety of the gvib-DA.
(I guess there are no workarounds available to solve this problem...)

Stephan