Guest User

Deadlock

a guest
Jul 25th, 2016
113
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <deadlock-list>
  2.  <deadlock victim="process473a75088">
  3.   <process-list>
  4.    <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">
  5.     <executionStack>
  6.      <frame procname="adhoc" line="1" stmtstart="70" stmtend="2712" sqlhandle="0x02000000beaa1f05f89d2e4fba623ed4a34443adced4c7140000000000000000000000000000000000000000">
  7. unknown     </frame>
  8.      <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  9. unknown     </frame>
  10.     </executionStack>
  11.     <inputbuf>
  12. (@EntityKeyValue1 uniqueidentifier)SELECT
  13.     [Join1].[CurrentWeek] AS [CurrentWeek],
  14.     [Join1].[Discriminator] AS [Discriminator],
  15.     [Join1].[ID1] AS [ID],
  16.     [Join1].[Name] AS [Name],
  17.     [Join1].[WeekHasStarted] AS [WeekHasStarted],
  18.     [Join1].[Created1] AS [Created],
  19.     [Join1].[GameAppID] AS [GameAppID],
  20.     [Join1].[GameInstanceID] AS [GameInstanceID],
  21.     [Join1].[ID2] AS [ID1]
  22.     FROM  [dbo].[ins_GameAppInstances] AS [Extent1]
  23.     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]
  24.         FROM  [dbo].[ins_GameAppInstances] AS [Extent2]
  25.         LEFT OUTER JOIN [dbo].[ins_DefaultBankAccountInstances] AS [Extent3] ON [Extent2].[ID] = [Extent3].[GameAppInstanceID] ) AS [Join1]     </inputbuf>
  26.    </process>
  27.    <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">
  28.     <executionStack>
  29.      <frame procname="adhoc" line="1" stmtstart="70" stmtend="270" sqlhandle="0x020000003d092e08bc6fe5c4f9299bd91296803dacaa647e0000000000000000000000000000000000000000">
  30. unknown     </frame>
  31.      <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  32. unknown     </frame>
  33.     </executionStack>
  34.     <inputbuf>
  35. (@0 int,@1 bit,@2 uniqueidentifier)UPDATE [dbo].[ins_GameAppInstances]
  36. SET [CurrentWeek] = @0, [WeekHasStarted] = @1
  37. WHERE ([ID] = @2)
  38.     </inputbuf>
  39.    </process>
  40.   </process-list>
  41.   <resource-list>
  42.    <pagelock fileid="1" pageid="6122" dbid="5" subresource="FULL" objectname=".dbo.ins_GameAppInstances" id="lock47c6db980" mode="IX" associatedObjectId="72057594048872448">
  43.     <owner-list>
  44.      <owner id="process473a07088" mode="IX"/>
  45.     </owner-list>
  46.     <waiter-list>
  47.      <waiter id="process473a75088" mode="S" requestType="wait"/>
  48.     </waiter-list>
  49.    </pagelock>
  50.    <pagelock fileid="1" pageid="4537" dbid="5" subresource="FULL" objectname=".dbo.ins_GameAppInstances" id="lock47c6b0e00" mode="S" associatedObjectId="72057594048872448">
  51.     <owner-list>
  52.      <owner id="process473a75088" mode="S"/>
  53.     </owner-list>
  54.     <waiter-list>
  55.      <waiter id="process473a07088" mode="IX" requestType="wait"/>
  56.     </waiter-list>
  57.    </pagelock>
  58.   </resource-list>
  59.  </deadlock>
  60. </deadlock-list>
RAW Paste Data