Skip to content

Instantly share code, notes, and snippets.

Created September 30, 2015 12:38
Show Gist options
  • Save anonymous/c494a24c8005c5315a0e to your computer and use it in GitHub Desktop.
Save anonymous/c494a24c8005c5315a0e to your computer and use it in GitHub Desktop.
<deadlock-list>
<deadlock victim="process178c47c38">
<process-list>
<process id="process178c47c38" taskpriority="0" logused="1276" waitresource="KEY: 10:72057594040745984 (a6f83671dac8)" waittime="2176" ownerId="671703744" transactionname="user_transaction" lasttranstarted="2015-09-29T09:36:03.040" XDES="0x160b76538" lockMode="S" schedulerid="1" kpid="2592" status="suspended" spid="59" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2015-09-29T09:36:03.180" lastbatchcompleted="2015-09-29T09:36:03.163" lastattention="1900-01-01T00:00:00.163" clientapp="EntityFramework" hostname="WORKSTATION341" hostpid="37504" loginname="companyEmployeeUser" isolationlevel="read committed (2)" xactid="671703744" currentdb="10" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtstart="16" sqlhandle="0x020000006fba421a6eba06a4e8f814ce5fa6d0b585b355eb0000000000000000000000000000000000000000">
DELETE [dbo].[Company_EmployeeToSystem]
WHERE ([Id] = @0) </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@0 int)DELETE [dbo].[Company_EmployeeToSystem]
WHERE ([Id] = @0) </inputbuf>
</process>
<process id="process121d0b0c8" taskpriority="0" logused="3572" waitresource="KEY: 10:72057594040745984 (2e5ec15f9047)" waittime="1926" ownerId="671703743" transactionname="user_transaction" lasttranstarted="2015-09-29T09:36:03.023" XDES="0x171fd8d28" lockMode="S" schedulerid="1" kpid="12" status="suspended" spid="77" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2015-09-29T09:36:03.430" lastbatchcompleted="2015-09-29T09:36:03.397" lastattention="1900-01-01T00:00:00.397" clientapp="EntityFramework" hostname="WORKSTATION341" hostpid="37504" loginname="companyEmployeeUser" isolationlevel="read committed (2)" xactid="671703743" currentdb="10" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtstart="16" sqlhandle="0x020000006fba421a6eba06a4e8f814ce5fa6d0b585b355eb0000000000000000000000000000000000000000">
DELETE [dbo].[Company_EmployeeToSystem]
WHERE ([Id] = @0) </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@0 int)DELETE [dbo].[Company_EmployeeToSystem]
WHERE ([Id] = @0) </inputbuf>
</process>
</process-list>
<resource-list>
<keylock hobtid="72057594040745984" dbid="10" objectname="companyEmployee.dbo.Company_EmployeeSystemData" indexname="1" id="lock15865f180" mode="X" associatedObjectId="72057594040745984">
<owner-list>
<owner id="process121d0b0c8" mode="X"/>
</owner-list>
<waiter-list>
<waiter id="process178c47c38" mode="S" requestType="wait"/>
</waiter-list>
</keylock>
<keylock hobtid="72057594040745984" dbid="10" objectname="companyEmployee.dbo.Company_EmployeeSystemData" indexname="1" id="lock17cea5400" mode="X" associatedObjectId="72057594040745984">
<owner-list>
<owner id="process178c47c38" mode="X"/>
</owner-list>
<waiter-list>
<waiter id="process121d0b0c8" mode="S" requestType="wait"/>
</waiter-list>
</keylock>
</resource-list>
</deadlock>
</deadlock-list>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment