API tools faq
paste
eugene-gubenkov

deadlock v3

eugene-gubenkov
Jan 4th, 2017
482
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 20.07 KB | None | 0 0
raw download clone embed print report
  1. <deadlock>
  2.   <victim-list>
  3.     <victimProcess id="process861129bc28" />
  4.   </victim-list>
  5.   <process-list>
  6.     <process id="process861129bc28" taskpriority="0" logused="288" waitresource="PAGE: 21:1:17410848 " waittime="53851" ownerId="5690290097" transactionname="UPDATE" lasttranstarted="2016-10-05T17:46:38.787" XDES="0x8d51f8d980" lockMode="X" schedulerid="2" kpid="61216" status="suspended" spid="173" sbid="0" ecid="4" priority="0" trancount="0" lastbatchstarted="2016-10-05T17:46:38.783" lastbatchcompleted="2016-10-05T17:46:38.677" lastattention="1900-01-01T00:00:00.677" clientapp="Microsoft SQL Server Management Studio - Query" hostname="CRGDEV-VMEG" hostpid="16268" isolationlevel="read committed (2)" xactid="5690290097" currentdb="21" lockTimeout="4294967295" clientoption1="673327200" clientoption2="390200">
  7.       <executionStack>
  8.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  9. MERGE sync_publishers2 with(xlock, holdlock) 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__notes__sync_tracking" line="27" stmtstart="1226" stmtend="1300" sqlhandle="0x0300150083bcad022b50220196a6000000000000000000000000000000000000000000000000000000000000">
  22. exec SyncTracker_PublishEvent2 2, @id    </frame>
  23.         <frame procname="unknown" line="1" stmtend="92" sqlhandle="0x02000000cc9ad839ca6b35cb073f947c4b4e3370d10123820000000000000000000000000000000000000000">
  24. unknown    </frame>
  25.       </executionStack>
  26.       <inputbuf>
  27. update top(1)
  28. notes
  29. set note_text = note_text   </inputbuf>
  30.     </process>
  31.     <process id="process861129a108" taskpriority="0" logused="10000" waittime="53851" schedulerid="2" kpid="47792" status="suspended" spid="173" sbid="0" ecid="1" priority="0" trancount="0" lastbatchstarted="2016-10-05T17:46:38.783" lastbatchcompleted="2016-10-05T17:46:38.677" lastattention="1900-01-01T00:00:00.677" clientapp="Microsoft SQL Server Management Studio - Query" hostname="CRGDEV-VMEG" hostpid="16268" isolationlevel="read committed (2)" xactid="5690290097" currentdb="21" lockTimeout="4294967295" clientoption1="673327200" clientoption2="390200">
  32.       <executionStack>
  33.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  34. MERGE sync_publishers2 with(xlock, holdlock) t
  35.     USING @ids s
  36.     ON s.[value] = t.sync_object_id
  37.         and t.sync_registered_object_type_id = @objectTypeId
  38.     WHEN MATCHED
  39.         THEN UPDATE
  40.             SET master_update_date = @date
  41.     WHEN NOT MATCHED
  42.         THEN INSERT
  43.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  44.             VALUES
  45.                  (s.[value], @objectTypeId, @date)    </frame>
  46.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__notes__sync_tracking" line="27" stmtstart="1226" stmtend="1300" sqlhandle="0x0300150083bcad022b50220196a6000000000000000000000000000000000000000000000000000000000000">
  47. exec SyncTracker_PublishEvent2 2, @id    </frame>
  48.         <frame procname="unknown" line="1" stmtend="92" sqlhandle="0x02000000cc9ad839ca6b35cb073f947c4b4e3370d10123820000000000000000000000000000000000000000">
  49. unknown    </frame>
  50.       </executionStack>
  51.       <inputbuf>
  52. update top(1)
  53. notes
  54. set note_text = note_text   </inputbuf>
  55.     </process>
  56.     <process id="process5cf345c108" taskpriority="0" logused="10000" waittime="53851" schedulerid="2" kpid="9548" status="suspended" spid="173" sbid="0" ecid="6" priority="0" trancount="0" lastbatchstarted="2016-10-05T17:46:38.783" lastbatchcompleted="2016-10-05T17:46:38.677" lastattention="1900-01-01T00:00:00.677" clientapp="Microsoft SQL Server Management Studio - Query" hostname="CRGDEV-VMEG" hostpid="16268" isolationlevel="read committed (2)" xactid="5690290097" currentdb="21" lockTimeout="4294967295" clientoption1="673327200" clientoption2="390200">
  57.       <executionStack>
  58.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  59. MERGE sync_publishers2 with(xlock, holdlock) t
  60.     USING @ids s
  61.     ON s.[value] = t.sync_object_id
  62.         and t.sync_registered_object_type_id = @objectTypeId
  63.     WHEN MATCHED
  64.         THEN UPDATE
  65.             SET master_update_date = @date
  66.     WHEN NOT MATCHED
  67.         THEN INSERT
  68.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  69.             VALUES
  70.                  (s.[value], @objectTypeId, @date)    </frame>
  71.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__notes__sync_tracking" line="27" stmtstart="1226" stmtend="1300" sqlhandle="0x0300150083bcad022b50220196a6000000000000000000000000000000000000000000000000000000000000">
  72. exec SyncTracker_PublishEvent2 2, @id    </frame>
  73.         <frame procname="unknown" line="1" stmtend="92" sqlhandle="0x02000000cc9ad839ca6b35cb073f947c4b4e3370d10123820000000000000000000000000000000000000000">
  74. unknown    </frame>
  75.       </executionStack>
  76.       <inputbuf>
  77. update top(1)
  78. notes
  79. set note_text = note_text   </inputbuf>
  80.     </process>
  81.     <process id="process636ee1b848" taskpriority="0" logused="10000" waittime="53851" schedulerid="5" kpid="64312" status="suspended" spid="173" sbid="0" ecid="2" priority="0" trancount="0" lastbatchstarted="2016-10-05T17:46:38.783" lastbatchcompleted="2016-10-05T17:46:38.677" lastattention="1900-01-01T00:00:00.677" clientapp="Microsoft SQL Server Management Studio - Query" hostname="CRGDEV-VMEG" hostpid="16268" isolationlevel="read committed (2)" xactid="5690290097" currentdb="21" lockTimeout="4294967295" clientoption1="673327200" clientoption2="390200">
  82.       <executionStack>
  83.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  84. MERGE sync_publishers2 with(xlock, holdlock) t
  85.     USING @ids s
  86.     ON s.[value] = t.sync_object_id
  87.         and t.sync_registered_object_type_id = @objectTypeId
  88.     WHEN MATCHED
  89.         THEN UPDATE
  90.             SET master_update_date = @date
  91.     WHEN NOT MATCHED
  92.         THEN INSERT
  93.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  94.             VALUES
  95.                  (s.[value], @objectTypeId, @date)    </frame>
  96.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__notes__sync_tracking" line="27" stmtstart="1226" stmtend="1300" sqlhandle="0x0300150083bcad022b50220196a6000000000000000000000000000000000000000000000000000000000000">
  97. exec SyncTracker_PublishEvent2 2, @id    </frame>
  98.         <frame procname="unknown" line="1" stmtend="92" sqlhandle="0x02000000cc9ad839ca6b35cb073f947c4b4e3370d10123820000000000000000000000000000000000000000">
  99. unknown    </frame>
  100.       </executionStack>
  101.       <inputbuf>
  102. update top(1)
  103. notes
  104. set note_text = note_text   </inputbuf>
  105.     </process>
  106.     <process id="process5cf345c4e8" taskpriority="0" logused="10000" waittime="53851" schedulerid="2" kpid="55040" status="suspended" spid="173" sbid="0" ecid="7" priority="0" trancount="0" lastbatchstarted="2016-10-05T17:46:38.783" lastbatchcompleted="2016-10-05T17:46:38.677" lastattention="1900-01-01T00:00:00.677" clientapp="Microsoft SQL Server Management Studio - Query" hostname="CRGDEV-VMEG" hostpid="16268" isolationlevel="read committed (2)" xactid="5690290097" currentdb="21" lockTimeout="4294967295" clientoption1="673327200" clientoption2="390200">
  107.       <executionStack>
  108.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  109. MERGE sync_publishers2 with(xlock, holdlock) t
  110.     USING @ids s
  111.     ON s.[value] = t.sync_object_id
  112.         and t.sync_registered_object_type_id = @objectTypeId
  113.     WHEN MATCHED
  114.         THEN UPDATE
  115.             SET master_update_date = @date
  116.     WHEN NOT MATCHED
  117.         THEN INSERT
  118.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  119.             VALUES
  120.                  (s.[value], @objectTypeId, @date)    </frame>
  121.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__notes__sync_tracking" line="27" stmtstart="1226" stmtend="1300" sqlhandle="0x0300150083bcad022b50220196a6000000000000000000000000000000000000000000000000000000000000">
  122. exec SyncTracker_PublishEvent2 2, @id    </frame>
  123.         <frame procname="unknown" line="1" stmtend="92" sqlhandle="0x02000000cc9ad839ca6b35cb073f947c4b4e3370d10123820000000000000000000000000000000000000000">
  124. unknown    </frame>
  125.       </executionStack>
  126.       <inputbuf>
  127. update top(1)
  128. notes
  129. set note_text = note_text   </inputbuf>
  130.     </process>
  131.     <process id="process634ccf8ca8" taskpriority="0" logused="10000" waittime="53851" schedulerid="2" kpid="10368" status="suspended" spid="173" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-10-05T17:46:38.783" lastbatchcompleted="2016-10-05T17:46:38.677" lastattention="1900-01-01T00:00:00.677" clientapp="Microsoft SQL Server Management Studio - Query" hostname="CRGDEV-VMEG" hostpid="16268" loginname="superadminuseraccount" isolationlevel="read committed (2)" xactid="5690290097" currentdb="21" lockTimeout="4294967295" clientoption1="673327200" clientoption2="390200">
  132.       <executionStack>
  133.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  134. MERGE sync_publishers2 with(xlock, holdlock) t
  135.     USING @ids s
  136.     ON s.[value] = t.sync_object_id
  137.         and t.sync_registered_object_type_id = @objectTypeId
  138.     WHEN MATCHED
  139.         THEN UPDATE
  140.             SET master_update_date = @date
  141.     WHEN NOT MATCHED
  142.         THEN INSERT
  143.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  144.             VALUES
  145.                  (s.[value], @objectTypeId, @date)    </frame>
  146.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__notes__sync_tracking" line="27" stmtstart="1226" stmtend="1300" sqlhandle="0x0300150083bcad022b50220196a6000000000000000000000000000000000000000000000000000000000000">
  147. exec SyncTracker_PublishEvent2 2, @id    </frame>
  148.         <frame procname="unknown" line="1" stmtend="92" sqlhandle="0x02000000cc9ad839ca6b35cb073f947c4b4e3370d10123820000000000000000000000000000000000000000">
  149. unknown    </frame>
  150.       </executionStack>
  151.       <inputbuf>
  152. update top(1)
  153. notes
  154. set note_text = note_text   </inputbuf>
  155.     </process>
  156.     <process id="process90763f04e8" taskpriority="0" logused="977112" waitresource="PAGE: 21:1:17432110 " waittime="2334" ownerId="5690195104" transactionname="user_transaction" lasttranstarted="2016-10-05T17:45:12.017" XDES="0xa57d0d8408" lockMode="X" schedulerid="6" kpid="8420" status="suspended" spid="209" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-10-05T17:45:12.070" lastbatchcompleted="2016-10-05T17:45:12.017" lastattention="1900-01-01T00:00:00.017" clientapp="SchedulerAdmin" hostname="RD0003FF71F731" hostpid="1828" loginname="kbuser" isolationlevel="read committed (2)" xactid="5690195104" currentdb="21" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
  157.       <executionStack>
  158.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  159. MERGE sync_publishers2 with(xlock, holdlock) t
  160.     USING @ids s
  161.     ON s.[value] = t.sync_object_id
  162.         and t.sync_registered_object_type_id = @objectTypeId
  163.     WHEN MATCHED
  164.         THEN UPDATE
  165.             SET master_update_date = @date
  166.     WHEN NOT MATCHED
  167.         THEN INSERT
  168.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  169.             VALUES
  170.                  (s.[value], @objectTypeId, @date)    </frame>
  171.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__dim_analysts_advanced__sync_tracking" line="22" stmtstart="680" stmtend="756" sqlhandle="0x030015006607e97d1650220196a6000000000000000000000000000000000000000000000000000000000000">
  172. exec SyncTracker_PublishEvent2 15, @id    </frame>
  173.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.spDimAnalystAdvancedUpdateXml" line="38" stmtstart="2166" stmtend="4186" sqlhandle="0x0300150025b34a3887b3d50096a6000001000000000000000000000000000000000000000000000000000000">
  174. MERGE INTO dbo.dim_analysts_advanced AS D
  175. USING @tmp AS T ON T.contact_id = D.contact_id
  176. WHEN MATCHED THEN
  177.     UPDATE SET
  178.      D.contact_id                            = T.contact_id    
  179.     ,D.client_id                             = T.client_id     
  180.     ,D.entity_id                             = T.entity_id                         
  181.     ,D.first_name                            = T.first_name                        
  182.     ,D.last_name                             = T.last_name                         
  183.     ,D.last_call_date                        = T.last_call_date                    
  184.     ,D.scheduled_count                       = T.scheduled_count                           
  185.     ,D.pending_count                         = T.pending_count
  186.     ,D.contact_role_id                       = T.contact_role_id
  187.     ,D.active                                = T.active
  188.                
  189.  
  190. WHEN NOT MATCHED BY TARGET THEN
  191.     INSERT (
  192.         contact_id     
  193.         ,client_id     
  194.         ,entity_id     
  195.         ,first_name    
  196.         ,last_name     
  197.         ,last_call_date
  198.         ,scheduled_count   
  199.         ,pending_count
  200.         ,contact_role_id
  201.         ,active            
  202.  
  203.     ) VALUES (
  204.          T.contact_id      
  205.         ,T.client_id       
  206.         ,T.entity_id       
  207.         ,T.first_name      
  208.         ,T.last_name       
  209.         ,T.last_call_date  
  210.         ,T.scheduled_count 
  211.         ,T.pending_count           
  212.         ,T.contact_role_id
  213.         ,T.active  
  214. )    </frame>
  215.       </executionStack>
  216.       <inputbuf>
  217. Proc [Database Id = 21 Object Id = 944419621]   </inputbuf>
  218.     </process>
  219.     <process id="process90763f08c8" taskpriority="0" logused="12972244" waitresource="PAGE: 21:1:17410848 " waittime="77148" ownerId="5690226552" transactionname="user_transaction" lasttranstarted="2016-10-05T17:45:31.830" XDES="0xa57b034408" lockMode="X" schedulerid="6" kpid="62376" status="suspended" spid="216" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-10-05T17:45:32.397" lastbatchcompleted="2016-10-05T17:45:31.830" lastattention="1900-01-01T00:00:00.830" clientapp="SchedulerAdmin" hostname="RD0003FF71F731" hostpid="1828" loginname="kbuser" isolationlevel="read committed (2)" xactid="5690226552" currentdb="21" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
  220.       <executionStack>
  221.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.SyncTracker_PublishEvent2" line="19" stmtstart="954" stmtend="1820" sqlhandle="0x03001500d57d1166c24b220196a6000001000000000000000000000000000000000000000000000000000000">
  222. MERGE sync_publishers2 with(xlock, holdlock) t
  223.     USING @ids s
  224.     ON s.[value] = t.sync_object_id
  225.         and t.sync_registered_object_type_id = @objectTypeId
  226.     WHEN MATCHED
  227.         THEN UPDATE
  228.             SET master_update_date = @date
  229.     WHEN NOT MATCHED
  230.         THEN INSERT
  231.                  (sync_object_id, sync_registered_object_type_id, master_update_date)
  232.             VALUES
  233.                  (s.[value], @objectTypeId, @date)    </frame>
  234.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.TR__dim_advisors_advanced__sync_tracking" line="21" stmtstart="676" stmtend="750" sqlhandle="0x030015002de3f47c1250220196a6000000000000000000000000000000000000000000000000000000000000">
  235. exec SyncTracker_PublishEvent2 9, @id    </frame>
  236.         <frame procname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.spDimAdvisorAdvancedUpdateXml" line="207" stmtstart="21270" stmtend="41018" sqlhandle="0x03001500cfd9913254b3d50096a6000001000000000000000000000000000000000000000000000000000000">
  237. MERGE INTO dbo.dim_advisors_advanced AS D
  238. USING @tmp AS T ON T.advisor_id = D.advisor_id
  239. WHEN MATCHED THEN
  240.     UPDATE SET
  241.      D.isProspect                   = T.isProspect
  242.     ,D.active                       = T.active
  243.     ,D.doNotUse                     = T.doNotUse
  244.     ,D.doNotUseReason               = T.doNotUseReason
  245.     ,D.dateOfReactivation           = T.dateOfReactivation
  246.     ,D.country                      = T.country                    
  247.     ,D.firstName                    = T.firstName                      
  248.     ,D.lastName                     = T.lastName                       
  249.     ,D.email                        = T.email                          
  250.     ,D.title                        = T.title                          
  251.     ,D.currentTitle                 = T.currentTitle                   
  252.     ,D.pastTitle                    = T.pastTitle                      
  253.     ,D.employers                    = T.employers                      
  254.     ,D.currentEmployers             = T.currentEmployers               
  255.     ,D.pastEmployers                = T.pastEmployers                  
  256.     ,D.companyExpertises            = T.companyExpertises              
  257.     ,D.keywords                     = T.keywords                       
  258.     ,D.notes                        = T.notes                          
  259.     ,D.historyNotes                 = T.historyNotes                   
  260.     ,D.editedBio                    = T.editedBio                      
  261.     ,D.displayText                  = T.displayText                
  262.     ,D.expertName                   = T.expertName                     
  263.     ,D.formerEmployerCompanyIDs    </frame>
  264.       </executionStack>
  265.       <inputbuf>
  266. Proc [Database Id = 21 Object Id = 848419279]   </inputbuf>
  267.     </process>
  268.   </process-list>
  269.   <resource-list>
  270.     <pagelock fileid="1" pageid="17410848" dbid="21" subresource="FULL" objectname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.sync_publishers2" id="lock630b1d5380" mode="X" associatedObjectId="72057608416264192">
  271.       <owner-list>
  272.         <owner id="process90763f08c8" mode="X" requestType="wait" />
  273.       </owner-list>
  274.       <waiter-list>
  275.         <waiter id="process861129bc28" mode="X" requestType="wait" />
  276.       </waiter-list>
  277.     </pagelock>
  278.     <exchangeEvent id="Port637bbcf200" WaitType="e_waitPortClose" nodeId="18">
  279.       <owner-list>
  280.         <owner id="process861129bc28" />
  281.       </owner-list>
  282.       <waiter-list>
  283.         <waiter id="process861129a108" />
  284.       </waiter-list>
  285.     </exchangeEvent>
  286.     <exchangeEvent id="Pipe98043a1180" WaitType="e_waitPipeGetRow" nodeId="8">
  287.       <owner-list>
  288.         <owner id="process5cf345c4e8" />
  289.       </owner-list>
  290.       <waiter-list>
  291.         <waiter id="process5cf345c108" />
  292.       </waiter-list>
  293.     </exchangeEvent>
  294.     <exchangeEvent id="Port637bbcf200" WaitType="e_waitPortClose" nodeId="18">
  295.       <owner-list>
  296.         <owner id="process861129bc28" />
  297.       </owner-list>
  298.       <waiter-list>
  299.         <waiter id="process636ee1b848" />
  300.       </waiter-list>
  301.     </exchangeEvent>
  302.     <exchangeEvent id="Pipe98043a1580" WaitType="e_waitPipeGetRow" nodeId="12">
  303.       <owner-list>
  304.         <owner id="process861129a108" />
  305.         <owner id="process636ee1b848" />
  306.       </owner-list>
  307.       <waiter-list>
  308.         <waiter id="process5cf345c4e8" />
  309.       </waiter-list>
  310.     </exchangeEvent>
  311.     <exchangeEvent id="Port637bbce700" WaitType="e_waitPortOpen" nodeId="5">
  312.       <owner-list>
  313.         <owner id="process5cf345c108" />
  314.       </owner-list>
  315.       <waiter-list>
  316.         <waiter id="process634ccf8ca8" />
  317.       </waiter-list>
  318.     </exchangeEvent>
  319.     <pagelock fileid="1" pageid="17432110" dbid="21" subresource="FULL" objectname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.sync_publishers2" id="lock6318ffe600" mode="X" associatedObjectId="72057608416264192">
  320.       <owner-list>
  321.         <owner id="process634ccf8ca8" mode="X" />
  322.       </owner-list>
  323.       <waiter-list>
  324.         <waiter id="process90763f04e8" mode="X" requestType="wait" />
  325.       </waiter-list>
  326.     </pagelock>
  327.     <pagelock fileid="1" pageid="17410848" dbid="21" subresource="FULL" objectname="33bd93e0-f5b2-43f6-93ca-56bbe6493e0c.dbo.sync_publishers2" id="lock630b1d5380" mode="X" associatedObjectId="72057608416264192">
  328.       <owner-list>
  329.         <owner id="process90763f04e8" mode="X" />
  330.       </owner-list>
  331.       <waiter-list>
  332.         <waiter id="process90763f08c8" mode="X" requestType="wait" />
  333.       </waiter-list>
  334.     </pagelock>
  335.   </resource-list>
  336. </deadlock>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!