Dario Lopez-Kästen wrote:
This leads to the situation that only 1 Zope-thread responds to requests. There is no difference in the queries executed by each thread.
Any advice in how to prevent threads from locking up is appreciated, as well as advice on how to find out why the threads lockup.
Hey Dario, for what it's worth I have a few changes in CVS which does add explicit close() operators to DCOracle2. This *probably* won't help your situation because Zope doesn't call close() on the DA connections. However, what might help you a lot more is to bump up the number of threads and ZODB connections. The -t option to Zope's z2.py will increase the number of threads, but you may find you need to increase the number of ZODB connections as well. The cheeseball way of increasing the number of ZODB threads is to edit lib/python/ZODB/DB.py and increase the pool_size parameter of the __init__ method of the DB class up from 7. The better way to do it is to provide your own custom_zodb.py file which opens its own DB object with a different number of threads.