You’re offline. This is a read only version of the page.
Hi,
I am trying open transaction option in the Reconcile Bank Statements window.
During progress processing stops at a transaction entry.
Here is the error:
[Microsoft][ODBC SQL Server Driver][SQL server]Transaction
(Process ID 53) was deadlocked on thread I communication buffer
resources with another process and has been chosen as the
deadlock victim, Rerun the transaction.
Can you give me any ideas why this error persist?
Thanks for your help?
*This post is locked for comments
I have the same question (0)
Hello,
A deadlock usually occurs when two system server process IDs (SPIDs) are waiting for a resource and neither process can proceed because the other process is preventing it from getting the resource.
The lock manager’s thread checks for deadlocks. When a lock manager’s deadlock detection algorithm detects a deadlock, the lock manager chooses one of the SPIDs as a victim. The lock manager initiates a 1205 error message that is sent to the client, and the lock manager kills the SPID. Killing the SPID frees the resources and allows the other SPID to continue.
I would recommend taking a look at the following:
Detecting and Ending Deadlocks
technet.microsoft.com/.../ms178104(v=sql.105).aspx
The SQL Server support team forum may be able to give additional information as well.
Thank you,
Share
Report
All responses (
Answers (
