Node Zabbix 2.0

[eterjack]

Hello,

I have problems to put the zabbix nodes in version 2.0 to run.
I did the standard installation procedure of the nodes, father and son.

parent node: id 1
child node: id 40

log files:

father 15047:20120528:181153.591 [Z3005] Query failed: [1452] Can not add or update a child row: a foreign key constraint fails

child:
18782:20120528:182117.858 NODE 40: Sending service_alarms of node 40 to node 1 datalen 27382
18782:20120528:182118.310 NOT OK
18782:20120528:182130.193 NODE 40: Sending configuration changes to a master node for node 40 datalen 9031629

[marcherren]

Have you convert the database data for a distributed setup, by running: zabbix_server -n <node id> ?

[groe0286]

I have seen this issue on our very large setup as well.

What I did what remove the constraints on tables that were causing a problem ON THE MASTER only.

Normally, because the constraints are still there on the child hosts, there shouldn't be a problem.

It's working OK now.

[[email protected]]

Perhaps I have met this problem。This just because I didn't restart the zabbix_server。

The following message is error report in the server log file at that time：
17264:20120819:112507.119 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`auditlog`, CONSTRAINT `c_auditlog_1` FOREIGN KEY (`userid`)

Wish this can help you

[eterjack]

Remove constraints ... hummm it is safe make this ? In 1.8.12 works good.

[eterjack]

Hello, I again.

Make a lab, and find solution for this problem. This problems occurred when lost MASTER and add a NEW MASTER on NODE.

Execute on MASTER e NODE1.

truncate table history_sync;
truncate table history_uint_sync;
truncate table history_str_sync;
truncate table node_cksum;