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 Incident report
    • Status: Closed
    • Priority: Major 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

        Issue Links

          Activity

          Hide
          Aleksandrs Saveljevs added a comment -

          Introduced in r40376 while fixing ZBX-7184.

          Show
          Aleksandrs Saveljevs added a comment - Introduced in r40376 while fixing ZBX-7184 .
          Hide
          Aleksandrs Saveljevs added a comment -

          Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-7516 .

          Show
          Aleksandrs Saveljevs added a comment - Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-7516 .
          Hide
          Andris Zeila added a comment -

          Successfully tested

          Show
          Andris Zeila added a comment - Successfully tested
          Hide
          Aleksandrs Saveljevs added a comment -

          Fixed in pre-2.2.2rc1 r40889 and pre-2.3.0 (trunk) r40890.

          Show
          Aleksandrs Saveljevs added a comment - Fixed in pre-2.2.2rc1 r40889 and pre-2.3.0 (trunk) r40890.
          Hide
          AndreaConsadori added a comment -

          same issue in centos 6 and mysql db

          Show
          AndreaConsadori added a comment - same issue in centos 6 and mysql db

            People

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

              Dates

              • Created:
                Updated:
                Resolved: