Advertisement
Guest User

Untitled

a guest
May 19th, 2021
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 3.66 KB | None | 0 0
  1. <deadlock-list>
  2.  <deadlock victim="process19868c55088">
  3.   <process-list>
  4.    <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">
  5.     <executionStack>
  6.      <frame procname="adhoc" line="4" stmtstart="198" stmtend="268" sqlhandle="0x02000000097a651d81dcb70aa4c91f6e2599841a72ba03780000000000000000000000000000000000000000">
  7. unknown     </frame>
  8.      <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  9. unknown     </frame>
  10.     </executionStack>
  11.     <inputbuf>
  12. (@i int)begin tran
  13. declare @lock int = (select top(1) 1 from dbo.T1 with (tablock, holdlock))
  14.  
  15. insert into dbo.T1 (N)
  16. values (@i)
  17.  
  18. commit
  19.     </inputbuf>
  20.    </process>
  21.    <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">
  22.     <executionStack>
  23.      <frame procname="adhoc" line="4" stmtstart="198" stmtend="268" sqlhandle="0x02000000097a651d81dcb70aa4c91f6e2599841a72ba03780000000000000000000000000000000000000000">
  24. unknown     </frame>
  25.      <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  26. unknown     </frame>
  27.     </executionStack>
  28.     <inputbuf>
  29. (@i int)begin tran
  30. declare @lock int = (select top(1) 1 from dbo.T1 with (tablock, holdlock))
  31.  
  32. insert into dbo.T1 (N)
  33. values (@i)
  34.  
  35. commit
  36.     </inputbuf>
  37.    </process>
  38.   </process-list>
  39.   <resource-list>
  40.    <objectlock lockPartition="0" objid="1205579333" subresource="FULL" dbid="6" objectname="Performance.dbo.T1" id="lock1987d756780" mode="S" associatedObjectId="1205579333">
  41.     <owner-list>
  42.      <owner id="process1986dc98ca8" mode="S"/>
  43.      <owner id="process1986dc98ca8" mode="IX" requestType="convert"/>
  44.     </owner-list>
  45.     <waiter-list>
  46.      <waiter id="process19868c55088" mode="IX" requestType="convert"/>
  47.     </waiter-list>
  48.    </objectlock>
  49.    <objectlock lockPartition="0" objid="1205579333" subresource="FULL" dbid="6" objectname="Performance.dbo.T1" id="lock1987d756780" mode="S" associatedObjectId="1205579333">
  50.     <owner-list>
  51.      <owner id="process19868c55088" mode="S"/>
  52.      <owner id="process19868c55088" mode="IX" requestType="convert"/>
  53.     </owner-list>
  54.     <waiter-list>
  55.      <waiter id="process1986dc98ca8" mode="IX" requestType="convert"/>
  56.     </waiter-list>
  57.    </objectlock>
  58.   </resource-list>
  59.  </deadlock>
  60. </deadlock-list>
  61.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement