Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock>
- <victim-list>
- <victimProcess id="process636fc02108" />
- </victim-list>
- <process-list>
- <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">
- <executionStack>
- <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1776" sqlhandle="0x03001500baa90a169c1b420195a6000001000000000000000000000000000000000000000000000000000000">
- MERGE sync_publishers2 t
- USING @ids s
- ON s.[value] = t.sync_object_id
- and t.sync_registered_object_type_id = @objectTypeId
- WHEN MATCHED
- THEN UPDATE
- SET master_update_date = @date
- WHEN NOT MATCHED
- THEN INSERT
- (sync_object_id, sync_registered_object_type_id, master_update_date)
- VALUES
- (s.[value], @objectTypeId, @date) </frame>
- <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__...__sync_tracking" line="20" stmtstart="836" stmtend="910" sqlhandle="0x030015002920337ec4b03f0195a6000000000000000000000000000000000000000000000000000000000000">
- exec SyncTracker_PublishEvent2 3, @id </frame>
- <frame procname="unknown" line="1" stmtstart="82" stmtend="332" sqlhandle="0x020000003a175e0512e645635a3af39b46c1452b5c76d9a90000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- </process>
- <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">
- <executionStack>
- <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1776" sqlhandle="0x03001500baa90a169c1b420195a6000001000000000000000000000000000000000000000000000000000000">
- MERGE sync_publishers2 t
- USING @ids s
- ON s.[value] = t.sync_object_id
- and t.sync_registered_object_type_id = @objectTypeId
- WHEN MATCHED
- THEN UPDATE
- SET master_update_date = @date
- WHEN NOT MATCHED
- THEN INSERT
- (sync_object_id, sync_registered_object_type_id, master_update_date)
- VALUES
- (s.[value], @objectTypeId, @date) </frame>
- <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__...__sync_tracking" line="44" stmtstart="1712" stmtend="1800" sqlhandle="0x03001500f287690e0ab13f0195a6000000000000000000000000000000000000000000000000000000000000">
- exec SyncTracker_PublishEvent2 2, @advisorId </frame>
- <frame procname="unknown" line="1" stmtend="132" sqlhandle="0x02000000f872092b3935ee29db994256b1ec918e06955cde0000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- </process>
- </process-list>
- <resource-list>
- <keylock hobtid="72057608416264192" dbid="21" objectname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.sync_publishers2" indexname="PK__sync_publishers2" id="lock6037cd2c00" mode="X" associatedObjectId="72057608416264192">
- <owner-list>
- <owner id="process5cc6226108" mode="X" />
- </owner-list>
- <waiter-list>
- <waiter id="process636fc02108" mode="U" requestType="wait" />
- </waiter-list>
- </keylock>
- <keylock hobtid="72057608416264192" dbid="21" objectname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.sync_publishers2" indexname="PK__sync_publishers2" id="lock60c5e5da00" mode="U" associatedObjectId="72057608416264192">
- <owner-list>
- <owner id="process636fc02108" mode="U" />
- </owner-list>
- <waiter-list>
- <waiter id="process5cc6226108" mode="U" requestType="wait" />
- </waiter-list>
- </keylock>
- </resource-list>
- </deadlock>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement