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

Zabbix WebGUI continues a failed transaction

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • None
    • 1.6
    • Frontend (F)
    • 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.

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

              Created:
              Updated:
              Resolved: