[ZBX-7975] invalid sql request between child and master node for group_discovery table Created: 2014 Mar 20  Updated: 2017 May 30  Resolved: 2015 Jan 20

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.2.2
Fix Version/s: None

Type: Incident report Priority: Blocker
Reporter: platine Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: database, dm, lld
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

linux / mysql / 2 nodes



 Description   

when we use vmware templates to discover hosts, child node request master node to create groups bu there is an error:
"
insert into group_discovery (groupid,groupid,parent_group_prototypeid) values (300300000000008,300300000000008,300100000000006);
insert into group_discovery (groupid,groupid,parent_group_prototypeid) values (300300000000009,300300000000009,300100000000006);
insert into group_discovery (groupid,groupid,parent_group_prototypeid) values (300300000000010,300300000000010,300100000000008);
insert into group_discovery (groupid,groupid,parent_group_prototypeid) values (300300000000011,300300000000011,300100000000009);
"

As you can read, column 'groupid' is specified twice

After that, all hosts, events, items, triggers on master node are failded and generated errors on fronted



 Comments   
Comment by platine [ 2014 Mar 20 ]

more information:

zabbix server package used: zabbix-server-mysql_2.2.2-1+wheezy_amd64.deb

Comment by Oleksii Zagorskyi [ 2014 Mar 21 ]

FYI - ZBXNEXT-1343

Nodes sync actually is an independent routine of vwmave discovery or other zabbix processes.
Check please ZBX-7253

Comment by platine [ 2014 Mar 25 ]

how can i solved it?
Do you known witch source file to edit?

Comment by richlv [ 2015 Jan 20 ]

given that node based distributed monitoring has been removed in 2.4, this issue is unlikely to be looked in -> closing

Generated at Wed Apr 24 17:17:20 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.