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

unknown column errors with node setup

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Critical Critical
    • None
    • 1.8.17, 2.0.9, 2.2.0
    • Server (S)
    • One Master node, one subordinate node, 7 proxies.
      Ubuntu 12.04
      MySQL 5.6

      We migrated our 1.8.17 setup to 2.0.9.

      After the migration the subordinate node starts complaining with hundreds of messages which look like the following messages:

      9833:20131030:181502.203 [Z3005] query failed: [1054] Unknown column 'macro' in 'field list' [select macro from graphs_items where gitemid=200200000002550]
      6201:20131030:095437.095 [Z3005] query failed: [1054] Unknown column 'internal' in 'field list' [select name,internal,name,hsize,vsize,templateid from hosts where hostid=200200000010246]

      The hostids and gitemids are changing always in every logline.
      After the master node synchronized with the subordinate node, both zabbix nodes are complaining in the same way.
      (both servers complain only about ids which have a leading "2" - the id of the subordinate server)

      Naturally we executed the database migration script and we checked the output for errors.
      We compared the migrated database ddl schema with a newly created zabbix database schema - they are almost identical
      (only very simple differences which cannot be the source of the problem).
      Therefore i'm sure that this problem is not the result of a failed migration.

      It seems that zabbix-server uses a dynamically created sql statement - because "select macro from graphs_items" cannot be found in the zabbix sourcecode,

      The error message complains about the columns "macro" and "internal" - these columns are not part of any 1.8.17 or 2.0.9 database schema.
      We tested the zabbix webgui for problems with graphs and we have not discovered any problem.

      I you need to analyze this situation in detail, please requests additional information.
      (Logfiles, Debug Output, SQL-Queries, ...)

        1. applications_cksums_broken
          299 kB
          Oleksii Zagorskyi
        2. applications_cksums_working
          278 kB
          Oleksii Zagorskyi
        3. dbschema.c
          414 kB
          Marc Schoechlin

            Unassigned Unassigned
            scoopex Marc Schoechlin
            Votes:
            7 Vote for this issue
            Watchers:
            16 Start watching this issue

              Created:
              Updated:
              Resolved: