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

Can't update dependencies on template

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • 1.8.4
    • 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 ***************************

            Unassigned Unassigned
            coudy Coudy
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: