Ad Widget

Collapse

Cannot add or update a child row: a foreign key constraint fails

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • StoneHold
    Junior Member
    • May 2021
    • 1

    #1

    Cannot add or update a child row: a foreign key constraint fails

    Hi all,

    when I upgrading the Zabbix I got the following error on MySQL. How can i resolve this? any idea about it ?

    2506040:20210821:122320.083 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbixdb`.`event_recovery`, CONSTRAINT `event_recovery_ibfk_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE) [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (4499815,13211,null,null,null)
Working...