Database error after upgrade to 5.0.2.

[Rensjeh]

Hi, I'm getting the following error after upgrading from 4.4.0 to 5.0.2.

The frontend does not match Zabbix database. Current database version (mandatory/optional): 5000000/5000001. Required mandatory version: 4040000. Contact your system administrator.



I used https://www.zabbix.com/documentation...es/rhel_centos to upgrade Zabbix with my CentOS 7 client.
In the /var/log/zabbix/zabbix_server.log the database should be version 05000000/05000001.

27211:20200728:043721.923 completed 99% of database upgrade
27211:20200728:043721.925 completed 100% of database upgrade
27211:20200728:043721.925 database upgrade fully completed
27211:20200728:043721.985 database is not upgraded to use double precision values
5985:20200728:044307.651 current database version (mandatory/optional): 05000000/05000001


What else can I check or do?

[Hamardaban]

You updated the server, but not the frontend.

Zabbix frontend is written in PHP, so to run it a PHP supported webserver is needed. Installation is done by simply copying the PHP files from the ui directory to the webserver HTML documents directory.

[Rensjeh]

Indeed something went wrong with updating the front-end in combination with CentOS 7.
If more people have this problem, here some fine documentation:

Begin at step 10:
https://bestmonitoringtools.com/upgr...ecision_values
And this hero: https://www.youtube.com/watch?v=6A4JJHjUoTc

[jorry]

I solved this below ↓

1. yum remove zabbix-web*
2. mv /ui/* /opt/zabbix-backup/
-> in case of me, /ui/ = /usr/shar/zabbix
3. yum install zabbix-web zabbix-web-pgsql-scl

remove current zabbix frontend packages -> clean the ui directory(backup or whaterver) -> reinstall zabbix frontend packages

It will useful when "Required mandatory version" is lower than "Current database version".
many thanks.