This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

cool

By: a guest on Apr 11th, 2013  |  syntax: XML  |  size: 5.72 KB  |  views: 60  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <deadlock-list>
  2.  <deadlock victim="processc3eef8">
  3.   <process-list>
  4.    <process id="processc3eef8" taskpriority="0" logused="2316" waitresource="KEY: 11:72057603266445312 (bc003d4a6ac6)" waittime="1265" ownerId="227297079" transactionname="user_transaction" lasttranstarted="2013-03-27T09:06:21.780" XDES="0x96b89a50" lockMode="U" schedulerid="1" kpid="3216" status="suspended" spid="59" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2013-03-27T09:02:30.957" lastbatchcompleted="2013-03-27T09:02:24.097" clientapp="Microsoft SQL Server Management Studio - Query" hostname="blankedout" hostpid="3840"
  5.   loginname="blankedout" isolationlevel="read committed (2)" xactid="227297079" currentdb="11" lockTimeout="4294967295" clientoption1="673319008" clientoption2="390200">
  6.     <executionStack>
  7.      <frame procname="madeupdb.dbo.trgUpdateMadeUpName" line="51" stmtstart="2926" stmtend="3316" sqlhandle="0x03000b008eb92a797d4acd0072a100000000000000000000">
  8. Update b set Draw_Date=d.draw_date    
  9.         from tableA b
  10.         inner join tableB d with (nolock) on b.draw_no=d.draw_no    
  11.         and left(b.game,2)=&apos;UK&apos; and b.Draw_Date is null     </frame>
  12.      <frame procname="madeupdb.dbo.SP_MEM_NODE_PAYMENT_INSERT" line="19" stmtstart="1006" stmtend="1560" sqlhandle="0x03000b00a3b8842785a31f01da9e00000100000000000000">
  13. insert into mem_node_payment(params here)
  14.         values(params here)     </frame>
  15.      <frame procname="madeupdb.dbo.SP_NONE_PAYMENT" line="156" stmtstart="10248" stmtend="10554" sqlhandle="0x03000b002d916b7762853201f6a000000100000000000000">
  16. exec SP_MEM_NODE_PAYMENT_INSERT params here     </frame>
  17.      <frame procname="madeupdb.dbo.SP_RECORD" line="65" stmtstart="5278" stmtend="5532" sqlhandle="0x03000b00dbcf071433b9510104a100000100000000000000">
  18. exec SP_NONE_PAYMENT params here</frame>
  19.      <frame procname="madeupdb.dbo.SP_CONFIRMED" line="62" stmtstart="3668" stmtend="3828" sqlhandle="0x03000b00c0a66d208b76a90017a100000100000000000000">
  20. exec SP_RECORD params here </frame>
  21.      <frame procname="adhoc" line="6" stmtstart="112" stmtend="412" sqlhandle="0x0200000022524113d31d57be58017a1c0d1d6a11d3d433a3">
  22. EXEC SP_CONFIRMED       @table_name = &apos;sys_transaction&apos; /* VARCHAR(50) */,
  23.                                                         @pk_id = 1000568271 /* INT */,
  24.                                                         @amt_ext = 5 /* MONEY */     </frame>
  25.     </executionStack>
  26.     <inputbuf>
  27. DECLARE @I int
  28. SET @I = 1
  29.  
  30. WHILE @I &lt;= 2000
  31. BEGIN
  32.         EXEC SP_CONFIRMED       @table_name = &apos;sys_transaction&apos; /* VARCHAR(50) */,
  33.                                                         @pk_id = 1000568271 /* INT */,
  34.                                                         @amt_ext = 5 /* MONEY */
  35.         SET @I = @I + 1
  36. END
  37.     </inputbuf>
  38.    </process>
  39.    <process id="processecb198" taskpriority="0" logused="3148" waitresource="PAGE: 11:1:1554543" waittime="1156" ownerId="227297052" transactionname="user_transaction" lasttranstarted="2013-03-27T09:06:21.750" XDES="0x8b79c700" lockMode="U" schedulerid="3" kpid="604" status="suspended" spid="58" sbid="2" ecid="0" priority="0" transcount="2" lastbatchstarted="2013-03-27T09:06:21.750" lastbatchcompleted="2013-03-27T09:06:21.750" clientapp="EntityFrameworkMUE" hostname="hostgoeshere" hostpid="1908"
  40.   loginname="blankedout" isolationlevel="read committed (2)" xactid="227297052" currentdb="11" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
  41.     <executionStack>
  42.      <frame procname="madeupdb.dbo.trgUpdateMadeUpName" line="91" stmtstart="6156" stmtend="6652" sqlhandle="0x03000b008eb92a797d4acd0072a100000000000000000000">
  43. Update b set  syd_id=d.syd_id    
  44.         from tableA b    
  45.         inner join tableC d with (nolock) on b.syd_pers_id=d.syd_pers_id    
  46.         --and b.game=&apos;es_lotto&apos;    
  47.         and b.game=d.game  and isnull(b.syd_id,0)=0     </frame>
  48.      <frame procname="madeupdb.dbo.SP_MEM_NODE_PAYMENT_INSERT" line="19" stmtstart="1006" stmtend="1560" sqlhandle="0x03000b00a3b8842785a31f01da9e00000100000000000000">
  49. insert into mem_node_payment(params here)
  50.         values(params here)     </frame>
  51.      <frame procname="madeupdb.dbo.SP_NONE_PAYMENT" line="156" stmtstart="10248" stmtend="10554" sqlhandle="0x03000b002d916b7762853201f6a000000100000000000000">
  52. exec SP_MEM_NODE_PAYMENT_INSERT params here</frame>
  53.      <frame procname="madeupdb.dbo.SP_RECORD" line="65" stmtstart="5278" stmtend="5532" sqlhandle="0x03000b00dbcf071433b9510104a100000100000000000000">
  54. exec SP_NONE_PAYMENT params here</frame>
  55.      <frame procname="madeupdb.dbo.SP_CONFIRMED" line="62" stmtstart="3668" stmtend="3828" sqlhandle="0x03000b00c0a66d208b76a90017a100000100000000000000">
  56. exec SP_RECORD params here </frame>
  57.      <frame procname="adhoc" line="1" stmtstart="118" sqlhandle="0x01000b00b691f53320ccd91c010000000000000000000000">
  58. EXEC sp_confirmed params here </frame>
  59.      <frame procname="unknown" line="1" sqlhandle="0x000000000000000000000000000000000000000000000000">
  60. unknown     </frame>
  61.     </executionStack>
  62.     <inputbuf>
  63. (@table_name nvarchar(19),@pk_id int,@amt_ext decimal(5,4))EXEC sp_confirmed @table_name, @pk_id, @amt_ext    </inputbuf>
  64.    </process>
  65.   </process-list>
  66.   <resource-list>
  67.    <pagelock fileid="1" pageid="1554543" dbid="11" objectname="madeupdb.dbo.tableA" id="lock105e0b680" mode="IX" associatedObjectId="72057603266510848">
  68.     <owner-list>
  69.      <owner id="processc3eef8" mode="IX"/>
  70.     </owner-list>
  71.     <waiter-list>
  72.      <waiter id="processecb198" mode="U" requestType="convert"/>
  73.     </waiter-list>
  74.    </pagelock>
  75.    <keylock hobtid="72057603266445312" dbid="11" objectname="madeupdb.dbo.tableA" indexname="IX_tableA_Draw_Date" id="lock149f6cf00" mode="X" associatedObjectId="72057603266445312">
  76.     <owner-list>
  77.      <owner id="processecb198" mode="X"/>
  78.     </owner-list>
  79.     <waiter-list>
  80.      <waiter id="processc3eef8" mode="U" requestType="wait"/>
  81.     </waiter-list>
  82.    </keylock>
  83.   </resource-list>
  84.  </deadlock>
  85. </deadlock-list>
clone this paste RAW Paste Data