Upgrade Zabbix from 2.0x to 2.2

Posted by: acaleechurn on: 23/11/2013

• In: CentOS | Fedora | Linux | Open Source | Red Hat | SnowBird Linux
• Leave a Comment

I decided to upgrade my Zabbix instance to 2.2 as the upgrade process is supposed to be easier since the database upgrade is performed by the server. Grabbed and installed the latest zabbix-release rpm, fired up yum update and to my surprise no updates 😦 .. It had to be done manually, so I did a rpm -qa | grep zabbix and downloaded the matching updates. This time it worked when running yum localinstall *.rpm , so that had to be it. Pointed my browser to the Zabbix url and that’s when disaster struck ” Database error: The frontend does not match the Zabbix database” A quick look at the server log revealed that the database upgrade failed since it’s trying to drop an inexistent column (lastvalue) from the items table.  Let’s make the database upgrade script happy by creating the missing column (as it will drop it in any case) and restart the server.

mysql -u root -p

use zabbix;

ALTER TABLE items ADD lastvalue VARCHAR(60);

Restart the Zabbix server using service zabbix-server restart and watch the Zabbix server log, the database upgrade process will be shown and once complete you can login again to your instance. Hope this saves someone some frustration.