These are a very small percentage of the cool stuff I saw last night at the SDCFUG meeting. If I have more time I'll post more...
Note: I am not a .NET developer, so please excuse any misuse of terminology and feel free to submit corrections in the comments.
Usually this is due to a unique situation involving load patterns or user behavior that Paperthin QA didn't catch, but telling you that that doesn't make you feel any better does it?
Today I got an email from someone having this very problem and I thought I would share my advice to him in case it comes in handy for someone else. Here's his question and my answer:
We are noticing an extreme number of lock errors in the CommonSpot code. "Error","jrpp-2","07/27/04","11:29:11","UDS_commonspot-users","A timeout occurred while attempting to lock appcommonspot-users. The specific sequence of files included or processed is: path/to/some/template.cfm This is happening very frequently and eventually causes our jrun process to either hang or go away. Random occurrences of each.
About your problem specifically, this is what I'd do:
Also, if you landed here looking for help with Commonspot, make sure you sign up for the Commonspot email list at chattyfig!