[ZBX-915] Zabbix WebGUI continues a failed transaction Created: 2009 May 11  Updated: 2017 May 30  Resolved: 2009 Sep 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.6
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Gergely Czuczy Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

PostgreSQL


Attachments: XML File void.snmp.xml    

 Description   

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.



 Comments   
Comment by Gergely Czuczy [ 2009 Jul 01 ]

This file generates such an error, because it tries to insert an item, where the trapper_hosts parameter is missing in the VALUES. I've got this with 1.6.4 and pgsql8.3 backend.

Comment by Artem Suharev (Inactive) [ 2009 Sep 30 ]

Confirm the problem. It will be fixed in ZBX 1.6.7 and ZBX 1.8

Comment by richlv [ 2009 Nov 10 ]

close old, resolved issues

Generated at Fri Mar 29 13:40:48 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.