-
Type:
Problem report
-
Resolution: Unresolved
-
Priority:
Trivial
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Environment:MySQL Standalone database.
Zabbix Server Version 4.0.9-3.el7
1 Zabbix Server - 6 Zabbix Proxies
Steps to reproduce:
Hello. Someone plugged in a second zabbix server Version 4.0.9-3.el7 (Yes its old).
The second server was active for 6 hours before realizing what happened.
The second server was shutdown and now the primary server is not starting. We're receiving segfaults during the startup process. In reviewing the error log we find these errors. I'm not sure if this would cause the zabbix server process to not start. Can anyone assist?
I think maybe the row increment IDS database may be incorrect and need correction?
Duplicate entry '183491839' for key 'PRIMARY' [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (183491839,183970967,null,null,null),(183491837,183970963,null,null,null),(183488983,183970962,null,null,null),(183489468,183970964,null,null,null),(183488981,183970959,null,null,null),(183488866,183970968,null,null,null),(183491661,183970970,null,null,null),(183490689,183970961,null,null,null),(183491660,183970966,null,null,null),(183491838,183970965,null,null,null),(183487318,183970971,null,null,null),(183491840,183970969,null,null,null),(183488864,183970960,null,null,null),(183487319,183970972,null,null,null);
Duplicate entry '183488982' for key 'PRIMARY' [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (183487317,183970977,null,null,null),(183488982,183970973,null,null,null),(183487316,183970976,null,null,null),(183489165,183970974,null,null,null),(183490556,183970975,null,null,null);
Here is an example screenshot of what we see in the database (MySql)
