-
-
Save PureKrome/8a3fe15bec04172b2d165fabf22ddcd9 to your computer and use it in GitHub Desktop.
Another god damn deadlock crapz0r.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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