[ZBX-5434] SQL error when linking template to host Created: 2012 Aug 09  Updated: 2017 May 30  Resolved: 2012 Sep 03

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.0.2rc2
Fix Version/s: 2.0.3rc1, 2.1.0

Type: Incident report Priority: Blocker
Reporter: Toms (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: SQL, template
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File zbx.png    

 Description   

Create host with one item
Create template with discovery rule with item prototype
Make sure that item and item prototype keys are the same

Try to link template to host

error:

Created: Discovery rule "terdisc" on "thost".
Error in query [INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,filter,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10168','terdiscitem','','agent.version','30','90','365','0','3','','','0','0','','0','','','1','',NULL,'','','','0','0','','','','','2','','','0','30','10114','26322','26325')] [Duplicate entry '10168-agent.version' for key 2]
SQL statement execution has failed "INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,description,key_,delay,history,trends,status,value_type,trapper_hosts,units,multiplier,delta,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,formula,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,filter,port,inventory_link,lifetime,interfaceid,templateid,itemid) VALUES ('0','','','10168','terdiscitem','','agent.version','30','90','365','0','3','','','0','0','','0','','','1','',NULL,'','','','0','0','','','','','2','','','0','30','10114','26322','26325')". [CHost.update -> CHost.massUpdate -> CHost.massAdd -> CTemplate.massAdd -> CTemplate.link -> CItemPrototype.syncTemplates -> CItemPrototype.inherit -> CItemPrototype.createReal -> DB.insert]



 Comments   
Comment by Eduards Samersovs (Inactive) [ 2012 Sep 03 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-5434

Comment by Eduards Samersovs (Inactive) [ 2012 Sep 04 ]

Fixed in versions pre-2.1.0 (beta) r30093, pre-2.0.3 r30092

Generated at Fri Apr 26 23:51:30 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.