Forum OpenACS Q&A: Re: OpenACS and Database Locks - Conflict?

Posted by Janine Ohmer on
I don't have much to offer as far as why your site is hanging, but I can confirm that one locked thread can cause the whole site to hang.

I just debugged a situation last night in one of the sites we host.  A thread was crashing during a transaction, and due to some custom error code (at least I think that was the reason) execution was never returning to the original script, so the transaction was being left open.  It didn't take long after this happened for other threads to start stacking up, needing to update a table that was being held hostage by that transaction, and very quickly everything ground to a screeching halt.