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

can't add template or link template to host on master node

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 1.8.2
    • None
    • None
    • mysql-server-5.0.77_1
      v1.8.2 (revision 11211)

      a master node and several child nodes
      they are correctly synchronized
      When creating a new template, the following error:

      • [ CTemplate::massAdd ] Circular link can not be created
      • [ CTemplate::create ]
        when link template to host:
      • [ CTemplate::massAdd ] Circular link can not be created
      • [ CHost::massUpdate ] Cannot link template
      • [ CHost::update ] Host update failed

      part of debug list, when adding new template:
      ...........................
      ?????:3.2E-5 SQL: begin
      ?????:6.4E-5 SQL: SELECT DISTINCT g.groupid FROM groups g WHERE ((g.groupid BETWEEN 1000000000000000 AND 1099999999999999)) AND (g.groupid IN (1001000000000001))
      ?????:0.000369 SQL: SELECT DISTINCT h.hostid FROM hosts h WHERE ((h.hostid BETWEEN 1000000000000000 AND 1099999999999999)) AND h.status=3 AND ((h.hostid BETWEEN 1000000000000000 AND 1099999999999999)) AND h.host='test' LIMIT 1 OFFSET 0
      ?????:0.000295 SQL: SELECT DISTINCT h.hostid FROM hosts h WHERE ((h.hostid BETWEEN 1000000000000000 AND 1099999999999999)) AND h.status IN (0,1) AND (h.host IN ('test')) LIMIT 1 OFFSET 0
      ?????:0.00014 SQL: SELECT nextid FROM ids WHERE nodeid=10 AND table_name='hosts' AND field_name='hostid'
      ?????:0.000135 SQL: UPDATE ids SET nextid=nextid+1 WHERE nodeid=10 AND table_name='hosts' AND field_name='hostid'
      ?????:0.0001 SQL: SELECT nextid FROM ids WHERE nodeid=10 AND table_name='hosts' AND field_name='hostid'
      ?????:0.003658 SQL: INSERT INTO hosts (hostid, host, status) VALUES (1001000000010052,'test',3)
      ?????:0.000237 SQL: SELECT hostid, groupid FROM hosts_groups WHERE (hostid IN (1001000000010052)) AND (groupid IN (1001000000000001))
      ?????:0.000109 SQL: SELECT nextid FROM ids WHERE nodeid=10 AND table_name='hosts_groups' AND field_name='hostgroupid'
      ?????:0.00011 SQL: UPDATE ids SET nextid=nextid+1 WHERE nodeid=10 AND table_name='hosts_groups' AND field_name='hostgroupid'
      ?????:9.5E-5 SQL: SELECT nextid FROM ids WHERE nodeid=10 AND table_name='hosts_groups' AND field_name='hostgroupid'
      ?????:0.000334 SQL: INSERT INTO hosts_groups (hostgroupid, hostid, groupid) VALUES (1001000000000052, 1001000000010052, 1001000000000001)
      ?????:5.1E-5 SQL: SELECT DISTINCT g.* FROM groups g WHERE ((g.groupid BETWEEN 1000000000000000 AND 1099999999999999)) AND (g.groupid IN (1001000000000001))
      ?????:0.000798 SQL: SELECT DISTINCT h.*,hg.groupid FROM hosts h,hosts_groups hg WHERE (hg.groupid IN (1001000000000001)) AND hg.hostid=h.hostid AND ((hg.groupid BETWEEN 1000000000000000 AND 1099999999999999)) AND h.status IN (0,1)
      ?????:0.000657 SQL: SELECT DISTINCT t.* FROM triggers t, functions f, items i WHERE i.hostid=1001000000010052 AND f.itemid=i.itemid AND f.triggerid=t.triggerid
      ?????:0.000298 SQL: SELECT DISTINCT h.host FROM trigger_depends td, functions f, items i, hosts h WHERE ( (td.triggerid_down IN (-1)) AND f.triggerid=td.triggerid_up) AND i.itemid=f.itemid AND h.hostid=i.hostid AND (h.hostid NOT IN (1001000000010052)) AND h.status=3
      ?????:0.000119 SQL: SELECT hostid, templateid FROM hosts_templates WHERE (hostid IN (-1)) AND (templateid IN (1001000000010052))
      ?????:0.003686 SQL: SELECT ht.hostid, ht.templateid FROM hosts_templates ht, hosts h WHERE ht.hostid=h.hostid AND h.status=3
      ?????:37.925818 LONG SQL: SELECT max(ht.hostid) as hostid, ht.templateid FROM( SELECT count(htt.templateid) as ccc, htt.hostid FROM hosts_templates htt WHERE htt.hostid NOT IN ( SELECT httt.templateid FROM hosts_templates httt ) GROUP BY htt.hostid ) ggg, hosts_templates ht WHERE ggg.ccc>1 AND ht.hostid=ggg.hostid GROUP BY ht.templateid
      ?????:0.00028 SQL: rollback
      .........................

      sorry for my lousy english

            Unassigned Unassigned
            ugh Konstantin Agafontsev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: