Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock-list>
- <deadlock victim="process1987d047088">
- <process-list>
- <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">
- <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="0x02000000877b131863c50d31f6909c8dcfbe44a8016aa90f0000000000000000000000000000000000000000">
- 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="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">
- <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="0x02000000877b131863c50d31f6909c8dcfbe44a8016aa90f0000000000000000000000000000000000000000">
- 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="72057594042712064" dbid="6" objectname="Performance.dbo.T1" indexname="NonClusteredIndex-20210519-225535" id="lock1987d75c780" mode="X" associatedObjectId="72057594042712064">
- <owner-list>
- <owner id="process1987d047c28" mode="X"/>
- </owner-list>
- <waiter-list>
- <waiter id="process1987d047088" mode="S" requestType="wait"/>
- </waiter-list>
- </keylock>
- <keylock hobtid="72057594042712064" dbid="6" objectname="Performance.dbo.T1" indexname="NonClusteredIndex-20210519-225535" id="lock1987d764600" mode="X" associatedObjectId="72057594042712064">
- <owner-list>
- <owner id="process1987d047088" mode="X"/>
- </owner-list>
- <waiter-list>
- <waiter id="process1987d047c28" mode="S" requestType="wait"/>
- </waiter-list>
- </keylock>
- </resource-list>
- </deadlock>
- </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment