Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15512

Zabbix Web Server constantly bogging down DB after upgrade to 4.0.3

    XMLWordPrintable

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 48, Jan 2019, Sprint 49 (Feb 2019)
    • Story Points:
      3

      Description

      We have just upgraded to Zabbix 4.0.3 from 3.0.6 and have noticed an issue with the upgrade. We are seeing that the Web servers are querying the DB very hard taking up most of the resources (ex: almost 100% on all our CPUs on the server which is 32 CPUs) . Here are some examples:

      09:24:27 # mysqladmin -i 1 processlist | grep zbxweb*
      | 1325211 | zabbix | custzbxweb.customer.com:52370 | zabbix | Query | 108 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1327267 | zabbix | custzbxweb.customer.com:56780 | zabbix | Query | 94 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1327734 | zabbix | custzbxweb.customer.com:57732 | zabbix | Query | 120 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1328559 | zabbix | custzbxweb.customer.com:59572 | zabbix | Query | 138 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1330183 | zabbix | custzbxweb.customer.com:35388 | zabbix | Query | 131 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1332374 | zabbix | custzbxweb.customer.com:40474 | zabbix | Sleep | 213 | | | 0.000 |
      | 1332741 | zabbix | custzbxweb.customer.com:41180 | zabbix | Query | 84 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1334149 | zabbix | custzbxweb.customer.com:43914 | zabbix | Sleep | 34 | | | 0.000 |
      | 1335087 | zabbix | custzbxweb.customer.com:46088 | zabbix | Sleep | 137 | | | 0.000 |
      | 1335230 | zabbix | custzbxweb.customer.com:46448 | zabbix | Sleep | 117 | | | 0.000 |
      | 1335568 | zabbix | custzbxweb.customer.com:47204 | zabbix | Query | 57 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1335725 | zabbix | custzbxweb.customer.com:47536 | zabbix | Sleep | 63 | | | 0.000 |
      | 1336033 | zabbix | custzbxweb.customer.com:48250 | zabbix | Query | 0 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1336065 | zabbix | custzbxweb.customer.com:48328 | zabbix | Sleep | 0 | | | 0.000 |
      | 1336106 | zabbix | custzbxweb.customer.com:48410 | zabbix | Query | 0 | Sending data | SELECT m.maintenanceid FROM maintenances m WHERE NOT EXISTS (SELECT NULL FROM maintenances_hosts mh, | 0.000 |
      | 1336249 | zabbix | custzbxweb.customer.com:40818 | zabbix | Sleep | 3 | | | 0.000 |
      | 1336252 | zabbix | custzbxweb.customer.com:40822 | zabbix | Sleep | 2 | | | 0.000 |
      | 1325211 | zabbix | custzbxweb.customer.com:52370 | zabbix | Query | 109 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1327267 | zabbix | custzbxweb.customer.com:56780 | zabbix | Query | 95 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1327734 | zabbix | custzbxweb.customer.com:57732 | zabbix | Query | 121 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1328559 | zabbix | custzbxweb.customer.com:59572 | zabbix | Query | 139 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1330183 | zabbix | custzbxweb.customer.com:35388 | zabbix | Query | 132 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1332374 | zabbix | custzbxweb.customer.com:40474 | zabbix | Sleep | 214 | | | 0.000 |
      | 1332741 | zabbix | custzbxweb.customer.com:41180 | zabbix | Query | 85 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1334149 | zabbix | custzbxweb.customer.com:43914 | zabbix | Sleep | 35 | | | 0.000 |
      | 1335087 | zabbix | custzbxweb.customer.com:46088 | zabbix | Sleep | 138 | | | 0.000 |
      | 1335230 | zabbix | custzbxweb.customer.com:46448 | zabbix | Sleep | 118 | | | 0.000 |
      | 1335568 | zabbix | custzbxweb.customer.com:47204 | zabbix | Query | 58 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1335725 | zabbix | custzbxweb.customer.com:47536 | zabbix | Sleep | 64 | | | 0.000 |
      | 1336033 | zabbix | custzbxweb.customer.com:48250 | zabbix | Query | 0 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1336106 | zabbix | custzbxweb.customer.com:48410 | zabbix | Query | 0 | Sending data | SELECT m.maintenanceid FROM maintenances m WHERE NOT EXISTS (SELECT NULL FROM maintenances_hosts mh, | 0.000 |
      | 1336252 | zabbix | custzbxweb.customer.com:40822 | zabbix | Sleep | 3 | | | 0.000 |
      | 1325211 | zabbix | custzbxweb.customer.com:52370 | zabbix | Query | 110 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1327267 | zabbix | custzbxweb.customer.com:56780 | zabbix | Query | 96 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1327734 | zabbix | custzbxweb.customer.com:57732 | zabbix | Query | 122 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1328559 | zabbix | custzbxweb.customer.com:59572 | zabbix | Query | 140 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1330183 | zabbix | custzbxweb.customer.com:35388 | zabbix | Query | 133 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1332374 | zabbix | custzbxweb.customer.com:40474 | zabbix | Sleep | 215 | | | 0.000 |
      | 1332741 | zabbix | custzbxweb.customer.com:41180 | zabbix | Query | 86 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1334149 | zabbix | custzbxweb.customer.com:43914 | zabbix | Sleep | 36 | | | 0.000 |
      | 1335087 | zabbix | custzbxweb.customer.com:46088 | zabbix | Sleep | 139 | | | 0.000 |
      | 1335230 | zabbix | custzbxweb.customer.com:46448 | zabbix | Sleep | 119 | | | 0.000 |
      | 1335568 | zabbix | custzbxweb.customer.com:47204 | zabbix | Query | 59 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      | 1335725 | zabbix | custzbxweb.customer.com:47536 | zabbix | Sleep | 65 | | | 0.000 |
      | 1336033 | zabbix | custzbxweb.customer.com:48250 | zabbix | Query | 0 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
      

      innotop

      ID User Host Txn Status Time Undo Query Text
      1328559 zabbix custzbxweb ACTIVE 01:51 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1330183 zabbix custzbxweb ACTIVE 01:47 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1327734 zabbix custzbxweb ACTIVE 01:37 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1325211 zabbix custzbxweb ACTIVE 01:24 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1327267 zabbix custzbxweb ACTIVE 01:07 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1332741 zabbix custzbxweb202 ACTIVE 00:56 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1335568 zabbix custzbxweb ACTIVE 00:29 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i

      slow queries

      SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('46465047','46465074') WHERE g.graphid=gi.graphid AND gi.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('46465047','46465074') WHERE g.ymin_type=2 AND g.ymin_itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('46465047','46465074') WHERE g.ymax_type=2 AND g.ymax_itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND (i.hostid BETWEEN '10363' AND '10371' OR i.hostid BETWEEN '13338' AND '13343' OR i.hostid BETWEEN '46467304' AND '46467310' OR i.hostid BETWEEN '46471002' AND '46471007' OR i.hostid BETWEEN '46471068' AND '46471084' OR i.hostid BETWEEN '46471092' AND '46471107' OR i.hostid BETWEEN '46471112' AND '46471118' OR i.hostid BETWEEN '46471123' AND '46471129' OR i.hostid BETWEEN '46471131' AND '46471136' OR i.hostid BETWEEN '46471153' AND '46471158' OR i.hostid BETWEEN '46471161' AND '46471165' OR i.hostid BETWEEN '46471171' AND '46471176' OR i.hostid BETWEEN '46471180' AND '46471184' OR i.hostid BETWEEN '46472092' AND '46472099' OR i.hostid BETWEEN '46473069' AND '46473076' OR i.hostid BETWEEN '46473095' AND '46473099' OR i.hostid BETWEEN '46474148' AND '46474153' OR i.hostid BETWEEN '46475017' AND '46475024' OR i.hostid BETWEEN '46475164' AND '46475168' OR i.hostid BETWEEN '46475644' AND '46475648' OR i.hostid BETWEEN '46475673' AND '46475678' OR i.hostid BETWEEN '46475680' AND '46475685' OR i.hostid BETWEEN '46477032' AND '46477039' OR i.hostid BETWEEN '46477378' AND '46477396' OR i.hostid BETWEEN '46477468' AND '46477472' OR i.hostid BETWEEN '46477629' AND '46477633' OR i.hostid BETWEEN '46479036' AND '46479041' OR i.hostid BETWEEN '46479384' AND '46479391' OR i.hostid BETWEEN '46479403' AND '46479408' OR i.hostid BETWEEN '46479701' AND '46479705' OR i.hostid BETWEEN '46479846' AND '46479854' OR i.hostid BETWEEN '46479856' AND '46479869' OR i.hostid BETWEEN '46479871' AND '46479876' OR i.hostid BETWEEN '46481330' AND '46481334' OR i.hostid BETWEEN '46481922' AND '46481926' OR i.hostid BETWEEN '46481945' AND '46481951' OR i.hostid BETWEEN '46483325' AND '46483341' OR i.hostid BETWEEN '46483419' AND '46483423' OR i.hostid BETWEEN '46483438' AND '46483442' OR i.hostid BETWEEN '46484316' AND '46484320' OR i.hostid BETWEEN '46486845' AND '46486850' OR i.hostid BETWEEN '46487966' AND '46487970' OR i.hostid BETWEEN '46487998' AND '46488004' OR i.hostid BETWEEN '46488087' AND '46488091' OR i.hostid BETWEEN '46489326' AND '46489335' OR i.hostid BETWEEN '46489589' AND '46489594' OR i.hostid BETWEEN '46490739' AND '46490746' OR i.hostid BETWEEN '46491675' AND '46491680' OR i.hostid BETWEEN '46493556' AND '46493562' OR i.hostid BETWEEN '46493755' AND '46493759' OR i.hostid BETWEEN '46493772' AND '46493784' OR i.hostid BETWEEN '46493786' AND '46493790' OR i.hostid BETWEEN '46493804' AND '46493815' OR i.hostid BETWEEN '46495231' AND '46495235' OR i.hostid BETWEEN '46495242' AND '46495247' OR i.hostid BETWEEN '46496891' AND '46496895' OR i.hostid BETWEEN '46497307' AND '46497315' OR i.hostid BETWEEN '46497459' AND '46497463' OR i.hostid BETWEEN '46497934' AND '46497945' OR i.hostid BETWEEN '46497948' AND '46497961' OR i.hostid BETWEEN '46498908' AND '46498920' OR i.hostid BETWEEN '46498944' AND '46498950' OR i.hostid BETWEEN '46499562' AND '46499571' OR i.hostid BETWEEN '46499596' AND '46499602' OR i.hostid IN ('10138','10328','10329','10330','10331','10375','10379','10383','10615','10844','10845','10846','11641','12047','12075','12078','12081','12203','12207','12318','12459','12460','12461','12462','12464','12465','12638','12742','12793','12856','12865','12956','12991','12993','12994','12995','12997','13000','13091','13141','13142','13155','13156','13180','13181','13191','13237','13238','13240','13264','13600','13939','13945','13946','13951','13952','13953','14000','14057','14093','14366','14463','14592','14741','14766','14767','14768','14854','45083923','45083984','45083985','46465195','46465250','46465253','46465254','46465263','46465264','46465265','46465306','46465354','46465371','46465372','46465373','46465413','46465435','46465438','46465440','46465442','46465443','46465446','46465458','46465459','46465476','46465484','46465691','46465692','46465901','46465902','46466094','46466199','46466315','46466316','46466324','46466332','46466342','46466460','46466490','46466800','46466801','46466810','46467029','46467032','46467033','46467034','46467035','46467167','46467170','46467212','46467213','46467214','46467215','46467256','46467346','46467425','46467453','46467455','46467458','46467545','46467546','46467667','46467668','46467691','46467718','46467896','46467932','46467978','46467979','46467980','46468435','46468439','46468562','46468566','46468574','46468579','46468601','46468607','46468634','46468635','46468682','46468684','46468686','46468694','46468706','46468712','46468720','46468723','46468727','46468769','46468770','46468784','46468817','46468818','46468856','46468862','46468865','46468868','46468875','46469018','46469019','46469100','46469108','46469253','46469255','46469272','46469932','46470221','46470261','46470262','46470263','46470265','46470266','46470267','46470268','46470527','46470836','46470838','46470890','46470977','46471086','46471087','46471089','46471090','46471109','46471110','46471120','46471121','46471138','46471139','46471140','46471141','46471143','46471144','46471145','46471147','46471148','46471149','46471151','46471168','46471169','46471198','46471286','46471288','46471302','46471307','46471309','46471314','46471417','46471527','46471661','46472070','46472138','46472258','46472259','46472287','46472404','46472405','46472407','46472530','46472621','46472709','46472711','46472734','46472758','46473057','46473058','46473059','46473183','46473205','46473428','46473429','46473438','46473745','46474140','46474158','46474345','46474346','46474377','46474379','46474390','46474391','46474392','46474983','46474984','46474985','46474986','46475011','46475012','46475029','46475048','46475069','46475074','46475159','46475160','46475161','46475162','46475188','46475189','46475212','46475213','46475275','46475280','46475363','46475372','46475374','46475383','46475480','46475491','46475499','46475502','46475504','46475506','46475508','46475509','46475510','46475512','46475515','46475581','46475591','46475596','46475615','46475631','46475633','46475634','46475639','46475641','46475642','46475692','46475885','46475886','46476292','46476294','46476365','46476434','46476452','46476460','46476463','46476465','46476466','46476488','46476490','46476535','46476612','46476613','46476614','46476617','46476618','46476638','46476722','46476724','46476725','46476751','46476758','46477102','46477104','46477373','46477374','46477375','46477376','46477398','46477399','46477410','46477411','46477474','46477476','46477479','46477481','46477486','46477523','46477547','46477556','46477557','46477559','46477614','46477664','46477846','46477907','46478199','46478200','46478284','46478296','46478297','46478349','46478350','46478351','46478358','46478413','46478414','46478418','46478539','46478561','46478563','46478780','46478781','46478782','46478880','46478881','46478962','46479010','46479043','46479044','46479293','46479308','46479310','46479393','46479417','46479571','46479707','46479708','46479709','46479721','46479725','46479728','46479729','46479730','46479735','46479739','46479740','46479741','46479772','46479831','46479883','46479897','46479947','46479948','46479981','46480015','46480035','46480036','46480040','46480041','46480042','46480091','46480235','46480239','46480243','46480247','46480263','46480371','46480372','46480391','46480430','46480608','46480609','46480610','46480611','46480634','46480636','46480637','46480638','46480664','46480748','46480749','46480832','46480833','46480834','46480839','46480840','46480900','46480956','46481234','46481260','46481325','46481479','46481483','46481484','46481534','46481581','46481928','46481930','46481931','46481932','46481940','46481941','46481942','46481943','46482076','46482634','46482715','46482769','46482830','46482850','46482909','46482910','46482925','46482927','46482931','46482932','46482996','46482997','46483049','46483051','46483083','46483085','46483087','46483088','46483089','46483299','46483315','46483316','46483402','46483403','46483404','46483406','46483407','46483426','46483429','46483430','46483433','46483435','46483444','46483446','46483448','46483450','46483457','46483469','46483470','46483472','46483474','46483475','46483476','46483480','46483485','46483488','46483854','46483855','46483856','46483857','46483978','46483981','46484011','46484027','46484028','46484041','46484061','46484068','46484102','46484307','46484309','46484310','46484386','46484387','46484422','46484423','46484507','46484784','46484901','46484960','46484988','46484989','46485006','46485039','46485042','46485053','46485056','46485066','46485067','46485074','46485149','46485269','46485338','46485356','46485389','46485390','46485508','46485513','46485515','46485527','46485530','46485555','46485575','46485579','46485697','46485698','46485699','46485772','46485774','46485776','46485779','46485780','46485892','46485894','46485915','46485929','46485962','46485979','46486086','46486117','46486185','46486186','46486426','46486566','46486567','46486568','46486569','46486604','46486654','46486656','46486664','46486672','46486674','46486852','46486853','46486854','46486855','46486873','46486874','46486882','46486893','46486894','46487001','46487013','46487042','46487053','46487058','46487085','46487098','46487099','46487115','46487119','46487120','46487232','46487263','46487277','46487291','46487292','46487293','46487294','46487306','46487316','46487331','46487333','46487336','46487337','46487538','46487611','46487612','46487773','46487802','46487826','46487828','46487829','46487831','46487834','46487851','46487879','46487880','46487884','46487958','46487963','46487964','46487972','46487980','46488010','46488046','46488056','46488060','46488080','46488081','46488200','46488263','46488384','46488385','46488407','46488471','46488475','46488490','46488497','46488510','46488516','46488521','46488620','46488627','46488653','46488655','46488779','46488796','46488845','46488970','46489092','46489129','46489130','46489172','46489173','46489180','46489182','46489183','46489212','46489213','46489214','46489215','46489227','46489309','46489311','46489312','46489319','46489321','46489322','46489323','46489324','46489376','46489437','46489442','46489488','46489491','46489532','46489542','46489583','46489666','46489685','46489687','46489691','46489697','46489732','46489801','46489820','46489950','46489955','46489956','46489989','46489991','46489992','46489997','46490002','46490010','46490011','46490095','46490371','46490407','46490408','46490513','46490527','46490538','46490545','46490609','46490666','46490667','46490697','46490700','46490709','46490756','46490832','46490936','46490961','46490986','46491001','46491003','46491019','46491021','46491072','46491183','46491201','46491255','46491257','46491316','46491393','46491549','46491550','46491553','46491556','46491568','46491569','46491578','46491591','46491639','46491640','46491647','46491656','46491658','46491659','46491661','46491666','46491668','46491669','46491683','46491684','46491698','46491701','46491716','46491771','46491864','46491866','46491896','46491917','46491927','46491938','46491942','46491963','46492003','46492019','46492021','46492042','46492044','46492045','46492046','46492060','46492108','46492161','46492194','46492195','46492196','46492197','46492219','46492236','46492244','46492325','46492364','46492378','46492382','46492383','46492462','46492465','46492469','46492618','46492715','46492842','46492924','46492937','46492983','46492999','46493005','46493019','46493053','46493055','46493063','46493097','46493098','46493198','46493204','46493205','46493300','46493309','46493310','46493313','46493315','46493316','46493326','46493395','46493396','46493406','46493436','46493505','46493518','46493520','46493568','46493569','46493570','46493578','46493579','46493580','46493610','46493611','46493612','46493614','46493615','46493619','46493620','46493661','46493662','46493699','46493735','46493736','46493741','46493742','46493743','46493747','46493761','46493763','46493764','46493765','46493766','46493768','46493769','46493770','46493798','46493799','46493829','46493831','46493835','46493877','46493881','46493882','46493883','46493884','46493887','46493890','46493903','46493922','46493932','46494076','46494077','46494081','46494082','46494083','46494164','46494423','46494783','46494793','46494828','46494874','46494905','46495020','46495033','46495070','46495081','46495158','46495160','46495229','46495265','46495266','46495288','46495289','46495343','46495344','46495376','46495409','46495440','46495549','46495555','46495585','46495588','46495609','46495610','46495611','46495615','46495713','46495715','46495716','46495751','46495755','46495756','46495792','46495885','46495889','46495890','46495911','46495952','46495964','46495985','46495991','46496015','46496022','46496023','46496027','46496037','46496045','46496048','46496060','46496065','46496078','46496145','46496185','46496189','46496190','46496215','46496268','46496278','46496300','46496324','46496409','46496414','46496438','46496493','46496498','46496505','46496507','46496566','46496608','46496654','46496710','46496742','46496745','46496750','46496760','46496777','46496782','46496783','46496839','46496898','46496900','46496906') OR i.hostid IN ('46496909','46496915','46496918','46496927','46496934','46496942','46496953','46496961','46496962','46496966','46496978','46496983','46496988','46497004','46497009','46497115','46497116','46497122','46497130','46497219','46497235','46497327','46497336','46497351','46497363','46497365','46497373','46497377','46497378','46497404','46497410','46497411','46497412','46497413','46497421','46497434','46497440','46497450','46497451','46497452','46497456','46497457','46497486','46497488','46497504','46497513','46497553','46497587','46497593','46497600','46497609','46497618','46497622','46497623','46497624','46497626','46497631','46497639','46497661','46497672','46497673','46497681','46497682','46497692','46497693','46497758','46497815','46497816','46497817','46497846','46497851','46497852','46497922','46497964','46497976','46497977','46497978','46497979','46497985','46498031','46498032','46498064','46498090','46498130','46498196','46498214','46498215','46498216','46498217','46498228','46498279','46498309','46498441','46498443','46498479','46498492','46498528','46498541','46498608','46498644','46498686','46498697','46498730','46498733','46498775','46498776','46498894','46498898','46498903','46498904','46498965','46499012','46499017','46499205','46499213','46499214','46499215','46499228','46499277','46499279','46499280','46499281','46499288','46499292','46499356','46499361','46499363','46499365','46499366','46499368','46499370','46499373','46499374','46499377','46499378','46499384','46499385','46499388','46499389','46499390','46499416','46499417','46499442','46499445','46499459','46499505','46499532','46499547','46499552','46499558','46499559','46499576','46499608','46499725','46499743','46499820','46499851','46499855','46499883','46499909','46499949','46499956','46499970','46499971','46499972','46499979','46500074','46500076','46500123','46500156','46500181','46500186','46500188','46500190','46500192','46500207','46500229','46500254','46500255','46500326','46500334','46500359','46500370','46500382','46500391','46500412','46500420','46500450','46500704','46500898','46501076')) AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid

        Attachments

        1. dashboard-menu.png
          dashboard-menu.png
          14 kB
        2. dashboard-refresh-rate-menu.png
          dashboard-refresh-rate-menu.png
          15 kB
        3. group-map-element-menu.png
          group-map-element-menu.png
          16 kB
        4. history-menu.png
          history-menu.png
          11 kB
        5. host-map-element-menu.png
          host-map-element-menu.png
          48 kB
        6. host-menu.png
          host-menu.png
          30 kB
        7. item-menu.png
          item-menu.png
          28 kB
        8. item-prototype-menu.png
          item-prototype-menu.png
          17 kB
        9. slideshow-refresh-menu.png
          slideshow-refresh-menu.png
          18 kB
        10. submap-map-element-menu.png
          submap-map-element-menu.png
          14 kB
        11. trigger-macro-menu.png
          trigger-macro-menu.png
          14 kB
        12. trigger-map-element-menu.png
          trigger-map-element-menu.png
          17 kB
        13. trigger-menu.png
          trigger-menu.png
          16 kB

          Issue Links

            Activity

              People

              Assignee:
              sasha Alexander Vladishev
              Reporter:
              kaspars.mednis Kaspars Mednis
              Votes:
              3 Vote for this issue
              Watchers:
              14 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: