This is a locking problem in the database. Probably two different cfm pages are attempting to edit the same database records at the same time.
Troubleshooting deadlocks in SQL Server is a big subject. I'd start searching the SQL server Books online and go from there. Steve -----Original Message----- From: Matthew Reinbold [mailto:matthew.reinb...@voxpopdesign.com] Sent: Wednesday, September 23, 2009 12:00 PM To: cf-talk Subject: Database Deadlock with Multi-Server CF Config? Hello, This is less about getting a specific answer and more about just finding out how to diagnose the problem. Client has an ColdFusion application in a multi-server instance behind a hardware load balancer. The ColdFusion server are on separate machines but talk to the same MS-SQL db. Within the last few days users have started to see ColdFusion errors saying that: "[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 102) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." Any clues what this might be in regards to? How do I go about trying to track this down? And does this have anything to do with the multi-server setup or is it just a more vanilla problem with an update occurring slowly with the server? An insight would be much appreciated. Matthew Reinbold Creative Principal, Vox Pop Design, http://voxpopdesign.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
