Advertisement
eugene-gubenkov

Deadlock graph v2

Oct 4th, 2016
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 4.87 KB | None | 0 0
  1. <deadlock>
  2.   <victim-list>
  3.     <victimProcess id="process636fc02108" />
  4.   </victim-list>
  5.   <process-list>
  6.     <process id="process636fc02108" taskpriority="0" logused="1368" waitresource="KEY: 21:72057608416264192 (2a3545697c21)" waittime="1852" ownerId="5356964855" transactionname="user_transaction" lasttranstarted="2016-10-04T20:24:32.043" XDES="0x635ac34408" lockMode="U" schedulerid="3" kpid="17808" status="suspended" spid="245" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-10-04T20:24:32.040" lastbatchcompleted="2016-10-04T20:24:32.037" lastattention="1900-01-01T00:00:00.037"  hostpid="8508" isolationlevel="read committed (2)" xactid="5356964855" currentdb="21" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
  7.       <executionStack>
  8.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1776" sqlhandle="0x03001500baa90a169c1b420195a6000001000000000000000000000000000000000000000000000000000000">
  9. MERGE sync_publishers2 t
  10.     USING @ids s
  11.     ON s.[value] = t.sync_object_id
  12.         and t.sync_registered_object_type_id = @objectTypeId
  13.     WHEN MATCHED
  14.         THEN UPDATE
  15.             SET master_update_date = @date
  16.     WHEN NOT MATCHED
  17.         THEN INSERT
  18.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  19.             VALUES
  20.                  (s.[value], @objectTypeId, @date)    </frame>
  21.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__...__sync_tracking" line="20" stmtstart="836" stmtend="910" sqlhandle="0x030015002920337ec4b03f0195a6000000000000000000000000000000000000000000000000000000000000">
  22. exec SyncTracker_PublishEvent2 3, @id    </frame>
  23.         <frame procname="unknown" line="1" stmtstart="82" stmtend="332" sqlhandle="0x020000003a175e0512e645635a3af39b46c1452b5c76d9a90000000000000000000000000000000000000000">
  24. unknown    </frame>
  25.         <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  26. unknown    </frame>
  27.       </executionStack>
  28.     </process>
  29.     <process id="process5cc6226108" taskpriority="0" logused="9510988" waitresource="KEY: 21:72057608416264192 (b9b173bbe8d5)" waittime="1825" ownerId="5356962844" transactionname="UPDATE" lasttranstarted="2016-10-04T20:24:31.240" XDES="0x8f521b8408" lockMode="U" schedulerid="6" kpid="8344" status="suspended" spid="214" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-10-04T20:24:31.050" lastbatchcompleted="2016-10-04T20:24:31.043" lastattention="2016-10-04T20:24:13.560" hostpid="11524" isolationlevel="read committed (2)" xactid="5356962844" currentdb="21" lockTimeout="4294967295" clientoption1="673327200" clientoption2="390200">
  30.       <executionStack>
  31.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1776" sqlhandle="0x03001500baa90a169c1b420195a6000001000000000000000000000000000000000000000000000000000000">
  32. MERGE sync_publishers2 t
  33.     USING @ids s
  34.     ON s.[value] = t.sync_object_id
  35.         and t.sync_registered_object_type_id = @objectTypeId
  36.     WHEN MATCHED
  37.         THEN UPDATE
  38.             SET master_update_date = @date
  39.     WHEN NOT MATCHED
  40.         THEN INSERT
  41.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  42.             VALUES
  43.                  (s.[value], @objectTypeId, @date)    </frame>
  44.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__...__sync_tracking" line="44" stmtstart="1712" stmtend="1800" sqlhandle="0x03001500f287690e0ab13f0195a6000000000000000000000000000000000000000000000000000000000000">
  45. exec SyncTracker_PublishEvent2 2, @advisorId    </frame>
  46.         <frame procname="unknown" line="1" stmtend="132" sqlhandle="0x02000000f872092b3935ee29db994256b1ec918e06955cde0000000000000000000000000000000000000000">
  47. unknown    </frame>
  48.       </executionStack>
  49.     </process>
  50.   </process-list>
  51.   <resource-list>
  52.     <keylock hobtid="72057608416264192" dbid="21" objectname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.sync_publishers2" indexname="PK__sync_publishers2" id="lock6037cd2c00" mode="X" associatedObjectId="72057608416264192">
  53.       <owner-list>
  54.         <owner id="process5cc6226108" mode="X" />
  55.       </owner-list>
  56.       <waiter-list>
  57.         <waiter id="process636fc02108" mode="U" requestType="wait" />
  58.       </waiter-list>
  59.     </keylock>
  60.     <keylock hobtid="72057608416264192" dbid="21" objectname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.sync_publishers2" indexname="PK__sync_publishers2" id="lock60c5e5da00" mode="U" associatedObjectId="72057608416264192">
  61.       <owner-list>
  62.         <owner id="process636fc02108" mode="U" />
  63.       </owner-list>
  64.       <waiter-list>
  65.         <waiter id="process5cc6226108" mode="U" requestType="wait" />
  66.       </waiter-list>
  67.     </keylock>
  68.   </resource-list>
  69. </deadlock>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement