Zabbix [Z3005] query failed:

[beyondldf]

My Zabbix version is 3.2.4, I have two issues ,
1.many error messages in Zabbix_server.log, such as:"[z3005] query failed:[1062] Duplicate entry '1913338' for key 'PRIMARY' [insert into events (eventid, source, object, objectid, clock, ns, value) values (1913338,3,0,26624,1492343253,919394133,1),(191333 9,0,0,26633,1492343253,984877142,1)];".
I don't know what's up with Zabbix server?

2.There are many unreachable alerts on dashboard, could you help me to resolved these two problems?
Thanks a lot

[ovas]

Hello!

1. Please, check what is the nextid field value for events table_name in ids table of Zabbix database? Approximate SQL query may be:
SELECT * FROM zabbix.ids WHERE table_name="events";

2. It depends what is unreachable and how items/hosts are configured. I would stick to this error solving only after first one is done.

[beyondldf]

Reply:

Hi:
Thank you for your reply.
I have truncate the events table and alerts table，both of these two issues had resolved. If these issues still occur, i will contact with you. Thank you very much.