Log errors - something trying to access nonexistent columns after upgrade

[dlalonde]

We recently upgraded from zabbix-server 1.8.11-9 to 2.2.1-9. We have a master and a child node and both were upgraded. The agents are still at 1.8.11.

We're getting dozens of the following errors in the zabbix server log every minute or two:

  4288:20140108:124601.568 [Z3005] query failed: [1054] Unknown column 'groupid' in 'field list' [select groupid,parent_group_prototypeid,name,delay from hosts where hostid=200200000010040]
  4288:20140108:124601.568 [Z3005] query failed: [1054] Unknown column 'groupid' in 'field list' [select groupid,parent_group_prototypeid,name,delay from hosts where hostid=200200000010041]
  4288:20140108:124601.568 [Z3005] query failed: [1054] Unknown column 'groupid' in 'field list' [select groupid,parent_group_prototypeid,name,delay from hosts where hostid=200200000010042]
  4288:20140108:124601.568 [Z3005] query failed: [1054] Unknown column 'groupid' in 'field list' [select groupid,parent_group_prototypeid,name,delay from hosts where hostid=200200000010043]
  4288:20140108:124601.568 [Z3005] query failed: [1054] Unknown column 'groupid' in 'field list' [select groupid,parent_group_prototypeid,name,delay from hosts where hostid=200200000010044]
  4288:20140108:124601.568 [Z3005] query failed: [1054] Unknown column 'groupid' in 'field list' [select groupid,parent_group_prototypeid,name,delay from hosts where hostid=200200000010045]
  4288:20140108:124601.568 [Z3005] query failed: [1054] Unknown column 'groupid' in 'field list' [select groupid,parent_group_prototypeid,name,delay from hosts where hostid=200200000010046]
  4288:20140108:124602.816 [Z3005] query failed: [1054] Unknown column 'hostid' in 'field list' [select hostid from graphs_items where gitemid=200100000000003]
  4288:20140108:124602.816 [Z3005] query failed: [1054] Unknown column 'hostid' in 'field list' [select hostid from graphs_items where gitemid=200100000000004]
  4288:20140108:124602.816 [Z3005] query failed: [1054] Unknown column 'hostid' in 'field list' [select hostid from graphs_items where gitemid=200100000000005]
  4288:20140108:124602.817 [Z3005] query failed: [1054] Unknown column 'hostid' in 'field list' [select hostid from graphs_items where gitemid=200100000000006]
  4288:20140108:124602.817 [Z3005] query failed: [1054] Unknown column 'hostid' in 'field list' [select hostid from graphs_items where gitemid=200100000000007]

We don't see 'hostid' in the table 'graphs_items' in any of the zabbix schemas going back to 1.6 and it's not in the 2.2 schema. We don't know what's issuing that query, but the errors stop when we turn off the zabbix-server on the client node.

We're running this on solaris containers on i86 hardware:

$ uname -a
SunOS zabbix-lab-server 5.10 Generic_147441-12 i86pc i386 i86pc Solaris

We didn't see this on the earlier versions. Anyone see this before? Thanks in advance.

[jan.garaj]

Did you upgrade zabbix-frontend-php too?
Did your restart/reload web server (Apache) for zabbix-frontend-php?

I didn't find column 'hostid' in DDL for table graphs_items in Zabbix version 1.6.9, 1.8.19, 2.2.1. Do you use some scripts with direct access to Zabbix DB or Zabbix API?

You can increase verbose level for Zabbix server logging and then you can check what Zabbix server do, when SQL error is occurred.

[dlalonde]

We did update the frontend to the same version, restarted apache, and have no scripts, crons or UserParameters that directly access the db. Debug=4 didn't show anything related either. Digging into the db to see if I can figure out what's issuing those queries ...

[Alberto]

We have the same problem

Hello,

Whe have two servers, one master & one child. All two have this errors on zabbix_server.log

[Z3005] query failed: [1054] Unknown column 'hostid' in 'field list' [select hostid from graphs_items where gitemid=200200000000732]


Have you found the way to solve it?

Thanks.
Alberto.