[Zope-dev] DCO2 blocking/thread problem

[Matthew T. Kromer]

Rasmus Bording wrote:

>hey!
>
>Our Zope application "blocks" when it uses the DCO2 connection
>to our Oracle database. I.e. Zope wont handle other requests until
>the Oracle query has finished. Anyone got a clue why? 
>
>We are using DCO2 beta5 and Zope-2.3.0 on Linux.
>
>Thanks.
>Rasmus Bording
>
Hi,

That's interesting -- It shouldn't block, but that doesn't mean it 
isn't, obviously.
You are running Zope with more than one thread, I'm sure.  Each 
long-running operation in DCOracle2 will yield the global interpreter 
lock to allow other threads to run, so it could be that something else 
is causing the blockage.

Do you have a simplified example you can use to demonstrate this?  I may 
try to reproduce it with an enormous join, I don't have much experience 
at making Oracle run *slowly* ;)