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
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
, 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
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
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.
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.
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
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.
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
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
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
11 matches
Mail list logo