Guest User

Untitled

a guest
May 19th, 2021
353
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 3.90 KB | None | 0 0
  1. <deadlock-list>
  2.  <deadlock victim="process1987d047088">
  3.   <process-list>
  4.    <process id="process1987d047088" taskpriority="0" logused="352" waitresource="KEY: 6:72057594042712064 (e6eab4106daf)" waittime="4905" ownerId="479176" transactionname="INSERT" lasttranstarted="2021-05-19T22:58:28.670" XDES="0x198745e7068" lockMode="S" schedulerid="6" kpid="13704" status="suspended" spid="62" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-19T22:58:28.670" lastbatchcompleted="1900-01-01T00:00:00.670" lastattention="1900-01-01T00:00:00.670" clientapp=".Net SqlClient Data Provider" hostname="LENOVO-PC" hostpid="4952" loginname="Lenovo-PC\User" isolationlevel="read committed (2)" xactid="479176" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  5.     <executionStack>
  6.      <frame procname="Performance.dbo.fn_CheckN" line="6" stmtstart="158" stmtend="286" sqlhandle="0x03000600b7f6c34930e662012dad000000000000000000000000000000000000000000000000000000000000">
  7. if exists (select * from dbo.T1 t where t.n = @n and t.Id != @id     </frame>
  8.      <frame procname="adhoc" line="2" stmtstart="20" stmtend="90" sqlhandle="0x02000000877b131863c50d31f6909c8dcfbe44a8016aa90f0000000000000000000000000000000000000000">
  9. unknown     </frame>
  10.      <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  11. unknown     </frame>
  12.     </executionStack>
  13.     <inputbuf>
  14. (@i int)
  15. insert into dbo.T1 (N)
  16. values (@i)
  17.  
  18.     </inputbuf>
  19.    </process>
  20.    <process id="process1987d047c28" taskpriority="0" logused="352" waitresource="KEY: 6:72057594042712064 (cf00f292b5d3)" waittime="4906" ownerId="479179" transactionname="INSERT" lasttranstarted="2021-05-19T22:58:28.670" XDES="0x1987441e408" lockMode="S" schedulerid="6" kpid="28236" status="suspended" spid="60" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-19T22:58:28.670" lastbatchcompleted="2021-05-19T22:58:28.673" lastattention="1900-01-01T00:00:00.673" clientapp=".Net SqlClient Data Provider" hostname="LENOVO-PC" hostpid="4952" loginname="Lenovo-PC\User" isolationlevel="read committed (2)" xactid="479179" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  21.     <executionStack>
  22.      <frame procname="Performance.dbo.fn_CheckN" line="6" stmtstart="158" stmtend="286" sqlhandle="0x03000600b7f6c34930e662012dad000000000000000000000000000000000000000000000000000000000000">
  23. if exists (select * from dbo.T1 t where t.n = @n and t.Id != @id     </frame>
  24.      <frame procname="adhoc" line="2" stmtstart="20" stmtend="90" sqlhandle="0x02000000877b131863c50d31f6909c8dcfbe44a8016aa90f0000000000000000000000000000000000000000">
  25. unknown     </frame>
  26.      <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  27. unknown     </frame>
  28.     </executionStack>
  29.     <inputbuf>
  30. (@i int)
  31. insert into dbo.T1 (N)
  32. values (@i)
  33.  
  34.     </inputbuf>
  35.    </process>
  36.   </process-list>
  37.   <resource-list>
  38.    <keylock hobtid="72057594042712064" dbid="6" objectname="Performance.dbo.T1" indexname="NonClusteredIndex-20210519-225535" id="lock1987d75c780" mode="X" associatedObjectId="72057594042712064">
  39.     <owner-list>
  40.      <owner id="process1987d047c28" mode="X"/>
  41.     </owner-list>
  42.     <waiter-list>
  43.      <waiter id="process1987d047088" mode="S" requestType="wait"/>
  44.     </waiter-list>
  45.    </keylock>
  46.    <keylock hobtid="72057594042712064" dbid="6" objectname="Performance.dbo.T1" indexname="NonClusteredIndex-20210519-225535" id="lock1987d764600" mode="X" associatedObjectId="72057594042712064">
  47.     <owner-list>
  48.      <owner id="process1987d047088" mode="X"/>
  49.     </owner-list>
  50.     <waiter-list>
  51.      <waiter id="process1987d047c28" mode="S" requestType="wait"/>
  52.     </waiter-list>
  53.    </keylock>
  54.   </resource-list>
  55.  </deadlock>
  56. </deadlock-list>
  57.  
Advertisement
Add Comment
Please, Sign In to add comment