-
Problem report
-
Resolution: Done
-
Trivial
-
None
-
5.0.6
-
None
I installed Zabbix 5.0.6 and tried to monitor VMware virtual machines.
I added some VMware hosts and apply a VMware template.
After several hours, I found query errors in zabbix_server.log
2974:20201209:114601.822 [Z3005] query failed: [1062] Duplicate entry 'hstgrp-groupid' for key 'PRIMARY' [insert into ids (table_name,field_name,nextid) values ('hstgrp','groupid',15)] 2974:20201209:114601.864 [Z3005] query failed: [1048] Column 'groupid' cannot be null [insert into hosts_groups (hostgroupid,hostid,groupid) values (2380,10858,12),(2381,10858,null),(2382,10858,1),(2383,10858,2), ... ,(4369,11355,null),(4370,11355,1),(4371,11355,4); ]
I tried the same procedure several times, but the the errors did not happen again.
There might be a race condition.
Steps to reproduce:
1. install Zabbix 5.0.6
2. add VMware hosts and apply a template for VMware monitoring
3. query errors sometimes occur
Result:
The messages written above are sometimes shown in zabbix_server.log
Expected:
No error messages
Regards,