i seeing a few of these lately
it is a server on debian 8 , zbx 3.4.7
most of my data is collected via proxy being at least 3.4.7 mostly 3.4.14
i have a suspicion what is causing the issue.
i want to make sure i understand the error message correctly.
which table has data that i can not find in another table ?
where do i need to delete a dataset ?
i want to delete these hosts or items but i can not drop the tables
Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`functions`, CONSTRAINT `c_functions_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE) [insert into functions (functionid,itemid,triggerid,function,parameter) values (172771,341301,132558,'last','0'),(172772,291379,1 32558,'avg','300'),(172773,341302,132559,'last','0 '),(172774,291380,132559,'avg','300'),(172775,3413 03,132560,'last','0')...
maybe table functions has itemid of xxx that i can not find in table items with itemid xxx ???
thanks for helping out
it is a server on debian 8 , zbx 3.4.7
most of my data is collected via proxy being at least 3.4.7 mostly 3.4.14
i have a suspicion what is causing the issue.
i want to make sure i understand the error message correctly.
which table has data that i can not find in another table ?
where do i need to delete a dataset ?
i want to delete these hosts or items but i can not drop the tables
Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`functions`, CONSTRAINT `c_functions_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE) [insert into functions (functionid,itemid,triggerid,function,parameter) values (172771,341301,132558,'last','0'),(172772,291379,1 32558,'avg','300'),(172773,341302,132559,'last','0 '),(172774,291380,132559,'avg','300'),(172775,3413 03,132560,'last','0')...
maybe table functions has itemid of xxx that i can not find in table items with itemid xxx ???
thanks for helping out