Hello
We have had the following messages in our zabbix_server.log for quite some time:
7758:20190306:152653.313 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`graphs`, CONSTRAINT `c_graphs_3` FOREIGN KEY (`ymax_itemid`) REFERENCES `items` (`itemid`)) [delete from items where itemid in (107338,107342,107346,107350,107352,107354,279793) ;
7791:20190306:152801.925 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`graphs`, CONSTRAINT `c_graphs_3` FOREIGN KEY (`ymax_itemid`) REFERENCES `items` (`itemid`)) [delete from items where (itemid between 56584 and 56591 or itemid between 428866 and 428870 or itemid between 870948 and 870954 or itemid in (276868,728765,729203));
There are always the same (this two) messages.
Does anyone know what I can do best here? The service doesn't seem to be disturbed.
zabbix-server-mysql 4.0.4.1.el7
The message already existed before the upgrade to 4.0.
thanks and best regarss,
Felix
We have had the following messages in our zabbix_server.log for quite some time:
7758:20190306:152653.313 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`graphs`, CONSTRAINT `c_graphs_3` FOREIGN KEY (`ymax_itemid`) REFERENCES `items` (`itemid`)) [delete from items where itemid in (107338,107342,107346,107350,107352,107354,279793) ;
7791:20190306:152801.925 [Z3005] query failed: [1451] Cannot delete or update a parent row: a foreign key constraint fails (`zabbix`.`graphs`, CONSTRAINT `c_graphs_3` FOREIGN KEY (`ymax_itemid`) REFERENCES `items` (`itemid`)) [delete from items where (itemid between 56584 and 56591 or itemid between 428866 and 428870 or itemid between 870948 and 870954 or itemid in (276868,728765,729203));
There are always the same (this two) messages.
Does anyone know what I can do best here? The service doesn't seem to be disturbed.
zabbix-server-mysql 4.0.4.1.el7
The message already existed before the upgrade to 4.0.
thanks and best regarss,
Felix