-
Problem report
-
Resolution: Cannot Reproduce
-
Trivial
-
None
-
4.4.6
Regularly we see failed queries in the Zabbix server log:
[Z3005] query failed: [1062] Duplicate entry '200200001061961-200200001061964' for key 'trigger_depends_1' [insert into trigger_depends (triggerdepid,triggerid_down,triggerid_up) values (200200003738233,200200001061961,200200001061964);
This prevents the affected discovered triggers to be updated.
It appears that the server tries to insert the same depedency multiple times:
mysql> select * from trigger_depends where triggerid_down='200200001061961' and triggerid_up='200200001061964'; +-----------------+-----------------+-----------------+ | triggerdepid | triggerid_down | triggerid_up | +-----------------+-----------------+-----------------+ | 200200001170768 | 200200001061961 | 200200001061964 | +-----------------+-----------------+-----------------+
This issue was already happening since version 3.4.
