-
Incident report
-
Resolution: Cannot Reproduce
-
Minor
-
None
-
2.2.17rc1, 3.0.8rc1, 3.2.4rc1, 3.4.0alpha1
-
Sprint 3
-
0.5
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".
