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

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.1 (alpha)
    • Fix Version/s: 1.9.1 (alpha)
    • Component/s: Proxy (P), Server (S)
    • Labels:
      None
    • Environment:
      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

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

                Dates

                Created:
                Updated:
                Resolved: