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

Foreign key constraint fails in events

    XMLWordPrintable

Details

    • Problem report
    • Resolution: Fixed
    • Trivial
    • 3.2.11rc1, 3.4.5rc1, 4.0.0alpha1
    • 3.2.9, 3.4.4, 4.0.0alpha1, 4.0 (plan)
    • None
    • None
    • Team A
    • Sprint 20, Sprint 21, Sprint 22
    • 0.25

    Description

      After upgrading to 3.4.3 (from 3.2.x) I noticed the following in the logs happening:

        1505:20171102:115356.574 [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 (103966,127948,null,null,null),(125859,127948,null,null,null),(89485,127948,null,null,null),(108432,127948,null,null,null),(1061995,127948,null,null,null),(116210,127948,null,null,null),(127405,127948,null,null,null),(112889,127948,null,null,null),(102583,127948,null,null,null),(93945,127948,null,null,null);
      

      This happens somewhere between 0 and 23 times a day. Can I somehow find and get rid of these corrupt entries?

      Attachments

        Issue Links

          Activity

            People

              vso Vladislavs Sokurenko
              frank Frank
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: