-
Incident report
-
Resolution: Won't fix
-
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