Details
-
Problem report
-
Status: Closed
-
Trivial
-
Resolution: Fixed
-
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
- caused by
-
-
- Closed
-