Zabbix upgrade problem from 3.2.0 to v3.4.1

[Andrey123q]

When upgrading from v3.2.0 to v3.4.1 I get next error:

62928:20170919:092214.034 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "alerts" violates foreign key constraint "c_alerts_5"
DETAIL: Key (p_eventid)=(12279274) is not present in table "events".
[update alerts set p_eventid=12271751 where eventid=12272265;
...
update alerts set p_eventid=12287860 where eventid=12288925;
] failed, setting transaction as failed
62928:20170919:092214.042 query [txnlev:1] [rollback;]
62928:20170919:092214.048 database upgrade failed
62928:20170919:092214.048 End of DBcheck_version():FAIL

For this error I created bug report in https://support.zabbix.com/browse/ZBX-12744. As I understand the problem is in db manual change and support closed the ticket, but I don't find how to fix the problem.
Thanks in advance.

[Andrey123q]

After some unsuccessful attempts in testing environment to delete in table event_recovery only rows that selects by query:

select * from event_recovery er where not exists (select NULL from events e where er.eventid=e.eventid);

I clear the table event_recovery and then upgrade is finished successfully. I didn't find any problems in log and any other service components. So I have questions: is this fix (clear table) correct, what is table event_recovery for?

[Andrey123q]

After removing only records selected by that query (rows in table event_recovery which are not present in table events) the problem is also solved.

[Pradeep Kumar]

Hi Guys,

We do get following error while trying upgrade from 3.2 to 3.4:


Code:
27484:20181116:112337.304 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`alerts`, CONSTRAINT `c_alerts_5` FOREIGN KEY (`p_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE) [update alerts set p_eventid=1016656 where eventid=1017557; 27484:20181116:112341.572 database upgrade failed Please let us know how can we fix this issue.

Thanks in advance.