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

Unknown column 'type' in 'field list' [select type from applications where

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.2.1
    • Server (S)
    • None
    • CentOS release 6.4 (Final)
       2.6.32-358.11.1.el6.x86_64 #1 SMP Wed Jun 12 03:34:52 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
      mysql-server-5.1.69-

      Hi after I've upgraded from 2.0.6 to 2.2.1 I can see these error in the log.

      1 657:20140113:141541.193 [Z3005] query failed: [1054] Unknown column 'type' in 'field list' [select type from applications where applicationid=200200000000822]
      1 657:20140113:141541.193 [Z3005] query failed: [1054] Unknown column 'type' in 'field list' [select type from applications where applicationid=200200000000823]
      1 657:20140113:141541.193 [Z3005] query failed: [1054] Unknown column 'type' in 'field list' [select type from applications where applicationid=200200000000824]
      1 657:20140113:141541.193 [Z3005] query failed: [1054] Unknown column 'type' in 'field list' [select type from applications where applicationid=200200000000825]
      1 657:20140113:141541.193 [Z3005] query failed: [1054] Unknown column 'type' in 'field list' [select type from applications where applicationid=200200000000826]
      1 657:20140113:141541.193 [Z3005] query failed: [1054] Unknown column 'type' in 'field list' [select type from applications where applicationid=200200000000827]

      From what I can see there really no column called type

      mysql> describe applications;
      -----------------------------------------------------+

      Field Type Null Key Default Extra

      -----------------------------------------------------+

      applicationid bigint(20) unsigned NO PRI NULL  
      hostid bigint(20) unsigned NO MUL NULL  
      name varchar(255) NO      

      -----------------------------------------------------+
      3 rows in set (0.00 sec)

      mysql> select type from applications ;
      ERROR 1054 (42S22): Unknown column 'type' in 'field list'

      mysql> select name from applications ;
      -----------------------------------------------------

      name

      -----------------------------------------------------

      CPU
      Filesystems
      General
      Memory
      Network interfaces
      OS
      Performance
      Processes
      Security

            Unassigned Unassigned
            aink999 Sebastien Chartrand
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: