-
Incident report
-
Resolution: Fixed
-
Major
-
None
-
3.4.10
-
None
In my zabbix_server.log I have a lot of error:
28308:20180613:072304.296 [Z3005] query failed: [1062] Duplicate entry '4797763' for key 'PRIMARY' [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (4869248,4869375,null,null,null),(4858997,4869375,null,null,null),(4819277,4869375,null,null,null),(4798259,4869375,null,null,null),(4802518,4869375,null,null,null),
I check our DB and in events i found this
MariaDB [zabbix]> select * from events where eventid=4797763; +---------+--------+--------+----------+------------+-------+--------------+-----------+ | eventid | source | object | objectid | clock | value | acknowledged | ns | +---------+--------+--------+----------+------------+-------+--------------+-----------+ | 4797763 | 3 | 4 | 36183 | 1525482903 | 1 | 0 | 455074981 | +---------+--------+--------+----------+------------+-------+--------------+-----------+
The best way for resolve this issue is delete from table events the id 4797763 ?