sql deadlock

2009-08-27 Thread Chad Gray
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

Re: sql deadlock

2009-08-27 Thread John M Bliss
http://en.wikipedia.org/wiki/Deadlock On Thu, Aug 27, 2009 at 8:46 AM, Chad Gray cg...@careyweb.com wrote: 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

RE: sql deadlock

2009-08-27 Thread brad
, a connection can probably rack up a lot of row locks that wants to escalate to a full table lock, but can't. If you are on SQL server, you might try wrapping a transaction around your loop and playing with the tablockx or holdlock locking hints. ~Brad Original Message Subject: sql

Re: CF8 SQL Deadlock

2009-05-29 Thread Jochem van Dieten
On Thu, May 28, 2009 at 2:18 PM, Andy Gillette wrote: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 87) was deadlocked While looking in the FusionReactor logs, I am noticing that this seems to be only happening when the Finished

CF8 SQL Deadlock

2009-05-28 Thread Andy Gillette
Hello, I have read just about everything I can (searched just about all forums, adobe, etc) and can't find an answer. We are running CF 8 Standard and FusionReactor 3 and have a heavy load application running but we are starting to get SQL deadlocks. Error Executing Database Query.

Re: CF8 SQL Deadlock

2009-05-28 Thread Andy Gillette
Hello, I have read just about everything I can (searched just about all forums, adobe, etc) and can't find an answer. We are running CF 8 Standard and FusionReactor 3 and have a heavy load application running but we are starting to get SQL deadlocks. Error Executing Database Query.

SQL Deadlock

2004-10-20 Thread Ryan Duckworth
Does anyone have any ideas on how to prevent/handle database deadlock? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the

Re: SQL Deadlock

2004-10-20 Thread Lawrence Ng
how are u writing the queries? via stored procedures? or cfquery? I'm assuming you're already cflock correct? ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.

RE: SQL Deadlock

2004-10-20 Thread Robertson-Ravo, Neil (RX)
Subject: SQL Deadlock Does anyone have any ideas on how to prevent/handle database deadlock? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun

Re: SQL Deadlock

2004-10-20 Thread G
Duckworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 11:01 AM Subject: SQL Deadlock Does anyone have any ideas on how to prevent/handle database deadlock? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID

Re: SQL Deadlock

2004-10-20 Thread Umer Farooq
Deadlocks are hard to trouble shoot.. don't overly use cftransaction with select... i.e espcially.. when doing Select MAX(ID) instead use.. following in the insert.. SELECT @@IDENTITY AS whateverFiledName; set nocount off cfset newId = insertNewId.whateverFiledName also for updates