Hello everyone,
I am using zabbix 6.0. I see this error in the logs when house keeping is running. mysql server im on another server.
Error;
2563859:20220119:153117.880 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`event_recovery`, CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE ON UPDATE RESTRICT) [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (17745880,17746453,null,null,null),(34074,17746452 ,null,null,null);
I am using zabbix 6.0. I see this error in the logs when house keeping is running. mysql server im on another server.
Error;
2563859:20220119:153117.880 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`event_recovery`, CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE ON UPDATE RESTRICT) [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (17745880,17746453,null,null,null),(34074,17746452 ,null,null,null);