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

Error when copying items with identical keys to other hosts or templates

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.2.17rc1, 3.0.8rc1, 3.2.4rc1, 3.4.0alpha1
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
    • Team:
      Team C
    • Sprint:
      Sprint 3
    • Story Points:
      0.5

      Description

      When copy items with identical keys to other hosts or templates, appears the following error:

      Error in query [INSERT INTO items (type,snmp_community,snmp_oid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,filter,port,description,inventory_link,interfaceid,hostid,itemid) VALUES ('0','','','test','item.key','30','90','365','0','3','','','0','0','','','0','0','','0','','1','',NULL,'','','','0','0','','','','','0','','','','0','2','10105','23669')] [Duplicate entry '10105-item.key' for key 'items_1']
      SQL statement execution has failed "INSERT INTO items (type,snmp_community,snmp_oid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,filter,port,description,inventory_link,interfaceid,hostid,itemid) VALUES ('0','','','test','item.key','30','90','365','0','3','','','0','0','','','0','0','','0','','1','',NULL,'','','','0','0','','','','','0','','','','0','2','10105','23669')".
      

      Steps to reproduce:
      1. Create identical items with key 'item.key' for two different hosts
      2. Go to Configuration->Hosts->Items
      3. Reset filter and search by item key 'item.key'
      4. Select items with key 'item.key'
      5. Press button 'Copy' and choose target for other host or template
      Expected error: Item with key "item.key" already exists on "Host".

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            natalja.zabbix Natalja Romancaka (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: