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

[Z3005] query failed: [1054] Unknown column 'impi_disable_until' in 'field list'

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.1
    • Fix Version/s: 2.2.2rc1, 2.3.0
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Ubuntu 12.04

      Description

      Since the upgrade from Zabbix 2.2.0 to 2.2.1 we get the log entries like this:

      20808:20131210:132514.061 [Z3005] query failed: [1054] Unknown column 'impi_disable_until' in 'field list' [update hosts set impi_disable_until=1386678374,impi_error='cannot connect to IPMI host: [16777411] Unknown error 16777411' where hostid=10086]
      20808:20131210:132520.070 [Z3005] query failed: [1054] Unknown column 'impi_disable_until' in 'field list' [update hosts set impi_disable_until=1386678335,impi_error='cannot connect to IPMI host: [16777345] Unknown error 16777345' where hostid=10109]

      Obviously there is a typo, because usually there are filed with name "ipmi_disable_until" but not "impi_disable_until" (m and p swapped).

      Searching trough the source code, I found the problematic place:
      src\zabbix_server\poller\poller.c line 236

      << sqlset_prefix = "impi_";
      >> sqlset_prefix = "ipmi_";

      Changing this and recompiling made the error go away

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                alpilotx Andras Fabian
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: