Advertisement
Guest User

Untitled

a guest
May 19th, 2021
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 3.87 KB | None | 0 0
  1. <deadlock-list>
  2.  <deadlock victim="process1987109b088">
  3.   <process-list>
  4.    <process id="process1987109b088" taskpriority="0" logused="240" waitresource="KEY: 6:72057594042515456 (d0f906f13f36)" waittime="185" ownerId="25181" transactionname="INSERT" lasttranstarted="2021-05-19T21:55:39.590" XDES="0x1986787c408" lockMode="S" schedulerid="4" kpid="25884" status="suspended" spid="57" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-19T21:55:39.590" lastbatchcompleted="2021-05-19T21:55:39.590" lastattention="1900-01-01T00:00:00.590" clientapp=".Net SqlClient Data Provider" hostname="LENOVO-PC" hostpid="21592" loginname="Lenovo-PC\User" isolationlevel="read committed (2)" xactid="25181" 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="0x0200000027d3be2659d8fbd8cf683b2e30a2e7f9956cd6b20000000000000000000000000000000000000000">
  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.     </inputbuf>
  18.    </process>
  19.    <process id="process1987d047088" taskpriority="0" logused="240" waitresource="KEY: 6:72057594042515456 (d159f45a495f)" waittime="185" ownerId="25183" transactionname="INSERT" lasttranstarted="2021-05-19T21:55:39.590" XDES="0x19869908408" lockMode="S" schedulerid="6" kpid="28236" status="suspended" spid="58" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-19T21:55:39.590" lastbatchcompleted="2021-05-19T21:55:39.590" lastattention="1900-01-01T00:00:00.590" clientapp=".Net SqlClient Data Provider" hostname="LENOVO-PC" hostpid="21592" loginname="Lenovo-PC\User" isolationlevel="read committed (2)" xactid="25183" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  20.     <executionStack>
  21.      <frame procname="Performance.dbo.fn_CheckN" line="6" stmtstart="158" stmtend="286" sqlhandle="0x03000600b7f6c34930e662012dad000000000000000000000000000000000000000000000000000000000000">
  22. if exists (select * from dbo.T1 t where t.n = @n and t.Id != @id     </frame>
  23.      <frame procname="adhoc" line="2" stmtstart="20" stmtend="90" sqlhandle="0x0200000027d3be2659d8fbd8cf683b2e30a2e7f9956cd6b20000000000000000000000000000000000000000">
  24. unknown     </frame>
  25.      <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  26. unknown     </frame>
  27.     </executionStack>
  28.     <inputbuf>
  29. (@i int)
  30. insert into dbo.T1 (N)
  31. values (@i)
  32.     </inputbuf>
  33.    </process>
  34.   </process-list>
  35.   <resource-list>
  36.    <keylock hobtid="72057594042515456" dbid="6" objectname="Performance.dbo.T1" indexname="PK__T1__3214EC07B8B934FA" id="lock1987d759c00" mode="X" associatedObjectId="72057594042515456">
  37.     <owner-list>
  38.      <owner id="process1987d047088" mode="X"/>
  39.     </owner-list>
  40.     <waiter-list>
  41.      <waiter id="process1987109b088" mode="S" requestType="wait"/>
  42.     </waiter-list>
  43.    </keylock>
  44.    <keylock hobtid="72057594042515456" dbid="6" objectname="Performance.dbo.T1" indexname="PK__T1__3214EC07B8B934FA" id="lock1987d74cd80" mode="X" associatedObjectId="72057594042515456">
  45.     <owner-list>
  46.      <owner id="process1987109b088" mode="X"/>
  47.     </owner-list>
  48.     <waiter-list>
  49.      <waiter id="process1987d047088" mode="S" requestType="wait"/>
  50.     </waiter-list>
  51.    </keylock>
  52.   </resource-list>
  53.  </deadlock>
  54. </deadlock-list>
  55.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement