Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 3.2.9, 3.4.4, 4.0.0alpha1, 4.0 (plan)
    • Fix Version/s: 3.2.11rc1, 3.4.5rc1, 4.0.0alpha1
    • Component/s: None
    • Labels:
      None
    • Team:
      Team A
    • Sprint:
      Sprint 20, Sprint 21, Sprint 22
    • Story Points:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: