2.0.9 -> 2.2

[LenR]

I'm getting these messages in the log after conversion, several every few minutes.

[Z3005] query failed: [1054] Unknown column 'type' in 'field list' [select type from applications where applicationid=1101100000000001]

The don't seem to be causing any problems.

[aink999]

Same for me

Hi same for me I've upgraded from 2.0.2 to 2.2.1

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 |

[aink999]

Bug report

I've post a bug report https://support.zabbix.com/browse/ZBX-7644
we will see.