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

            is duplicated by

            Incident report - Incident report ZBX-7514 PostgreSQL fatal error after upgrade to Zabbix 2.2.1

            • Major - Major loss of function.
            • Closed

            Incident report - Incident report ZBX-7584 Unknown column 'impi_errors_from' in 'field list'

            • Major - Major loss of function.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              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
              Permalink
              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
              Permalink
              Andris Zeila added a comment -

              Successfully tested

              Show
              Andris Zeila added a comment - Successfully tested
              Hide
              Permalink
              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
              Permalink
              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: