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

LLD doesn't correctly update items when item prototype is fixed

    Details

    • 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);
      ]

        Attachments

        1. bad_items.PNG
          bad_items.PNG
          6 kB
        2. bad_prototype.PNG
          bad_prototype.PNG
          12 kB
        3. good_prototype.PNG
          good_prototype.PNG
          12 kB
        4. LLD_error.PNG
          LLD_error.PNG
          32 kB

          Activity

            People

            • Assignee:
              ak Andrejs Kozlovs
              Reporter:
              zux Edgars Melveris
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: