Ad Widget

Collapse

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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • voronin
    Junior Member
    • Apr 2018
    • 1

    #1

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

    Dear Team,
    I am using zabbix 2.4.5 the log file gets an error:

    4971:20180406:063241.031 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`alerts`, CONSTRAINT `c_alerts_2` FOREIGN KEY (`eventid`) REFERENCES `events1` (`eventid`) ON DELETE CASCADE) [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid ,sendto,subject,message,status,error,esc_step,aler ttype) values (3154001,6,61859,17,1522985561,4,'+79284670088',' : PROBLEM',' : PROBLEM / OnLineMessageBeeline / 2018.04.06 - 06:32:41',0,'',1,0);
Working...