-
Type:
Incident report
-
Resolution: Fixed
-
Priority:
Major
-
None
-
Affects Version/s: 1.6
-
Component/s: Frontend (F)
-
None
-
Environment: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.