-
Incident report
-
Resolution: Won't fix
-
Major
-
1.8.3
-
None
-
None
-
Xeon 3Ghz, debian 64bit, 4GB Ram
I can't add dependencies to template.
This is error from status bar :
ERROR: Cannot update trigger Not all Templates are linked to host [ Banovce-nad-Bebravou-DOMS ]
This is debug output:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Stats for script *************************
Total time: 0.133141
Memory limit : 256M
Memory usage : 1.75M - 16.25M (14.5M)
Memory peak : 16.25M
SQL selects count: 32
SQL executes count: 6
SQL requests count: 38
Time:5.4E-5 SQL: SET NAMES utf8
Time:2.9E-5 SQL: SET CHARACTER SET utf8
Time:6.6E-5 SQL: SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
Time:0.000303 SQL: SELECT u.,s. FROM sessions s,users u WHERE s.sessionid='356ced26c432688e7376a44725b76d8a' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1292220564) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
Time:3.8E-5 SQL: SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid
Time:3.6E-5 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 1 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
Time:0.007543 SQL: UPDATE sessions SET lastaccess=1292220564 WHERE sessionid='356ced26c432688e7376a44725b76d8a'
Time:0.000129 SQL: DELETE FROM sessions WHERE userid=1 AND status=0 AND lastaccess<1292219664
Time:4.7E-5 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 1 AND g.usrgrpid = ug.usrgrpid AND g.debug_mode = 1 LIMIT 1 OFFSET 0
Time:0.000252 SQL: SELECT * FROM profiles WHERE userid=1 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC
Time:5.9E-5 SQL: SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))
Time:6.7E-5 SQL: SELECT title1, url1, title2, url2, title3, url3, title4, url4, title5, url5 FROM user_history WHERE userid=1
Time:6.0E-5 SQL: SELECT t.triggerid FROM triggers t WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND (t.triggerid IN (13051))
Time:0.000423 SQL: SELECT h.* FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1,3) AND (h.host IN ('t_CS_Doms'))
Time:0.000252 SQL: SELECT i.* FROM items i WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND (i.hostid IN (10069)) AND (i.key_ IN ('tcp,80'))
Time:0.000272 SQL: SELECT DISTINCT * FROM hosts WHERE ((hostid BETWEEN 000000000000000 AND 099999999999999)) AND status IN (0,1,3) AND host IN ('t_CS_Doms')
Time:0.000108 SQL: SELECT h.hostid FROM hosts h WHERE (h.hostid IN (10069)) AND ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1,3)
Time:4.1E-5 SQL: select * from triggers where triggerid=13051
Time:3.6E-5 SQL: begin
Time:0.000292 SQL: select * from triggers where triggerid=13051
Time:0.000316 SQL: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (13051))
Time:0.000148 SQL: SELECT h.host,i.itemid,i.key_,f.function,f.triggerid,f.parameter,i.itemid,i.status FROM items i,functions f,hosts h WHERE f.functionid=39939 AND i.itemid=f.itemid AND h.hostid=i.hostid
Time:0.000247 SQL: SELECT DISTINCT * FROM hosts WHERE ((hostid BETWEEN 000000000000000 AND 099999999999999)) AND status IN (0,1,3) AND host IN ('t_CS_Doms')
Time:0.000274 SQL: SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (13059))
Time:0.005986 SQL: SELECT DISTINCT ht.templateid, ht.hostid, h.host FROM hosts_templates ht, hosts h WHERE h.hostid=ht.hostid AND (ht.templateid IN (10069,10050))
Time:5.9E-5 SQL: rollback
Time:5.7E-5 SQL: SELECT t.* FROM triggers t WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND (t.triggerid IN (13051))
Time:0.000378 SQL: SELECT DISTINCT g.groupid,f.triggerid FROM groups g,hosts_groups hg,functions f,items i WHERE ((g.groupid BETWEEN 000000000000000 AND 099999999999999)) AND (f.triggerid IN (13051)) AND f.itemid=i.itemid AND hg.hostid=i.hostid AND hg.groupid=g.groupid
Time:0.000245 SQL: SELECT DISTINCT h.hostid,f.triggerid FROM hosts h,functions f,items i WHERE (f.triggerid IN (13051)) AND h.hostid=i.hostid AND f.itemid=i.itemid AND ((f.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1,3)
Time:3.8E-5 SQL: SELECT DISTINCT g.* FROM groups g,hosts_groups hg,hosts h WHERE ((g.groupid BETWEEN 000000000000000 AND 099999999999999)) AND hg.groupid=g.groupid AND h.hostid=hg.hostid AND NOT h.status IN (5,6)
Time:7.6E-5 SQL: SELECT DISTINCT h.hostid, h.host,hg.groupid FROM hosts h,hosts_groups hg WHERE (hg.groupid IN (11)) AND hg.hostid=h.hostid AND ((hg.groupid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (0,1,3)
Time:0.00064 SQL: SELECT DISTINCT t.*,i.hostid FROM triggers t,functions f,items i WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999)) AND (i.hostid IN (10069)) AND f.triggerid=t.triggerid AND f.itemid=i.itemid
Time:6.8E-5 SQL: select * from triggers where triggerid=13051
Time:0.000263 SQL: SELECT t.triggerid, t.templateid, h.host FROM triggers t, functions f, items i, hosts h WHERE t.triggerid=13051 AND h.hostid=i.hostid AND i.itemid=f.itemid AND f.triggerid=t.triggerid
Time:0.000248 SQL: SELECT DISTINCT h.host,t.description,t.expression,t.triggerid FROM triggers t, functions f, items i, hosts h WHERE f.triggerid=t.triggerid AND i.itemid=f.itemid AND h.hostid=i.hostid AND t.triggerid=13059
Time:0.000194 SQL: SELECT DISTINCT h.host FROM functions f,items i,hosts h WHERE f.itemid=i.itemid AND i.hostid=h.hostid AND f.functionid=30633
Time:0.000138 SQL: SELECT i.lastvalue, i.value_type, i.itemid, i.valuemapid, i.units FROM items i, functions f WHERE i.itemid=f.itemid AND f.functionid=30633
Time:6.0E-5 SQL: SELECT title5, url5 FROM user_history WHERE userid=1
Total time spent on SQL: 0.019542- End of script ***************************
- Stats for script *************************
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-