Hello
since version 2.0.4 i have some issues with synchronisations which i fixed, but the fix is not what i expected and not clean at all.
Situation:
NODE A - Master
NODE B - Child
Problem description:
NODE A monitors about 800 hosts without problems.
NODE B monitors about 800 hosts without problems when directly logged into that node.
The problem is that not all hosts/items/screens etc. from NODE B are synchronized to NODE A.
Errors:
In the logging on NODE A (those errors are only for hosts on NODE B) you find errors like:
etc.etc.
This causes a lot of hosts not to be synchronized but not all. some hosts are correctly synchronized.
Solved:
i solved the issue with a NODE C which does only the webinterface. NODE A and B are synchronising to NODE C. On NODE C i had to delete ALL constraints in all tables which is dirty. But it works.
Question:
Are you experiencing the same and what are the consequentes of removing all the constraints like i did. At this moment everything works like charm for a week now.
since version 2.0.4 i have some issues with synchronisations which i fixed, but the fix is not what i expected and not clean at all.
Situation:
NODE A - Master
NODE B - Child
Problem description:
NODE A monitors about 800 hosts without problems.
NODE B monitors about 800 hosts without problems when directly logged into that node.
The problem is that not all hosts/items/screens etc. from NODE B are synchronized to NODE A.
Errors:
In the logging on NODE A (those errors are only for hosts on NODE B) you find errors like:
Code:
3358:20130306:071730.226 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`h ostid`) ON DELETE CASCADE) [insert into hosts (hostid,proxy_hostid,host,status,error,available,lastaccess,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,ipmi_available,snmp_available,maintenanceid,m aintenance_status,maintenance_type,maintenance_from,ipmi_error,snmp_error,jmx_available,jmx_error,name) values (200200000037880,NULL,'Leeuwarden Oostergoweg 2 10.1.24.1',0,'',0,0,0,2,'','',0,0,NULL,0,0,0,'', '',0,'','Leeuwarden Oostergoweg 2 10.1.24.1'); insert into hosts (hostid,proxy_hostid,host,status,error,available,lastaccess,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,ipmi_available,snmp_available,maintenanceid,maintenance_status,maintenanc e_type,maintenance_from,ipmi_error,snmp_error,jmx_available,jmx_error,name) values (200200000037881,NULL,'Leeuwarden Oostergoweg 2 10.1.24.3',0,'',0,0,0,2,'','',0,0,NULL,0,0,0,'','',0,'','Leeuwarden Oosterg oweg 2 10.1.24.3'); insert into hosts
This causes a lot of hosts not to be synchronized but not all. some hosts are correctly synchronized.
Solved:
i solved the issue with a NODE C which does only the webinterface. NODE A and B are synchronising to NODE C. On NODE C i had to delete ALL constraints in all tables which is dirty. But it works.
Question:
Are you experiencing the same and what are the consequentes of removing all the constraints like i did. At this moment everything works like charm for a week now.