upgrade to v2.2.0

[beeloo]

After upgraded to v2.2.0 and ran the setup.php on the web browser, I received below message:


Configuration file error: The frontend does not match Zabbix database. Current database version (mandatory/optional): 2010033/2010033. Required mandatory version: 2020000. Contact your system administrator.

Please advise.

Thanks
Beeloo

[beeloo]

Actually, I noticed the database is upgrading automatically now from the log..

9679:20131112:083746.907 completed 7% of database upgrade
9679:20131112:083746.972 completed 8% of database upgrade
9679:20131112:083747.030 completed 9% of database upgrade
9679:20131112:083747.051 completed 10% of database upgrade
9679:20131112:083747.449 completed 11% of database upgrade
9679:20131112:083748.865 completed 12% of database upgrade
9679:20131112:083748.990 completed 13% of database upgrade
9679:20131112:083749.014 completed 14% of database upgrade
9679:20131112:083749.017 completed 15% of database upgrade
9679:20131112:083749.036 completed 16% of database upgrade

[novoselov.ai]

You were quick to connect to the database. I have another problem. Database updated, the server is up. A web frontend does not connect. Even in the setting mode. Connection test fails.

The frontend does not match Zabbix database.



p.s. DB - POSTGRESQL

[beeloo]

That's weird. I'm using mysql DB and it was fine.

[Jason]

After I upgraded test machine there is no history displaying in the GUI... postgres database

[beeloo]

I had the problem when I killed the database upgrade and restart the zabbix_server again and it failed for database upgrade, so I had to restore the database and do it again. After that, it is working. I'm using mysql DB. I wonder if there is bug for POSTGRESQL database upgrade.

[bezarsnba]

Hi,

I had the same problem, and decided upgrading Php and MariaDB and solved.

How? I don't know


Beza

[kenta]

Hi. I'm having the same issue and my database is not upgrading for some reason.

4201:20131207:153623.877 Starting Zabbix Server. Zabbix 2.2.0 (revision 40163).
4201:20131207:153623.877 ****** Enabled features ******
4201:20131207:153623.877 SNMP monitoring: YES
4201:20131207:153623.877 IPMI monitoring: YES
4201:20131207:153623.877 WEB monitoring: YES
4201:20131207:153623.877 VMware monitoring: YES
4201:20131207:153623.877 Jabber notifications: YES
4201:20131207:153623.877 Ez Texting notifications: YES
4201:20131207:153623.877 ODBC: YES
4201:20131207:153623.877 SSH2 support: YES
4201:20131207:153623.878 IPv6 support: YES
4201:20131207:153623.878 ******************************
4201:20131207:153623.878 using configuration file: /etc/zabbix/zabbix_server.conf
4201:20131207:153623.883 current database version (mandatory/optional): 02010033/02010033
4201:20131207:153623.884 required mandatory version: 02020000
4201:20131207:153623.884 starting automatic database upgrade
4201:20131207:153623.884 [Z3005] query failed: [1091] Can't DROP 'value_changed'; check
that column/key exists [alter table events drop column value_changed]
4201:20131207:153623.884 database upgrade failed

Is there anyway of working around this?

Regards

[d-g-l-80]

Hi,

I had the same problem. I fixed it by upgrading my Ubuntu Distro:

apt-get dist-upgrade -u

The problem was that the zabbix-mysql didn't upgrade automatically.

After rebooting everything is fine.

Good luck!

Danny

[ebonweaver]

Same issue going to 2.4

I see this same issue, and tons of forum posts in multiple languages all over the web about it. Seems there are problems in many cases with upgrading to a new zabbix version where the database does not work for some reason.

Database error
The frontend does not match Zabbix database. Current database version (mandatory/optional): 2010033/2010033. Required mandatory version: 2040000. Contact your system administrator.

Does anyone know how to fix this or force the database to upgrade since the update apparently isn't doing it properly? I also note that the new zabbix agent fails to install for some reason.

invoke-rc.d: initscript zabbix-agent, action "start" failed.
dpkg: error processing zabbix-agent (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
zabbix-agent
E: Sub-process /usr/bin/dpkg returned an error code (1)

Lastly, it's relevant to note that the front end updated fine, but the server needed to be specifically installed (sudo apt-get install zabbix-server-mysql) because it was being "kept back" for unknown reasons.

Ubuntu 12.0.4 server LTS

[DreamMark]

Hi,

I had the same problem. I fixed it by upgrading my Ubuntu Distro:

apt-get dist-upgrade -u

The problem was that the zabbix-mysql didn't upgrade automatically.

After rebooting everything is fine.

Good luck!

Danny

Thanks. That resolved it for me as well on Debian Wheezy.

Using packages on a test server I installed Zabbix 2.0 and then installed Zabbix 2.4.5 right on top of it. This gave me the error "frontend does not match Zabbix database."

apt-get dist-upgrade -u

And then restarting zabbix resolved it.