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

SQL errors after re-assigning the hosts to the proxy

XMLWordPrintable

    • Sprint 106 (Nov 2023)
    • 1

      Steps to reproduce:

      1. Add the host with some inventory data (like hostname or coordinates).
      2. Assign it to the already configured proxy and wait for when the config will sync.
      3. Assign back the monitored host to the Zabbix server and wait when the configuration will sync.
      4. Assign the host again to the same Zabbix proxy.

      Result:
      See log file on the Zabbix proxy

        4774:20230311:154019.561 received configuration data from server at "10.60.0.110", datalen 7941
        4774:20230311:154019.602 [Z3005] query failed: [0] UNIQUE constraint failed: host_inventory.hostid [insert into host_inventory (hostid,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes) values (10569,'','','rtr-core-01-hal1','','6.48.6','','','<SOME_VALUE>','','','','','','','','','','','','','','','','','<SOME_VALUE>','26.2852965661635','','','<SOME_VALUE>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
      insert into host_inventory (hostid,type,type_full,name,alias,os,os_full,os_short,serialno_a,serialno_b,tag,asset_tag,macaddress_a,macaddress_b,hardware,hardware_full,software,software_full,software_app_a,software_app_b,software_app_c,software_app_d,software_app_e,contact,location,location_lat,location_lon,notes,chassis,model,hw_arch,vendor,contract_number,installer_name,deployment_status,url_a,url_b,url_c,host_networks,host_netmask,host_router,oob_ip,oob_netmask,oob_router,date_hw_purchase,date_hw_install,date_hw_expiry,date_hw_decomm,site_address_a,site_address_b,site_address_c,site_city,site_state,site_country,site_zip,site_rack,site_notes,poc_1_name,poc_1_email,poc_1_phone_a,poc_1_phone_b,poc_1_cell,poc_1_screen,poc_1_notes,poc_2_name,poc_2_email,poc_2_phone_a,poc_2_phone_b,poc_2_cell,poc_2_screen,poc_2_notes) values (10571,'','','rtr-core-01-aws1','','6.48.5','','','','','','','','','','','','','','','','','','','','','','','','RouterOS CHR','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
      ]
        4774:20230311:154019.604 cannot process received configuration data from server at "10.60.0.110": cannot insert rows in table "host_inventory"
        4774:20230311:154029.712 received configuration data from server at "10.60.0.110", datalen 23449
      

      Expected:
      It shouldn't be any errors

      The problem appears with the hosts that have an inventory filled in

        1. zabbix_proxy.log
          6 kB
          Michal Czerniakiewicz

            wiper Andris Zeila
            vovan2007 Volodymyr Mosiichuk
            Team A
            Votes:
            3 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: