API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 13th, 2018
362
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 6.46 KB | None | 0 0
raw download clone embed print report
  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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!