Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18792

query failed in adding VMware hosts by LLD

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Done
    • Icon: Trivial Trivial
    • None
    • 5.0.6
    • Server (S)
    • 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,

            neogan Andrei Gushchin (Inactive)
            kento.takahashi Kento Takahashi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: