-
Problem report
-
Resolution: Fixed
-
Trivial
-
6.4.0
-
None
-
sqlite3
-
Sprint 106 (Nov 2023)
-
1
Steps to reproduce:
- Add the host with some inventory data (like hostname or coordinates).
- Assign it to the already configured proxy and wait for when the config will sync.
- Assign back the monitored host to the Zabbix server and wait when the configuration will sync.
- 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
