﻿<deadlock>
 <victim-list>
  <victimProcess id="process1e3f6969848" />
 </victim-list>
 <process-list>
  <process id="process1e3f6969848" taskpriority="0" logused="6192" waitresource="PAGE: 5:1:1405707 " waittime="8695" ownerId="10127059" transactionname="user_transaction" lasttranstarted="2020-06-23T02:11:14.750" XDES="0x1e3ee1d4910" lockMode="IX" schedulerid="23" kpid="2544" status="suspended" spid="55" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-06-23T02:11:15.760" lastbatchcompleted="2020-06-23T02:11:15.760" lastattention="1900-01-01T00:00:00.760" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" loginname="CAMPUSDOOR\monitor" isolationlevel="read committed (2)" xactid="10127059" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="98" stmtend="294" sqlhandle="0x020000003e4d2b1ad6d052f85d4ee2831814cedcb3d912610000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="218" sqlhandle="0x020000000989180dd76ed19bbc106cfb9422af3e3a22c6390000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
INSERT INTO idata_2637 (item_id,idata_timestamp,idata_value,raw_value) VALUES (24774,1592892675,'Enabled','1')   </inputbuf>
  </process>
  <process id="process1e3f6921c28" taskpriority="0" logused="10000" waittime="4046" schedulerid="14" kpid="17296" status="suspended" spid="57" sbid="0" ecid="23" priority="0" trancount="0" lastbatchstarted="2020-06-23T02:11:09.990" lastbatchcompleted="2020-06-23T02:11:09.987" lastattention="1900-01-01T00:00:00.987" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" isolationlevel="read committed (2)" xactid="10126913" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtend="7324" sqlhandle="0x020000003987653861ae790d3f9232b3cd45a7e5665ed1ca0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
DELETE FROM idata_2637 WHERE (item_id=1817 AND idata_timestamp&lt;1585116669) OR (item_id=1818 AND idata_timestamp&lt;1585116669) OR (item_id=1819 AND idata_timestamp&lt;1585116669) OR (item_id=1822 AND idata_timestamp&lt;1585116669) OR (item_id=1823 AND idata_timestamp&lt;1585116669) OR (item_id=1824 AND idata_timestamp&lt;1585116669) OR (item_id=1825 AND idata_timestamp&lt;1585116669) OR (item_id=1828 AND idata_timestamp&lt;1585116669) OR (item_id=1829 AND idata_timestamp&lt;1585116669) OR (item_id=1830 AND idata_timestamp&lt;1585116669) OR (item_id=1831 AND idata_timestamp&lt;1585116669) OR (item_id=1970 AND idata_timestamp&lt;1585116669) OR (item_id=24756 AND idata_timestamp&lt;1585116669) OR (item_id=24757 AND idata_timestamp&lt;1585116669) OR (item_id=24758 AND idata_timestamp&lt;1585116669) OR (item_id=24759 AND idata_timestamp&lt;1585116669) OR (item_id=24760 AND idata_timestamp&lt;1585116669) OR (item_id=24761 AND idata_timestamp&lt;1585116669) OR (item_id=24762 AND idata_timestamp&lt;1585116669) OR (item_id=24763 AND idata_timestamp&lt;1585116669) OR (item_   </inputbuf>
  </process>
  <process id="process1e3f602f848" taskpriority="0" logused="10000" waittime="8546" schedulerid="3" kpid="8784" status="suspended" spid="57" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-06-23T02:11:09.990" lastbatchcompleted="2020-06-23T02:11:09.987" lastattention="1900-01-01T00:00:00.987" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" loginname="CAMPUSDOOR\monitor" isolationlevel="read committed (2)" xactid="10126913" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtend="7324" sqlhandle="0x020000003987653861ae790d3f9232b3cd45a7e5665ed1ca0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
DELETE FROM idata_2637 WHERE (item_id=1817 AND idata_timestamp&lt;1585116669) OR (item_id=1818 AND idata_timestamp&lt;1585116669) OR (item_id=1819 AND idata_timestamp&lt;1585116669) OR (item_id=1822 AND idata_timestamp&lt;1585116669) OR (item_id=1823 AND idata_timestamp&lt;1585116669) OR (item_id=1824 AND idata_timestamp&lt;1585116669) OR (item_id=1825 AND idata_timestamp&lt;1585116669) OR (item_id=1828 AND idata_timestamp&lt;1585116669) OR (item_id=1829 AND idata_timestamp&lt;1585116669) OR (item_id=1830 AND idata_timestamp&lt;1585116669) OR (item_id=1831 AND idata_timestamp&lt;1585116669) OR (item_id=1970 AND idata_timestamp&lt;1585116669) OR (item_id=24756 AND idata_timestamp&lt;1585116669) OR (item_id=24757 AND idata_timestamp&lt;1585116669) OR (item_id=24758 AND idata_timestamp&lt;1585116669) OR (item_id=24759 AND idata_timestamp&lt;1585116669) OR (item_id=24760 AND idata_timestamp&lt;1585116669) OR (item_id=24761 AND idata_timestamp&lt;1585116669) OR (item_id=24762 AND idata_timestamp&lt;1585116669) OR (item_id=24763 AND idata_timestamp&lt;1585116669) OR (item_   </inputbuf>
  </process>
  <process id="process1e3f6938ca8" taskpriority="0" logused="845652" waitresource="PAGE: 5:1:1413583 " waittime="8880" ownerId="10126913" transactionname="DELETE" lasttranstarted="2020-06-23T02:11:13.733" XDES="0x1e3f5eb5020" lockMode="U" schedulerid="17" kpid="592" status="suspended" spid="57" sbid="0" ecid="15" priority="0" trancount="0" lastbatchstarted="2020-06-23T02:11:09.990" lastbatchcompleted="2020-06-23T02:11:09.987" lastattention="1900-01-01T00:00:00.987" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" isolationlevel="read committed (2)" xactid="10126913" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtend="7324" sqlhandle="0x020000003987653861ae790d3f9232b3cd45a7e5665ed1ca0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
DELETE FROM idata_2637 WHERE (item_id=1817 AND idata_timestamp&lt;1585116669) OR (item_id=1818 AND idata_timestamp&lt;1585116669) OR (item_id=1819 AND idata_timestamp&lt;1585116669) OR (item_id=1822 AND idata_timestamp&lt;1585116669) OR (item_id=1823 AND idata_timestamp&lt;1585116669) OR (item_id=1824 AND idata_timestamp&lt;1585116669) OR (item_id=1825 AND idata_timestamp&lt;1585116669) OR (item_id=1828 AND idata_timestamp&lt;1585116669) OR (item_id=1829 AND idata_timestamp&lt;1585116669) OR (item_id=1830 AND idata_timestamp&lt;1585116669) OR (item_id=1831 AND idata_timestamp&lt;1585116669) OR (item_id=1970 AND idata_timestamp&lt;1585116669) OR (item_id=24756 AND idata_timestamp&lt;1585116669) OR (item_id=24757 AND idata_timestamp&lt;1585116669) OR (item_id=24758 AND idata_timestamp&lt;1585116669) OR (item_id=24759 AND idata_timestamp&lt;1585116669) OR (item_id=24760 AND idata_timestamp&lt;1585116669) OR (item_id=24761 AND idata_timestamp&lt;1585116669) OR (item_id=24762 AND idata_timestamp&lt;1585116669) OR (item_id=24763 AND idata_timestamp&lt;1585116669) OR (item_   </inputbuf>
  </process>
 </process-list>
 <resource-list>
  <pagelock fileid="1" pageid="1405707" dbid="5" subresource="FULL" objectname="netxms.dbo.idata_2637" id="lock1e25b749580" mode="U" associatedObjectId="72057594076790784">
   <owner-list>
    <owner id="process1e3f6921c28" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f6969848" mode="IX" requestType="wait" />
   </waiter-list>
  </pagelock>
  <exchangeEvent id="Pipe1e282ce9010" WaitType="e_waitPipeNewRow" waiterType="Producer" nodeId="2" tid="24" ownerActivity="receivedData" waiterActivity="tryToSendData" merging="true" spilling="true" waitingToClose="true">
   <owner-list>
    <owner id="process1e3f602f848" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f6921c28" />
   </waiter-list>
  </exchangeEvent>
  <exchangeEvent id="Pipe1e256b1f410" WaitType="e_waitPipeGetRow" waiterType="Coordinator" nodeId="2" tid="0" ownerActivity="sentData" waiterActivity="needMoreData" merging="true" spilling="false" waitingToClose="false">
   <owner-list>
    <owner id="process1e3f6938ca8" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f602f848" />
   </waiter-list>
  </exchangeEvent>
  <pagelock fileid="1" pageid="1413583" dbid="5" subresource="FULL" objectname="netxms.dbo.idata_2637" id="lock1e3d729dd00" mode="IX" associatedObjectId="72057594076790784">
   <owner-list>
    <owner id="process1e3f6969848" mode="IX" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f6938ca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
 </resource-list>
</deadlock>
