Since there is no deadlock error until a deadlock exists, the error you reported is most likely the victim and not the culprit. Of course it could have caused it then the same page was hit again and reported the error.
I'd have to think this would be FAR easier to debug from the DB server. management console, profiler etc. These can be a real pain to track down to say the least. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Andrew Clarke [mailto:[email protected]] Sent: Wednesday, June 09, 2010 2:39 PM To: cf-talk Subject: Avoiding SQL deadlocks My understanding and experience is that a well-architected application should NEVER experience a SQL deadlock. If I am incorrect in this premise, please let me know. Based on that assumption, I'm trying to diagnose a client's deadlock problem. They are a new client. I have a copy of their code and a copy of the error, but don't have access to their SQL Server 2005 database. I'm told the database has no stored procedures, no functions, triggers, or external jobs running on it, but I suppose that information is wrong. They have 3 pages with <cftransaction> around some code. It appears that this is the code that's throwing this sort of error: "Error","jrpp-717","06/09/10","13:47:16","SomeSiteName","Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 187) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. The specific sequence of files included or processed is: C:\Inetpub\wwwroot\SomeSiteName\index.cfm, line: 270 " The error isn't actually in index.cfm but I can deduce what page it's on as the site isn't very large and there aren't many queries around line 270 of any pages. I tried setting the isolation level to "serializable", thinking that would bypass the deadlocks. However, they're still happening. If there's nothing else hitting the databases, and if the queries are simple inserts/updates, "should" there still be deadlocks? Thanks, - Andrew. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
