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'

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.2.1
    • 2.2.2rc1, 2.3.0
    • Server (S)
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: