From: Brian Lloyd <Brian@digicool.com> The quick way to determine this: install a fresh Zope without SybaseDA installed and see if you can reproduce the kid-clicking behavior.
Another thing potentially to look at: there is problem with Sybase connections that I have run into before where if you have a request that runs a transactional query, then a non- transactional query, then trys another transactional query you get a hang :( I don't know if this could be the case here, but if so you might want to look here for more info:
Thank you very much! My preliminary test indicates that indeed the deadlock is coming from the Sybase database adapter. Zope alone seems to be doing fine (what a relief!), even under intense bombardment of http form requests. I'll have more about Sybase deadlocking later, as I try to isolate the problem. I think the problem is not only with transaction-non_transaction interaction. The problem happens even after I connect all the Zope threads to Sybase, and use transactions for all threads afterwards. regards, Hung Jung ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com