I have a perl script which automates the process of adding new hosts using the host.create API. Often I find that it throws up random error multiple times before finally adding the host to zabbix. Possible error messages are:

SQL statement execution has failed "INSERT INTO item_discovery (itemid,parent_itemid,itemdiscoveryid) VALUES ('2710246','2710203','1224510')".

Invalid params.

Cannot implode expression "{ip-x-x-x-x:vfs.file.regmatch[/etc/puppet/puppet.conf,"runinterval = 0"].last(0)}<1". Incorrect item key "vfs.file.regmatch[/etc/puppet/puppet.conf,"runinterval = 0"]" provided for trigger expression on "ip-x-x-x-x".

SQL statement execution has failed "INSERT INTO items (type,snmp_community,snmp_oid,hostid,name,descript ion,key_,delay,history,trends,status,value_type,tr apper_hosts,units,multiplier,delta,snmpv3_contextn ame,snmpv3_securityname,snmpv3_securitylevel,snmpv 3_authprotocol,snmpv3_authpassphrase,snmpv3_privpr otocol,snmpv3_privpassphrase,formula,logtimefmt,va luemapid,delay_flex,params,ipmi_sensor,data_type,a uthtype,username,password,publickey,privatekey,fla gs,port,inventory_link,lifetime,templateid,itemid) VALUES ('2','','','30188','OpenFiles: Used Percent','','openFiles.usedPercent','300','7','45' ,'0','0','','%','0','0','','','0','0','','0','','1 ','',NULL,'','','','0','0','','','','','0','','0', '30','154825','2710281')".

Looks like a bug that causes this unpredictable behaviour. They is not method to failure of the API calls. It's just very random. Error messages thrown up by the API response are not useful in determining the cause of issue.