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

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 2.2.2rc1, 2.3.0
    • 2.2.1
    • Server (S)
    • None
    • Ubuntu 12.04

      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

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

              Created:
              Updated:
              Resolved: