JustPaste.it

<deadlock>
<victim-list>
<victimProcess id="process1078623c28" />
</victim-list>
<process-list>
<process id="process1078623c28" taskpriority="0" logused="448" waitresource="KEY: 5:72057805478952960 (d6f43af7267f)" waittime="2583" ownerId="184815370" transactionname="trx" lasttranstarted="2019-09-25T10:52:29.097" XDES="0x4204a6d90" lockMode="U" schedulerid="9" kpid="8244" status="suspended" spid="346" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2019-09-25T10:52:29.093" lastbatchcompleted="2019-09-25T10:52:29.100" lastattention="1900-01-01T00:00:00.100" clientapp="ClientApp1" hostname="993769-SERVICE0" hostpid="17824" loginname="" isolationlevel="read committed (2)" xactid="184815370" currentdb="5" currentdbname="DBName" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="DBName.dbo.SP1" line="51" stmtstart="1964" stmtend="2628" sqlhandle="0x0300050006031d5850e8e700bfaa000001000000000000000000000000000000000000000000000000000000">
UPDATE Table1
SET LastUpdate = DATEADD(MINUTE, - 10, GETUTCDATE())
,Splited = 1
,Queued = 0
,STATUS = 10
WHERE IdTable1 = @IdTable1 </frame>
</executionStack>
<inputbuf>
Proc [Database Id = 5 Object Id = 1478296326] </inputbuf>
</process>
<process id="process2fb9468" taskpriority="0" logused="2720" waitresource="KEY: 5:72057806003372032 (5445e09747ee)" waittime="2583" ownerId="184815249" transactionname="user_transaction" lasttranstarted="2019-09-25T10:52:29.087" XDES="0x1204fd26d0" lockMode="U" schedulerid="4" kpid="11588" status="suspended" spid="342" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2019-09-25T10:52:29.083" lastbatchcompleted="2019-09-25T10:52:29.083" lastattention="1900-01-01T00:00:00.083" clientapp="ClientApp2" hostname="993770-SERVICE0" hostpid="60764" loginname="" isolationlevel="read committed (2)" xactid="184815249" currentdb="5" currentdbname="DBName" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="DBName.dbo.SP2" line="47" stmtstart="2940" stmtend="3144" sqlhandle="0x030005001d69f54c056968015ea7000001000000000000000000000000000000000000000000000000000000">
DELETE FROM dbo.Table2
WHERE IdTable1 = @IdTable1 </frame>
</executionStack>
<inputbuf>
Proc [Database Id = 5 Object Id = 1291151645] </inputbuf>
</process>
</process-list>
<resource-list>
<keylock hobtid="72057805478952960" dbid="5" objectname="DBName.dbo.Table1" indexname="PK_Table1" id="lock3f3915100" mode="X" associatedObjectId="72057805478952960">
<owner-list>
<owner id="process2fb9468" mode="X" />
</owner-list>
<waiter-list>
<waiter id="process1078623c28" mode="U" requestType="wait" />
</waiter-list>
</keylock>
<keylock hobtid="72057806003372032" dbid="5" objectname="DBName.dbo.Table2" indexname="IX_Table2_IdTable1_Sent" id="lock9b8dd2800" mode="X" associatedObjectId="72057806003372032">
<owner-list>
<owner id="process1078623c28" mode="X" />
</owner-list>
<waiter-list>
<waiter id="process2fb9468" mode="U" requestType="wait" />
</waiter-list>
</keylock>
</resource-list>
</deadlock>