Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock-list>
- <deadlock victim="process19868c55088">
- <process-list>
- <process id="process19868c55088" taskpriority="0" logused="0" waitresource="OBJECT: 6:1205579333:0 " waittime="1950" ownerId="453441" transactionname="user_transaction" lasttranstarted="2021-05-19T22:05:49.293" XDES="0x19873ecc408" lockMode="IX" schedulerid="5" kpid="11912" status="suspended" spid="54" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-19T22:05:49.293" lastbatchcompleted="2021-05-19T22:05:49.293" lastattention="1900-01-01T00:00:00.293" clientapp=".Net SqlClient Data Provider" hostname="LENOVO-PC" hostpid="18036" loginname="Lenovo-PC\User" isolationlevel="read committed (2)" xactid="453441" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="4" stmtstart="198" stmtend="268" sqlhandle="0x02000000097a651d81dcb70aa4c91f6e2599841a72ba03780000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@i int)begin tran
- declare @lock int = (select top(1) 1 from dbo.T1 with (tablock, holdlock))
- insert into dbo.T1 (N)
- values (@i)
- commit
- </inputbuf>
- </process>
- <process id="process1986dc98ca8" taskpriority="0" logused="0" waitresource="OBJECT: 6:1205579333:0 " waittime="1951" ownerId="453439" transactionname="user_transaction" lasttranstarted="2021-05-19T22:05:49.293" XDES="0x198682c7068" lockMode="IX" schedulerid="6" kpid="18388" status="suspended" spid="57" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-19T22:05:49.293" lastbatchcompleted="1900-01-01T00:00:00.293" lastattention="1900-01-01T00:00:00.293" clientapp=".Net SqlClient Data Provider" hostname="LENOVO-PC" hostpid="18036" loginname="Lenovo-PC\User" isolationlevel="read committed (2)" xactid="453439" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="4" stmtstart="198" stmtend="268" sqlhandle="0x02000000097a651d81dcb70aa4c91f6e2599841a72ba03780000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@i int)begin tran
- declare @lock int = (select top(1) 1 from dbo.T1 with (tablock, holdlock))
- insert into dbo.T1 (N)
- values (@i)
- commit
- </inputbuf>
- </process>
- </process-list>
- <resource-list>
- <objectlock lockPartition="0" objid="1205579333" subresource="FULL" dbid="6" objectname="Performance.dbo.T1" id="lock1987d756780" mode="S" associatedObjectId="1205579333">
- <owner-list>
- <owner id="process1986dc98ca8" mode="S"/>
- <owner id="process1986dc98ca8" mode="IX" requestType="convert"/>
- </owner-list>
- <waiter-list>
- <waiter id="process19868c55088" mode="IX" requestType="convert"/>
- </waiter-list>
- </objectlock>
- <objectlock lockPartition="0" objid="1205579333" subresource="FULL" dbid="6" objectname="Performance.dbo.T1" id="lock1987d756780" mode="S" associatedObjectId="1205579333">
- <owner-list>
- <owner id="process19868c55088" mode="S"/>
- <owner id="process19868c55088" mode="IX" requestType="convert"/>
- </owner-list>
- <waiter-list>
- <waiter id="process1986dc98ca8" mode="IX" requestType="convert"/>
- </waiter-list>
- </objectlock>
- </resource-list>
- </deadlock>
- </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement