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

Illegal query at sending of the configuration data on a proxy-server, if a configuration empty

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 1.9.1 (alpha)
    • 1.9.1 (alpha)
    • Proxy (P), Server (S)
    • None
    • releng_8, mysql 5.5, zabbix revision 15285

    Description

      empty "where" section in query:

      70466:20101106:150924.400 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by t.hostid' at line 1 [select t.hostid,t.host,t.dns,t.useip,t.ip,t.port,t.useipmi,t.ipmi_port,t.ipmi_authtype,t.ipmi_privilege,t.ipmi_username,t.ipmi_password,t.ipmi_ip from hosts t where order by t.hostid]
      70466:20101106:150924.400 [Z3005] Query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by t.hostmacroid' at line 1 [select t.hostmacroid,t.hostid,t.macro,t.value from hostmacro t where order by t.hostmacroid]
      70466:20101106:150924.401 Sending configuration data to proxy 'msk-be-vpn201'. Datalen 1103

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jimson Vladimir Kravchenko
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: