Skip to content

Instantly share code, notes, and snippets.

@PureKrome
Created February 15, 2017 23:36
Show Gist options
  • Save PureKrome/8a3fe15bec04172b2d165fabf22ddcd9 to your computer and use it in GitHub Desktop.
Save PureKrome/8a3fe15bec04172b2d165fabf22ddcd9 to your computer and use it in GitHub Desktop.
Another god damn deadlock crapz0r.
<deadlock>
<victim-list>
<victimProcess id="process183feeca8" />
</victim-list>
<process-list>
<process id="process183feeca8" taskpriority="0" logused="1048" waitresource="KEY: 9:72057594043432960 (1bd62ff2fe56)" waittime="3890" ownerId="110213351" transactionname="user_transaction" lasttranstarted="2017-02-15T22:32:01.393" XDES="0x1e8b89770" lockMode="RangeI-N" schedulerid="5" kpid="3772" status="suspended" spid="63" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-02-15T22:32:01.523" lastbatchcompleted="2017-02-15T22:32:01.533" lastattention="1900-01-01T00:00:00.533" clientapp=".Net SqlClient Data Provider" hostname="Snipped" hostpid="24664" loginname="Snipped" isolationlevel="serializable (4)" xactid="110213351" currentdb="9" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="2" stmtstart="290" stmtend="734" sqlhandle="0x020000007d7a922e20046c2639e3132e2e87857f9bb6e70d0000000000000000000000000000000000000000">
unknown </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@Id int,@Name nvarchar(4000),@ContactName nvarchar(4000),@ContactPhone nvarchar(4000),@ContactEmail nvarchar(4000),@ErrorEmail nvarchar(4000))
UPDATE [dbo].[People]
SET Name = @Name,
ContactName = @ContactName,
ContactPhone = @ContactPhone,
ContactEmail = @ContactEmail,
ErrorEmail = @ErrorEmail
WHERE PersonId = @Id </inputbuf>
</process>
<process id="process2448d3088" taskpriority="0" logused="1512" waitresource="KEY: 9:72057594043432960 (a96e27f78141)" waittime="3952" ownerId="110211149" transactionname="user_transaction" lasttranstarted="2017-02-15T22:32:00.390" XDES="0x17cd99770" lockMode="RangeS-S" schedulerid="2" kpid="6156" status="suspended" spid="55" sbid="2" ecid="0" priority="0" trancount="1" lastbatchstarted="2017-02-15T22:32:01.420" lastbatchcompleted="2017-02-15T22:32:01.423" lastattention="1900-01-01T00:00:00.423" clientapp=".Net SqlClient Data Provider" hostname="Snipped" hostpid="24664" loginname="Snipped" isolationlevel="serializable (4)" xactid="110211149" currentdb="9" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="104" sqlhandle="0x020000004259491db52603b53bf21c041e6eec8fb2f111ba0000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT COUNT(PersonId) FROM [dbo].[People] </inputbuf>
</process>
</process-list>
<resource-list>
<keylock hobtid="72057594043432960" dbid="9" objectname="FileData.dbo.People" indexname="IX_People_Name" id="lock1ccc00d80" mode="RangeX-X" associatedObjectId="72057594043432960">
<owner-list>
<owner id="process2448d3088" mode="RangeX-X" />
</owner-list>
<waiter-list>
<waiter id="process183feeca8" mode="RangeI-N" requestType="wait" />
</waiter-list>
</keylock>
<keylock hobtid="72057594043432960" dbid="9" objectname="FileData.dbo.People" indexname="IX_People_Name" id="lock150234600" mode="X" associatedObjectId="72057594043432960">
<owner-list>
<owner id="process183feeca8" mode="X" />
</owner-list>
<waiter-list>
<waiter id="process2448d3088" mode="RangeS-S" requestType="wait" />
</waiter-list>
</keylock>
</resource-list>
</deadlock>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment