daily pastebin goal
23%
SHARE
TWEET

Untitled

a guest Feb 13th, 2018 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <event name="xml_deadlock_report" package="sqlserver" timestamp="2018-02-13T14:03:16.117Z">
  2.   <data name="xml_report">
  3.     <value>
  4.       <deadlock>
  5.         <victim-list />
  6.         <process-list>
  7.           <process id="process1cb61fdaca8" taskpriority="0" logused="10000" waittime="4948" schedulerid="12" kpid="5052" status="suspended" spid="52" sbid="0" ecid="8" priority="0" trancount="0" lastbatchstarted="2018-02-13T08:55:54.900" lastbatchcompleted="2018-02-13T08:55:54.900" lastattention="1900-01-01T00:00:00.900" clientapp="Microsoft SQL Server Management Studio - Query" hostname="NADASUPERIOR" hostpid="8152" isolationlevel="read committed (2)" xactid="3545003" currentdb="6" lockTimeout="4294967295" clientoption1="671098976" clientoption2="390200">
  8.             <executionStack>
  9.               <frame procname="adhoc" line="1" stmtstart="8" stmtend="710" sqlhandle="0x02000000bd2bc700e48f5562ce2832160bd90dfac8c1ec0b0000000000000000000000000000000000000000">
  10. unknown    </frame>
  11.             </executionStack>
  12.             <inputbuf>
  13.     SELECT      TOP 10 p.OwnerUserId
  14.     FROM        dbo.Posts AS p
  15.     WHERE       NOT EXISTS (   SELECT   *
  16.                                FROM     dbo.Badges AS b
  17.                                WHERE    p.OwnerUserId = b.UserId )
  18.     ORDER BY    p.OwnerUserId
  19.  
  20. OPTION(MAXDOP 4, USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'), MERGE JOIN, HASH GROUP)   </inputbuf>
  21.           </process>
  22.           <process id="process1cb79066ca8" taskpriority="0" logused="10000" waittime="346307" schedulerid="10" kpid="12760" status="suspended" spid="52" sbid="0" ecid="4" priority="0" trancount="0" lastbatchstarted="2018-02-13T08:55:54.900" lastbatchcompleted="2018-02-13T08:55:54.900" lastattention="1900-01-01T00:00:00.900" clientapp="Microsoft SQL Server Management Studio - Query" hostname="NADASUPERIOR" hostpid="8152" isolationlevel="read committed (2)" xactid="3545003" currentdb="6" lockTimeout="4294967295" clientoption1="671098976" clientoption2="390200">
  23.             <executionStack>
  24.               <frame procname="adhoc" line="1" stmtstart="8" stmtend="710" sqlhandle="0x02000000bd2bc700e48f5562ce2832160bd90dfac8c1ec0b0000000000000000000000000000000000000000">
  25. unknown    </frame>
  26.             </executionStack>
  27.             <inputbuf>
  28.     SELECT      TOP 10 p.OwnerUserId
  29.     FROM        dbo.Posts AS p
  30.     WHERE       NOT EXISTS (   SELECT   *
  31.                                FROM     dbo.Badges AS b
  32.                                WHERE    p.OwnerUserId = b.UserId )
  33.     ORDER BY    p.OwnerUserId
  34.  
  35. OPTION(MAXDOP 4, USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'), MERGE JOIN, HASH GROUP)   </inputbuf>
  36.           </process>
  37.           <process id="process1cb79056ca8" taskpriority="0" logused="10000" waittime="4339" schedulerid="8" kpid="11924" status="suspended" spid="52" sbid="0" ecid="2" priority="0" trancount="0" lastbatchstarted="2018-02-13T08:55:54.900" lastbatchcompleted="2018-02-13T08:55:54.900" lastattention="1900-01-01T00:00:00.900" clientapp="Microsoft SQL Server Management Studio - Query" hostname="NADASUPERIOR" hostpid="8152" isolationlevel="read committed (2)" xactid="3545003" currentdb="6" lockTimeout="4294967295" clientoption1="671098976" clientoption2="390200">
  38.             <executionStack>
  39.               <frame procname="adhoc" line="1" stmtstart="8" stmtend="710" sqlhandle="0x02000000bd2bc700e48f5562ce2832160bd90dfac8c1ec0b0000000000000000000000000000000000000000">
  40. unknown    </frame>
  41.             </executionStack>
  42.             <inputbuf>
  43.     SELECT      TOP 10 p.OwnerUserId
  44.     FROM        dbo.Posts AS p
  45.     WHERE       NOT EXISTS (   SELECT   *
  46.                                FROM     dbo.Badges AS b
  47.                                WHERE    p.OwnerUserId = b.UserId )
  48.     ORDER BY    p.OwnerUserId
  49.  
  50. OPTION(MAXDOP 4, USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'), MERGE JOIN, HASH GROUP)   </inputbuf>
  51.           </process>
  52.           <process id="process1cb61fd7088" taskpriority="0" logused="10000" waittime="54344" schedulerid="4" kpid="4340" status="suspended" spid="52" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2018-02-13T08:55:54.900" lastbatchcompleted="2018-02-13T08:55:54.900" lastattention="1900-01-01T00:00:00.900" clientapp="Microsoft SQL Server Management Studio - Query" hostname="NADASUPERIOR" hostpid="8152" loginname="sa" isolationlevel="read committed (2)" xactid="3545003" currentdb="6" lockTimeout="4294967295" clientoption1="671098976" clientoption2="390200">
  53.             <executionStack>
  54.               <frame procname="adhoc" line="1" stmtstart="8" stmtend="710" sqlhandle="0x02000000bd2bc700e48f5562ce2832160bd90dfac8c1ec0b0000000000000000000000000000000000000000">
  55. unknown    </frame>
  56.             </executionStack>
  57.             <inputbuf>
  58.     SELECT      TOP 10 p.OwnerUserId
  59.     FROM        dbo.Posts AS p
  60.     WHERE       NOT EXISTS (   SELECT   *
  61.                                FROM     dbo.Badges AS b
  62.                                WHERE    p.OwnerUserId = b.UserId )
  63.     ORDER BY    p.OwnerUserId
  64.  
  65. OPTION(MAXDOP 4, USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'), MERGE JOIN, HASH GROUP)   </inputbuf>
  66.           </process>
  67.         </process-list>
  68.         <resource-list>
  69.           <exchangeEvent id="Pipe1bb15776200" WaitType="e_waitPipeNewRow" nodeId="3">
  70.             <owner-list>
  71.               <owner id="process1cb79066ca8" />
  72.             </owner-list>
  73.             <waiter-list>
  74.               <waiter id="process1cb61fdaca8" />
  75.             </waiter-list>
  76.           </exchangeEvent>
  77.           <exchangeEvent id="Pipe1c584493460" WaitType="e_waitPipeNewRow" nodeId="1">
  78.             <owner-list>
  79.               <owner id="process1cb61fd7088" />
  80.             </owner-list>
  81.             <waiter-list>
  82.               <waiter id="process1cb79066ca8" />
  83.             </waiter-list>
  84.           </exchangeEvent>
  85.           <exchangeEvent id="Pipe1bb15777700" WaitType="e_waitPipeGetRow" nodeId="3">
  86.             <owner-list>
  87.               <owner id="process1cb61fdaca8" />
  88.             </owner-list>
  89.             <waiter-list>
  90.               <waiter id="process1cb79056ca8" />
  91.             </waiter-list>
  92.           </exchangeEvent>
  93.           <exchangeEvent id="Pipe1c584492930" WaitType="e_waitPipeGetRow" nodeId="1">
  94.             <owner-list>
  95.               <owner id="process1cb79056ca8" />
  96.             </owner-list>
  97.             <waiter-list>
  98.               <waiter id="process1cb61fd7088" />
  99.             </waiter-list>
  100.           </exchangeEvent>
  101.         </resource-list>
  102.       </deadlock>
  103.     </value>
  104.   </data>
  105. </event>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top