Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock-list>
- <deadlock victim="process1987109b088">
- <process-list>
- <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">
- <executionStack>
- <frame procname="Performance.dbo.fn_CheckN" line="6" stmtstart="158" stmtend="286" sqlhandle="0x03000600b7f6c34930e662012dad000000000000000000000000000000000000000000000000000000000000">
- if exists (select * from dbo.T1 t where t.n = @n and t.Id != @id </frame>
- <frame procname="adhoc" line="2" stmtstart="20" stmtend="90" sqlhandle="0x0200000027d3be2659d8fbd8cf683b2e30a2e7f9956cd6b20000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@i int)
- insert into dbo.T1 (N)
- values (@i)
- </inputbuf>
- </process>
- <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">
- <executionStack>
- <frame procname="Performance.dbo.fn_CheckN" line="6" stmtstart="158" stmtend="286" sqlhandle="0x03000600b7f6c34930e662012dad000000000000000000000000000000000000000000000000000000000000">
- if exists (select * from dbo.T1 t where t.n = @n and t.Id != @id </frame>
- <frame procname="adhoc" line="2" stmtstart="20" stmtend="90" sqlhandle="0x0200000027d3be2659d8fbd8cf683b2e30a2e7f9956cd6b20000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@i int)
- insert into dbo.T1 (N)
- values (@i)
- </inputbuf>
- </process>
- </process-list>
- <resource-list>
- <keylock hobtid="72057594042515456" dbid="6" objectname="Performance.dbo.T1" indexname="PK__T1__3214EC07B8B934FA" id="lock1987d759c00" mode="X" associatedObjectId="72057594042515456">
- <owner-list>
- <owner id="process1987d047088" mode="X"/>
- </owner-list>
- <waiter-list>
- <waiter id="process1987109b088" mode="S" requestType="wait"/>
- </waiter-list>
- </keylock>
- <keylock hobtid="72057594042515456" dbid="6" objectname="Performance.dbo.T1" indexname="PK__T1__3214EC07B8B934FA" id="lock1987d74cd80" mode="X" associatedObjectId="72057594042515456">
- <owner-list>
- <owner id="process1987109b088" mode="X"/>
- </owner-list>
- <waiter-list>
- <waiter id="process1987d047088" mode="S" requestType="wait"/>
- </waiter-list>
- </keylock>
- </resource-list>
- </deadlock>
- </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement