[ZBX-16445] LLD doesn't correctly update items when item prototype is fixed Created: 2019 Aug 01  Updated: 2019 Sep 06  Resolved: 2019 Sep 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 4.0.11, 4.2.5
Fix Version/s: 4.0.13rc1, 4.2.7rc1, 4.4.0alpha3, 4.4 (plan)

Type: Problem report Priority: Trivial
Reporter: Edgars Melveris Assignee: Andrejs Kozlovs
Resolution: Fixed Votes: 0
Labels: lld
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File LLD_error.PNG     PNG File bad_items.PNG     PNG File bad_prototype.PNG     PNG File good_prototype.PNG    
Issue Links:
Duplicate
Sub-task
Team: Team A
Sprint: Sprint 56 (Sep 2019), Sprint 55 (Aug 2019)
Story Points: 1

 Description   

I created a Host monitored by SNMP (48 port switch) and applied the template Template Net Network Generic Device SNMPv2 to it.
In Network Interfaces Discovery LLD I added a new item prototype with errors in configuration (item key uses incorrect LLD macro -

{#IFTYPE}, which in this case only returns 3 different values for 48 ports)

This created items:

And the rule itself has an error, which is expected:

Then I go and fix the incorrect item prototype like this:

The only thing changed was item key, using {#SNMPINDEX} instead of {#IFTYPE}

, which should be correct.

Result
Discovery rule no longer shows an error, but the created items are not updated, I still have the same 3 incorrect items. The log file shows this error:

27195:20190731:230041.063 [Z3005] query failed: [1062] Duplicate entry '10271-lld.bug.test[6]' for key 'items_1' [insert into items (itemid,name,key_,hostid,type,value_type,delay,history,trends,status,trapper_hosts,units,formula,logtimefmt,valuemapid,params,ipmi_sensor,snmp_community,snmp_oid,port,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,authtype,username,password,publickey,privatekey,description,interfaceid,flags,snmpv3_contextname,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,http_proxy,headers,retrieve_mode,request_method,output_format,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host,allow_traps) values (30741,'LLD BUG TEST 6 - 1','lld.bug.test[1]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.1','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30742,'LLD BUG TEST 6 - 2','lld.bug.test[2]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.2','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30743,'LLD BUG TEST 6 - 3','lld.bug.test[3]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.3','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30744,'LLD BUG TEST 6 - 4','lld.bug.test[4]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.4','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30745,'LLD BUG TEST 6 - 5','lld.bug.test[5]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.5','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30746,'LLD BUG TEST 6 - 6','lld.bug.test[6]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.6','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30747,'LLD BUG TEST 6 - 7','lld.bug.test[7]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.7','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30748,'LLD BUG TEST 6 - 8','lld.bug.test[8]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.8','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30749,'LLD BUG TEST 6 - 9','lld.bug.test[9]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.9','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30750,'LLD BUG TEST 6 - 10','lld.bug.test[10]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.10','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30751,'LLD BUG TEST 6 - 11','lld.bug.test[11]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.11','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30752,'LLD BUG TEST 6 - 12','lld.bug.test[12]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.12','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30753,'LLD BUG TEST 6 - 13','lld.bug.test[13]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.13','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30754,'LLD BUG TEST 6 - 14','lld.bug.test[14]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.14','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30755,'LLD BUG TEST 6 - 15','lld.bug.test[15]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.15','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30756,'LLD BUG TEST 6 - 16','lld.bug.test[16]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.16','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30757,'LLD BUG TEST 6 - 17','lld.bug.test[17]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.17','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30758,'LLD BUG TEST 6 - 18','lld.bug.test[18]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.18','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30759,'LLD BUG TEST 6 - 19','lld.bug.test[19]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.19','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30760,'LLD BUG TEST 6 - 20','lld.bug.test[20]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.20','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30761,'LLD BUG TEST 6 - 21','lld.bug.test[21]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.21','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30762,'LLD BUG TEST 6 - 22','lld.bug.test[22]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.22','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30763,'LLD BUG TEST 6 - 23','lld.bug.test[23]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.23','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30764,'LLD BUG TEST 6 - 24','lld.bug.test[24]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.24','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30765,'LLD BUG TEST 6 - 25','lld.bug.test[25]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.25','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30766,'LLD BUG TEST 6 - 26','lld.bug.test[26]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.26','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30767,'LLD BUG TEST 6 - 27','lld.bug.test[27]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.27','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30768,'LLD BUG TEST 6 - 28','lld.bug.test[28]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.28','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30769,'LLD BUG TEST 6 - 29','lld.bug.test[29]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.29','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30770,'LLD BUG TEST 6 - 30','lld.bug.test[30]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.30','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30771,'LLD BUG TEST 6 - 31','lld.bug.test[31]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.31','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30772,'LLD BUG TEST 6 - 32','lld.bug.test[32]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.32','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30773,'LLD BUG TEST 6 - 33','lld.bug.test[33]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.33','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30774,'LLD BUG TEST 6 - 34','lld.bug.test[34]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.34','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30775,'LLD BUG TEST 6 - 35','lld.bug.test[35]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.35','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30776,'LLD BUG TEST 6 - 36','lld.bug.test[36]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.36','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30777,'LLD BUG TEST 6 - 37','lld.bug.test[37]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.37','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30778,'LLD BUG TEST 6 - 38','lld.bug.test[38]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.38','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30779,'LLD BUG TEST 6 - 39','lld.bug.test[39]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.39','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30780,'LLD BUG TEST 6 - 40','lld.bug.test[40]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.40','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30781,'LLD BUG TEST 6 - 41','lld.bug.test[41]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.41','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30782,'LLD BUG TEST 6 - 42','lld.bug.test[42]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.42','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30783,'LLD BUG TEST 6 - 43','lld.bug.test[43]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.43','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30784,'LLD BUG TEST 6 - 44','lld.bug.test[44]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.44','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30785,'LLD BUG TEST 6 - 45','lld.bug.test[45]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.45','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30786,'LLD BUG TEST 6 - 46','lld.bug.test[46]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.46','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30787,'LLD BUG TEST 6 - 47','lld.bug.test[47]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.47','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30788,'LLD BUG TEST 6 - 48','lld.bug.test[48]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.48','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30789,'LLD BUG TEST 6 - 49','lld.bug.test[49]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.49','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30790,'LLD BUG TEST 6 - 50','lld.bug.test[50]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.50','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30791,'LLD BUG TEST 6 - 51','lld.bug.test[51]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.51','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30792,'LLD BUG TEST 53 - 102','lld.bug.test[102]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.102','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30793,'LLD BUG TEST 53 - 104','lld.bug.test[104]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.104','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30794,'LLD BUG TEST 53 - 105','lld.bug.test[105]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.105','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30795,'LLD BUG TEST 53 - 106','lld.bug.test[106]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.106','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30796,'LLD BUG TEST 53 - 107','lld.bug.test[107]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.107','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0),(30797,'LLD BUG TEST 53 - 108','lld.bug.test[108]',10271,4,3,'30s','90d','365d',0,'','','','',null,'','','{$SNMP_COMMUNITY}','1.3.6.1.2.1.2.2.1.13.108','','',0,0,'',0,'',0,'','','','','',8,4,'','',null,'3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0);
]


 Comments   
Comment by Aigars Kadikis [ 2019 Aug 08 ]

This problem is also persistent on version 4.0.11.

I'm feeding the following array in discovery:

{
	"data": [{
		"{#NR}": "1",
		"{#NAME}": "2",
		"{#AGE}": "32"
	}, {
		"{#NR}": "2",
		"{#NAME}": "peter",
		"{#AGE}": "33"
	}]
}

First time I create one item prototype with

key[{#NAME}]

Allow for items to create. Then I modify the template and set a different item prototype:

key[{#NR}]

Based on the content inside JSON there can be a conflict upcoming because we have one {#NAME} with value 2 and one {#NR} with value 2.

On the next discovery cycle, Zabbix is able to maintain items (visually).

When we swap back the item prototype definition to 'key{#NAME}'. The log file will state:

6649:20190808:180356.956 [Z3005] query failed: [1062] Duplicate entry '10084-item[2]' for key 'items_1' [update items set key_='item[2]' where itemid=28849;
update item_discovery set key_='item[{#NAME}]' where itemid=28849;
update items set key_='item[peter]' where itemid=28850;
update item_discovery set key_='item[{#NAME}]' where itemid=28850;
]

There are no errors inside the discovery section inside GUI.

Comment by Andrejs Kozlovs [ 2019 Sep 03 ]

Fixed in:

  • 4.0.13rc1 689d8e4127d
  • 4.2.7rc1 341b03b392a
  • 4.4.0alpha3 (master) 116541476db
Generated at Thu Mar 28 14:23:17 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.