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

Foreign key constraint fails in events

XMLWordPrintable

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

      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?

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

              Created:
              Updated:
              Resolved: