Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-915

Zabbix WebGUI continues a failed transaction

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Labels:
      None
    • Environment:
      PostgreSQL

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              phoemix Gergely Czuczy
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: