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

Z3005: query failed (insert into event_recovery)

    XMLWordPrintable

Details

    • Problem report
    • Status: Need info
    • Trivial
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      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...

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated: