﻿<deadlock>
 <victim-list>
  <victimProcess id="process1e3f6929468" />
 </victim-list>
 <process-list>
  <process id="process1e3f6929468" taskpriority="0" logused="0" waitresource="PAGE: 5:1:1425968 " waittime="10616" ownerId="10074420" transactionname="DELETE" lasttranstarted="2020-06-23T02:02:02.060" XDES="0x1e3f5ead020" lockMode="U" schedulerid="15" kpid="16452" status="suspended" spid="57" sbid="0" ecid="21" priority="0" trancount="0" lastbatchstarted="2020-06-23T02:02:00.873" lastbatchcompleted="2020-06-23T02:02:00.860" lastattention="1900-01-01T00:00:00.860" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" isolationlevel="read committed (2)" xactid="10074420" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtend="7010" sqlhandle="0x02000000e92a342955f67f439297b45a291f50e035b9875a0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
DELETE FROM idata_114 WHERE (item_id=100 AND idata_timestamp&lt;1585116120) OR (item_id=101 AND idata_timestamp&lt;1585116120) OR (item_id=104 AND idata_timestamp&lt;1585116120) OR (item_id=105 AND idata_timestamp&lt;1585116120) OR (item_id=107 AND idata_timestamp&lt;1585116120) OR (item_id=108 AND idata_timestamp&lt;1585116120) OR (item_id=109 AND idata_timestamp&lt;1585116120) OR (item_id=110 AND idata_timestamp&lt;1585116120) OR (item_id=112 AND idata_timestamp&lt;1585116120) OR (item_id=113 AND idata_timestamp&lt;1585116120) OR (item_id=115 AND idata_timestamp&lt;1585116120) OR (item_id=116 AND idata_timestamp&lt;1585116120) OR (item_id=117 AND idata_timestamp&lt;1585116120) OR (item_id=118 AND idata_timestamp&lt;1585116120) OR (item_id=119 AND idata_timestamp&lt;1585116120) OR (item_id=120 AND idata_timestamp&lt;1585116120) OR (item_id=122 AND idata_timestamp&lt;1585116120) OR (item_id=14185 AND idata_timestamp&lt;1585116120) OR (item_id=14294 AND idata_timestamp&lt;1585116120) OR (item_id=18794 AND idata_timestamp&lt;1585116120) OR (item_id=18795 AND idata_time   </inputbuf>
  </process>
  <process id="process1e3f604fc28" taskpriority="0" logused="10000" waittime="4542" schedulerid="7" kpid="16584" status="suspended" spid="57" sbid="0" ecid="7" priority="0" trancount="0" lastbatchstarted="2020-06-23T02:02:00.873" lastbatchcompleted="2020-06-23T02:02:00.860" lastattention="1900-01-01T00:00:00.860" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" isolationlevel="read committed (2)" xactid="10074420" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtend="7010" sqlhandle="0x02000000e92a342955f67f439297b45a291f50e035b9875a0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
DELETE FROM idata_114 WHERE (item_id=100 AND idata_timestamp&lt;1585116120) OR (item_id=101 AND idata_timestamp&lt;1585116120) OR (item_id=104 AND idata_timestamp&lt;1585116120) OR (item_id=105 AND idata_timestamp&lt;1585116120) OR (item_id=107 AND idata_timestamp&lt;1585116120) OR (item_id=108 AND idata_timestamp&lt;1585116120) OR (item_id=109 AND idata_timestamp&lt;1585116120) OR (item_id=110 AND idata_timestamp&lt;1585116120) OR (item_id=112 AND idata_timestamp&lt;1585116120) OR (item_id=113 AND idata_timestamp&lt;1585116120) OR (item_id=115 AND idata_timestamp&lt;1585116120) OR (item_id=116 AND idata_timestamp&lt;1585116120) OR (item_id=117 AND idata_timestamp&lt;1585116120) OR (item_id=118 AND idata_timestamp&lt;1585116120) OR (item_id=119 AND idata_timestamp&lt;1585116120) OR (item_id=120 AND idata_timestamp&lt;1585116120) OR (item_id=122 AND idata_timestamp&lt;1585116120) OR (item_id=14185 AND idata_timestamp&lt;1585116120) OR (item_id=14294 AND idata_timestamp&lt;1585116120) OR (item_id=18794 AND idata_timestamp&lt;1585116120) OR (item_id=18795 AND idata_time   </inputbuf>
  </process>
  <process id="process1e3f602f848" taskpriority="0" logused="10000" waittime="9271" schedulerid="3" kpid="8784" status="suspended" spid="57" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-06-23T02:02:00.873" lastbatchcompleted="2020-06-23T02:02:00.860" lastattention="1900-01-01T00:00:00.860" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" loginname="CAMPUSDOOR\monitor" isolationlevel="read committed (2)" xactid="10074420" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtend="7010" sqlhandle="0x02000000e92a342955f67f439297b45a291f50e035b9875a0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
DELETE FROM idata_114 WHERE (item_id=100 AND idata_timestamp&lt;1585116120) OR (item_id=101 AND idata_timestamp&lt;1585116120) OR (item_id=104 AND idata_timestamp&lt;1585116120) OR (item_id=105 AND idata_timestamp&lt;1585116120) OR (item_id=107 AND idata_timestamp&lt;1585116120) OR (item_id=108 AND idata_timestamp&lt;1585116120) OR (item_id=109 AND idata_timestamp&lt;1585116120) OR (item_id=110 AND idata_timestamp&lt;1585116120) OR (item_id=112 AND idata_timestamp&lt;1585116120) OR (item_id=113 AND idata_timestamp&lt;1585116120) OR (item_id=115 AND idata_timestamp&lt;1585116120) OR (item_id=116 AND idata_timestamp&lt;1585116120) OR (item_id=117 AND idata_timestamp&lt;1585116120) OR (item_id=118 AND idata_timestamp&lt;1585116120) OR (item_id=119 AND idata_timestamp&lt;1585116120) OR (item_id=120 AND idata_timestamp&lt;1585116120) OR (item_id=122 AND idata_timestamp&lt;1585116120) OR (item_id=14185 AND idata_timestamp&lt;1585116120) OR (item_id=14294 AND idata_timestamp&lt;1585116120) OR (item_id=18794 AND idata_timestamp&lt;1585116120) OR (item_id=18795 AND idata_time   </inputbuf>
  </process>
  <process id="process1e3f6037c28" taskpriority="0" logused="68088" waitresource="PAGE: 5:1:1034521 " waittime="8507" ownerId="10073429" transactionname="user_transaction" lasttranstarted="2020-06-23T02:01:56.930" XDES="0x1e3d2288bd0" lockMode="IX" schedulerid="4" kpid="9644" status="suspended" spid="51" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-06-23T02:02:04.190" lastbatchcompleted="2020-06-23T02:02:04.190" lastattention="1900-01-01T00:00:00.190" clientapp="NetXMS" hostname="MONITOR1" hostpid="8748" loginname="CAMPUSDOOR\monitor" isolationlevel="read committed (2)" xactid="10073429" currentdb="5" currentdbname="netxms" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="98" stmtend="292" sqlhandle="0x020000009faac92d57983106077c85cad1f7ff735531a29f0000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="240" sqlhandle="0x0200000052635c02918a12ed7180828353b76b62344f71300000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
INSERT INTO idata_114 (item_id,idata_timestamp,idata_value,raw_value) VALUES (115,1592892124,'17816956928','17816956928')   </inputbuf>
  </process>
 </process-list>
 <resource-list>
  <pagelock fileid="1" pageid="1425968" dbid="5" subresource="FULL" objectname="netxms.dbo.idata_114" id="lock1e2dfac4880" mode="IX" associatedObjectId="72057594049986560">
   <owner-list>
    <owner id="process1e3f6037c28" mode="IX" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f6929468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <exchangeEvent id="Pipe1e2722e6a50" WaitType="e_waitPipeNewRow" waiterType="Producer" nodeId="2" tid="7" ownerActivity="receivedData" waiterActivity="tryToSendData" merging="true" spilling="true" waitingToClose="true">
   <owner-list>
    <owner id="process1e3f602f848" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f604fc28" />
   </waiter-list>
  </exchangeEvent>
  <exchangeEvent id="Pipe1e273bbcbc0" WaitType="e_waitPipeGetRow" waiterType="Coordinator" nodeId="2" tid="0" ownerActivity="sentData" waiterActivity="needMoreData" merging="true" spilling="false" waitingToClose="false">
   <owner-list>
    <owner id="process1e3f6929468" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f602f848" />
   </waiter-list>
  </exchangeEvent>
  <pagelock fileid="1" pageid="1034521" dbid="5" subresource="FULL" objectname="netxms.dbo.idata_114" id="lock1e2d6ea3600" mode="U" associatedObjectId="72057594049986560">
   <owner-list>
    <owner id="process1e3f604fc28" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process1e3f6037c28" mode="IX" requestType="wait" />
   </waiter-list>
  </pagelock>
 </resource-list>
</deadlock>
