Might be a stupid question, but have you tried wrapping a cftransaction around your insert? Or even a cflock?
What version of CF are you using and are you using the standard macromedia DSN connectors, and not JDBC drivers? Have you also patched CF with the latest hotfixes, and macromedia JDBC drivers? All very long shots, but anything is worth a shot. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Wednesday, 13 June 2007 2:32 PM To: [email protected] Subject: [cfaussie] DEADLOCK - HELP! Hi All, Platform: MS SQL 2005 I have a simple SQL statement that simply logs a bit of data, nothing important at all. <cffunction access="public" name="doLog" output="false" returntype="void" hint="Logs all details in regards to the search performed"> <cfquery name="rsInsert" datasource="#application.system.Datasource.getName()#"> SET DEADLOCK_PRIORITY LOW; INSERT INTO tbl_search ( searchString , recordCount , internetProtocol , dateStamp ) VALUES ( <cfqueryparam value="#getSearchString()#" cfsqltype="CF_SQL_VARCHAR"> , 0 , <cfqueryparam value="#getInternetProtocol()#" cfsqltype="CF_SQL_VARCHAR"> , <cfqueryparam value="#createODBCDateTime( getDateStamp() )#" cfsqltype="CF_SQL_TIMESTAMP"> ); </cfquery> </cffunction> We are doing some load testing with the application, and it all seems to run fine except for the above statement, it produces DEADLOCKS. I could not really understand why, as there is ONLY an INSERT statement and the data is not read anywhere else. The only read I could think of was for the index on the table, I removed that, but am still getting deadlocks. Does anyone have any idea how to overcome this? thanks in advance. -- http://www.clickfind.com.au The new Australian search engine for businesses, products and services --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
