I occasionally see this error in an application I wrote.
Transaction (Process ID 54) was deadlocked on lock | communication buffer
resources with another process and has been chosen as the deadlock victim.
Rerun the transaction.
The code that is causing this is below.
<cfloop list="#variables.basicColorList#" index="i">
<cfquery datasource="#application.dsn#" name="deleteColor">
DELETE FROM #variables.table#
WHERE #variables.IDField# = #variables.ID# AND ColorName =
'#variables.i#'
</cfquery>
</cfloop>
Pretty simple query... How do I keep this SQL from deadlocking?
What is a deadlock? Two users hitting the code at the same time and database
cant handle all the requests?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:325768
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
