文章摘要
这篇文章描述了一个SQL事务中的死锁情况。两个进程（Process2d69c9748c8和Process2d6ae694ca8）分别执行了不同的事务操作：
- 过程2d69c9748c8更新了员工信息，并等待了10秒，随后尝试更新订单信息。
- 过程2d6ae694ca8更新了订单信息，并等待了10秒，随后尝试更新员工信息。
两个进程都设置了相同的等待模式，并试图执行互斥操作，导致它们卡在等待阶段，无法继续执行。
文章还列出了相关的锁和资源信息，并提到了如何解决死锁问题，例如增加解锁超时或重新排列事务顺序。
<deadlock-list>
<deadlock victim=”process2d69c9748c8″>
<process-list>
<process id=”process2d69c9748c8″ taskpriority=”0″ logused=”324″ waitresource=”KEY: 7:72057594043170816 (8194443284a0)” waittime=”1304″ ownerId=”70740″ transactionname=”user_transaction” lasttranstarted=”2023-02-19T22:11:26.413″ XDES=”0x2d6a0200428″ lockMode=”S” schedulerid=”5″ kpid=”13816″ status=”suspended” spid=”66″ sbid=”0″ ecid=”0″ priority=”0″ trancount=”1″ lastbatchstarted=”2023-02-19T22:11:26.413″ lastbatchcompleted=”2023-02-19T22:11:26.410″ lastattention=”1900-01-01T00:00:00.410″ clientapp=”Microsoft SQL Server Management Studio – Query” hostname=”DESKTOP-STS8TPB” hostpid=”1696″ loginname=”DESKTOP-STS8TPB\Administrator” isolationlevel=”read committed (2)” xactid=”70740″ currentdb=”7″ currentdbname=”Northwind” lockTimeout=”4294967295″ clientoption1=”671090784″ clientoption2=”390200″>
<executionStack>
<frame procname=”adhoc” line=”5″ stmtstart=”24″ stmtend=”128″ sqlhandle=”0x020000007383d935b349bc173c0f104de14945e9a526322b0000000000000000000000000000000000000000″>
unknown </frame>
<frame procname=”adhoc” line=”5″ stmtstart=”204″ stmtend=”294″ sqlhandle=”0x020000002c3b203105961d63d10b17e54ed6ac081105f9450000000000000000000000000000000000000000″>
unknown </frame>
</executionStack>
<inputbuf>
BEGIN TRAN
UPDATE dbo.Orders SET ShipAddress=’上海’ WHERE OrderID=10258
WAITFOR DELAY ’00:00:10′
SELECT * FROM dbo.Employees WHERE EmployeeID=1;
ROLLBACK
</inputbuf>
</process>
<process id=”process2d6ae694ca8″ taskpriority=”0″ logused=”368″ waitresource=”KEY: 7:72057594044088320 (59ce0997f9b8)” waittime=”3468″ ownerId=”70716″ transactionname=”user_transaction” lasttranstarted=”2023-02-19T22:11:24.247″ XDES=”0x2d6a7284428″ lockMode=”S” schedulerid=”9″ kpid=”7124″ status=”suspended” spid=”65″ sbid=”0″ ecid=”0″ priority=”0″ trancount=”1″ lastbatchstarted=”2023-02-19T22:11:24.247″ lastbatchcompleted=”2023-02-19T22:11:24.247″ lastattention=”1900-01-01T00:00:00.247″ clientapp=”Microsoft SQL Server Management Studio – Query” hostname=”DESKTOP-STS8TPB” hostpid=”1696″ loginname=”DESKTOP-STS8TPB\Administrator” isolationlevel=”read committed (2)” xactid=”70716″ currentdb=”7″ currentdbname=”Northwind” lockTimeout=”4294967295″ clientoption1=”671090784″ clientoption2=”390200″>
<executionStack>
<frame procname=”adhoc” line=”5″ stmtstart=”26″ stmtend=”118″ sqlhandle=”0x02000000dd7720067e0519b8a368501716c04b4b50cfe6be0000000000000000000000000000000000000000″>
unknown </frame>
<frame procname=”adhoc” line=”5″ stmtstart=”196″ stmtend=”282″ sqlhandle=”0x0200000093f01512208755a056f5f28930fbd3dedf58a2850000000000000000000000000000000000000000″>
unknown </frame>
</executionStack>
<inputbuf>
BEGIN TRAN
UPDATE dbo.Employees SET Title=’Dr.’ WHERE EmployeeID=1;
WAITFOR DELAY ’00:00:10′
SELECT * FROM dbo.Orders WHERE OrderID=10258
ROLLBACK
</inputbuf>
</process>
</process-list>
<resource-list>
<keylock hobtid=”72057594043170816″ dbid=”7″ objectname=”Northwind.dbo.Employees” indexname=”PK_Employees” id=”lock2d69ccbbb80″ mode=”X” associatedObjectId=”72057594043170816″>
<owner-list>
<owner id=”process2d6ae694ca8″ mode=”X”/>
</owner-list>
<waiter-list>
<waiter id=”process2d69c9748c8″ mode=”S” requestType=”wait”/>
</waiter-list>
</keylock>
<keylock hobtid=”72057594044088320″ dbid=”7″ objectname=”Northwind.dbo.Orders” indexname=”PK_Orders” id=”lock2d69ccbbf80″ mode=”X” associatedObjectId=”72057594044088320″>
<owner-list>
<owner id=”process2d69c9748c8″ mode=”X”/>
</owner-list>
<waiter-list>
<waiter id=”process2d6ae694ca8″ mode=”S” requestType=”wait”/>
</waiter-list>
</keylock>
</resource-list>
</deadlock>
</deadlock-list>