Zabbix Child node dashboard not updating

[Zeeshan]

hi guys,

i have setup a distributed setup for zabbix with one master node and one child. the dashboard for the master node works ok but the child node doesnt display anything, although i can add hosts to the child node through the master node.
i had a look in the logs and i am getting the following errors:

On Child Node:
20458:20130613:132039.992 NOT OK
20458:20130613:132049.127 NODE 2: Sending history_sync of node 2 to node 1 datalen 111
20458:20130613:132049.234 NODE 2: Sending history_uint_sync of node 2 to node 1 datalen 353
20458:20130613:132049.439 NODE 2: Sending events of node 2 to node 1 datalen 31061
20458:20130613:132049.499 NOT OK

On Master Node:
[Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`acknowledges`, CONSTRAINT `c_acknowledges_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE) [insert into acknowledges (acknowledgeid,userid,eventid,clock,message) values (200200000000001,200200000000001,200000000000016,1 371117179,'


i have had a look on the forums and have already performed the following steps:
* 1. Stop Master node
* 2. Execute on NODEx (not MASTER):
*delete from node_cksum;
*delete from node_configlog;
* 3. Start Master node

and

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

but nothing seems to work..... Please help

regards

Z

[nail]

I have probably the same issue

It shows alerts if I open child-node dashboad directly, but if I open it through master-node I see what displayed on screenshot.
Issues count (highlighted) is the same on both.

Some alerts are shown through master-node, but have incorrect "Last change".

[Zeeshan]

I have tried this, it has hopefully sorted the problem i am still testing though.

login to the client node and do the following:

SELECT count(*) FROM events LEFT JOIN triggers ON triggers.triggerid=events.objectid WHERE events.source='0' AND triggers.triggerid is null;

DELETE from events WHERE source='0' AND objectid NOT IN (SELECT triggerid from triggers);

according to what i have read, this issue is caused by triggers which have 0 source id if you remove these triggers it show be OK. The above mysql commands do this.

Good Luck!

Z

[nail]

I have tried this, it has hopefully sorted the problem i am still testing though.

login to the client node and do the following:

SELECT count(*) FROM events LEFT JOIN triggers ON triggers.triggerid=events.objectid WHERE events.source='0' AND triggers.triggerid is null;

DELETE from events WHERE source='0' AND objectid NOT IN (SELECT triggerid from triggers);

according to what i have read, this issue is caused by triggers which have 0 source id if you remove these triggers it show be OK. The above mysql commands do this.

Good Luck!

Z

unfortunately it didn't helped. some triggers still are displayed only on child dashboard.

[eterjack]

Thx for this:

SELECT count(*) FROM events LEFT JOIN triggers ON triggers.triggerid=events.objectid WHERE events.source='0' AND triggers.triggerid is null;

DELETE from events WHERE source='0' AND objectid NOT IN (SELECT triggerid from triggers);

Worked

[alexfear]

I have tried this, it has hopefully sorted the problem i am still testing though.

login to the client node and do the following:

SELECT count(*) FROM events LEFT JOIN triggers ON triggers.triggerid=events.objectid WHERE events.source='0' AND triggers.triggerid is null;

DELETE from events WHERE source='0' AND objectid NOT IN (SELECT triggerid from triggers);

according to what i have read, this issue is caused by triggers which have 0 source id if you remove these triggers it show be OK. The above mysql commands do this.

Good Luck!

Z

Many thanks for this solution, it fixed my issue with empty dashboard of child node!