Hello,
I am using zabbix 2.4.2. I am using perl script for adding/updating zabbix hosts via zabbix API call.This script run at 10mins interval. I am getting different API errors for every execution. Below is the one example where it thrown 3 API errors and then added host "varnishInstance" successfully. I am not sure why it's throwing ERROR and working after few attempts.
==================================
Error adding varnishInstance
ERROR: Application error.
SQL statement execution has failed "INSERT INTO item_discovery (itemid,parent_itemid,itemdiscoveryid) VALUES ('2710246','2710203','1224510')".
==================================
After 10 mins it thrown different error like
Error adding varnishInstance
ERROR: 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".
==================================
In 3rd attempt it printed below error.
Error adding varnishInstance
ERROR: Application error.
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')".
And finally in 4th attempt it added instance successfully.
========================
Please let me know what is causing this error and what needs to be done to fix this.
Thanks,
Pushpraj
I am using zabbix 2.4.2. I am using perl script for adding/updating zabbix hosts via zabbix API call.This script run at 10mins interval. I am getting different API errors for every execution. Below is the one example where it thrown 3 API errors and then added host "varnishInstance" successfully. I am not sure why it's throwing ERROR and working after few attempts.
==================================
Error adding varnishInstance
ERROR: Application error.
SQL statement execution has failed "INSERT INTO item_discovery (itemid,parent_itemid,itemdiscoveryid) VALUES ('2710246','2710203','1224510')".
==================================
After 10 mins it thrown different error like
Error adding varnishInstance
ERROR: 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".
==================================
In 3rd attempt it printed below error.
Error adding varnishInstance
ERROR: Application error.
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')".
And finally in 4th attempt it added instance successfully.
========================
Please let me know what is causing this error and what needs to be done to fix this.
Thanks,
Pushpraj