Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17391

Z3005: query failed (insert into event_recovery)

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • None
    • None
    • None

      I'm not exactly sure when did it start (probably after upgrade from the earlier release) but my Zabbix-Server logs the following repeatedly:

      [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) insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (12258947,13122392,null,null,null),(12259109,13122392,null,null,null);#012

      This is with MariaDB...

            kpavars Kristians Pavars
            onlyjob Dmitry Smirnov
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: