Guest User

Untitled

a guest
Aug 4th, 2016
134
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <event name="xml_deadlock_report" package="sqlserver" timestamp="2016-08-03T19:09:19.348Z">
  2.   <data name="xml_report">
  3.     <type name="xml" package="package0" />
  4.     <value>
  5.       <deadlock>
  6.         <victim-list>
  7.           <victimProcess id="process28eddf848" />
  8.         </victim-list>
  9.         <process-list>
  10.           <process id="process28eddf848" taskpriority="0" logused="0" waitresource="KEY: 10:72057596664479744 (94c1fc900c7f)" waittime="199" ownerId="5772022993" transactionname="user_transaction" lasttranstarted="2016-08-03T19:09:19.140" XDES="0xa2c7a03b0" lockMode="U" schedulerid="16" kpid="5264" status="suspended" spid="147" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-08-03T19:09:19.140" lastbatchcompleted="2016-08-03T19:09:19.130" lastattention="1900-01-01T00:00:00.130" clientapp=".Net SqlClient Data Provider" hostname="SERVER01" hostpid="22176" loginname="DOMAIN\user" isolationlevel="serializable (4)" xactid="5772022993" currentdb="10" lockTimeout="4294967295" clientoption1="671219744" clientoption2="128056">
  11.             <executionStack>
  12.               <frame procname="extremereach.AdServing.usp_MergeVideoAssets" line="11" stmtstart="482" stmtend="3474" sqlhandle="0x03000a00204159661a4bbb0057a6000001000000000000000000000000000000000000000000000000000000">
  13.                 MERGE INTO TargetTable WITH(HOLDLOCK) AS [target]
  14.                 USING @dataToMerge AS [source]
  15.                 ON [source].KeyPart_1 = [target].KeyPart_1 AND
  16.                 [source].KeyPart_2 = [target].KeyPart_2
  17.                 WHEN NOT MATCHED THEN
  18.                 INSERT(Data, KeyPart_1, KeyPart_2)
  19.                 VALUES([source].Data, [source].KeyPart_1, [source].KeyPart_2)
  20.                 WHEN MATCHED THEN
  21.                 UPDATE SET [target].Data = [source].Data,
  22.                 [target].KeyPart_1 = [source].KeyPart_1,
  23.                 [target].KeyPart_2 = [source].KeyPart_2;
  24.               </frame>
  25.             </executionStack>
  26.             <inputbuf>
  27.               Proc [Database Id = 10 Object Id = 1717125408]
  28.             </inputbuf>
  29.           </process>
  30.           <process id="process3889b2a4e8" taskpriority="0" logused="0" waitresource="OBJECT: 10:38499416:15 " waittime="199" ownerId="5772022992" transactionname="user_transaction" lasttranstarted="2016-08-03T19:09:19.140" XDES="0x524c8543b0" lockMode="X" schedulerid="11" kpid="5380" status="suspended" spid="468" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-08-03T19:09:19.140" lastbatchcompleted="2016-08-03T19:09:19.130" lastattention="2016-08-03T19:07:37.690" clientapp=".Net SqlClient Data Provider" hostname="SERVER02" hostpid="16592" loginname="DOMAIN\user" isolationlevel="serializable (4)" xactid="5772022992" currentdb="10" lockTimeout="4294967295" clientoption1="671219744" clientoption2="128056">
  31.             <executionStack>
  32.               <frame procname="extremereach.AdServing.usp_MergeVideoAssets" line="11" stmtstart="482" stmtend="3474" sqlhandle="0x03000a00204159661a4bbb0057a6000001000000000000000000000000000000000000000000000000000000">
  33.                 MERGE INTO TargetTable WITH(HOLDLOCK) AS [target]
  34.                 USING @dataToMerge AS [source]
  35.                 ON [source].KeyPart_1 = [target].KeyPart_1 AND
  36.                 [source].KeyPart_2 = [target].KeyPart_2
  37.                 WHEN NOT MATCHED THEN
  38.                 INSERT(Data, KeyPart_1, KeyPart_2)
  39.                 VALUES([source].Data, [source].KeyPart_1, [source].KeyPart_2)
  40.                 WHEN MATCHED THEN
  41.                 UPDATE SET [target].Data = [source].Data,
  42.                 [target].KeyPart_1 = [source].KeyPart_1,
  43.                 [target].KeyPart_2 = [source].KeyPart_2;
  44.               </frame>
  45.             </executionStack>
  46.             <inputbuf>
  47.               Proc [Database Id = 10 Object Id = 1717125408]
  48.             </inputbuf>
  49.           </process>
  50.         </process-list>
  51.         <resource-list>
  52.           <keylock hobtid="72057596664479744" dbid="10" objectname="TargetTable" indexname="AK_TargetTable_NaturalKey" id="lock253a8f2080" mode="U" associatedObjectId="72057596664479744">
  53.             <owner-list>
  54.               <owner id="process3889b2a4e8" mode="U" />
  55.             </owner-list>
  56.             <waiter-list>
  57.               <waiter id="process28eddf848" mode="U" requestType="wait" />
  58.             </waiter-list>
  59.           </keylock>
  60.           <objectlock lockPartition="15" objid="38499416" subresource="FULL" dbid="10" objectname="TargetTable" id="lock2a8cc13a00" mode="IX" associatedObjectId="38499416">
  61.             <owner-list>
  62.               <owner id="process28eddf848" mode="IX" />
  63.             </owner-list>
  64.             <waiter-list>
  65.               <waiter id="process3889b2a4e8" mode="X" requestType="wait" />
  66.             </waiter-list>
  67.           </objectlock>
  68.         </resource-list>
  69.       </deadlock>
  70.     </value>
  71.   </data>
  72. </event>
RAW Paste Data