-
Incident report
-
Resolution: Fixed
-
Major
-
None
-
1.6
-
None
-
PostgreSQL
When I'm trying to import a template, zabbix webgui processes it forever. As i've checked logs, finally the DB server log, it turns out, that one of the queries has a syntax error, but the webgui fails to notice that 1) it has a wrong query 2) it's in a failed transaction, that it can never finish successfully (no point in going on).
The query:
INSERT INTO items (itemid,description,key_,hostid,delay,history,nextcheck,status,type,snmp_community,snmp_oid,value_type,trapper_hosts,snmp_port,units,multiplier,delta,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,formula,trends,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,templateid) VALUES (31224,'ifDescr.1','ifDescr.1',10074,60,7,0,0,1,'public','1.3.6.1.2.1.2.2.1.2.1',0,'',161,'B',,1,'',0,'','','1',365,'',0,'','','',0)
the error is at the 435th character.