Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock-list>
- <deadlock victim="process473a75088">
- <process-list>
- <process id="process473a75088" taskpriority="0" logused="0" waitresource="PAGE: 5:1:6122 " waittime="2959" ownerId="187351" transactionname="SELECT" lasttranstarted="2016-07-25T14:54:44.073" XDES="0x46b309a20" lockMode="S" schedulerid="4" kpid="18232" status="suspended" spid="63" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2016-07-25T14:54:44.073" lastbatchcompleted="2016-07-25T14:54:44.077" lastattention="1900-01-01T00:00:00.077" clientapp=".Net SqlClient Data Provider" hostname="" hostpid="13348" loginname="" isolationlevel="read committed (2)" xactid="187351" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="1" stmtstart="70" stmtend="2712" sqlhandle="0x02000000beaa1f05f89d2e4fba623ed4a34443adced4c7140000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@EntityKeyValue1 uniqueidentifier)SELECT
- [Join1].[CurrentWeek] AS [CurrentWeek],
- [Join1].[Discriminator] AS [Discriminator],
- [Join1].[ID1] AS [ID],
- [Join1].[Name] AS [Name],
- [Join1].[WeekHasStarted] AS [WeekHasStarted],
- [Join1].[Created1] AS [Created],
- [Join1].[GameAppID] AS [GameAppID],
- [Join1].[GameInstanceID] AS [GameInstanceID],
- [Join1].[ID2] AS [ID1]
- FROM [dbo].[ins_GameAppInstances] AS [Extent1]
- INNER JOIN (SELECT [Extent2].[ID] AS [ID1], [Extent2].[Name] AS [Name], [Extent2].[CurrentWeek] AS [CurrentWeek], [Extent2].[WeekHasStarted] AS [WeekHasStarted], [Extent2].[Created] AS [Created1], [Extent2].[Discriminator] AS [Discriminator], [Extent2].[GameAppID] AS [GameAppID], [Extent2].[GameInstanceID] AS [GameInstanceID], [Extent3].[ID] AS [ID2]
- FROM [dbo].[ins_GameAppInstances] AS [Extent2]
- LEFT OUTER JOIN [dbo].[ins_DefaultBankAccountInstances] AS [Extent3] ON [Extent2].[ID] = [Extent3].[GameAppInstanceID] ) AS [Join1] </inputbuf>
- </process>
- <process id="process473a07088" taskpriority="0" logused="1124" waitresource="PAGE: 5:1:4537 " waittime="2959" ownerId="187374" transactionname="user_transaction" lasttranstarted="2016-07-25T14:54:44.080" XDES="0x46d17cd80" lockMode="IX" schedulerid="8" kpid="2492" status="suspended" spid="59" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-07-25T14:54:44.090" lastbatchcompleted="2016-07-25T14:54:44.090" lastattention="1900-01-01T00:00:00.090" clientapp=".Net SqlClient Data Provider" hostname="" hostpid="13348" loginname="" isolationlevel="read committed (2)" xactid="187374" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="1" stmtstart="70" stmtend="270" sqlhandle="0x020000003d092e08bc6fe5c4f9299bd91296803dacaa647e0000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@0 int,@1 bit,@2 uniqueidentifier)UPDATE [dbo].[ins_GameAppInstances]
- SET [CurrentWeek] = @0, [WeekHasStarted] = @1
- WHERE ([ID] = @2)
- </inputbuf>
- </process>
- </process-list>
- <resource-list>
- <pagelock fileid="1" pageid="6122" dbid="5" subresource="FULL" objectname=".dbo.ins_GameAppInstances" id="lock47c6db980" mode="IX" associatedObjectId="72057594048872448">
- <owner-list>
- <owner id="process473a07088" mode="IX"/>
- </owner-list>
- <waiter-list>
- <waiter id="process473a75088" mode="S" requestType="wait"/>
- </waiter-list>
- </pagelock>
- <pagelock fileid="1" pageid="4537" dbid="5" subresource="FULL" objectname=".dbo.ins_GameAppInstances" id="lock47c6b0e00" mode="S" associatedObjectId="72057594048872448">
- <owner-list>
- <owner id="process473a75088" mode="S"/>
- </owner-list>
- <waiter-list>
- <waiter id="process473a07088" mode="IX" requestType="wait"/>
- </waiter-list>
- </pagelock>
- </resource-list>
- </deadlock>
- </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement