Issues with upgrading from 5.2 to 5.4 (Database version does not match)

[UntestedEngineer]

Hello,

It seems I am having a weird issue upgrading from 5.2 to 5.4. I am running Ubuntu 20.04 with PGSQL as the database. Every time I perform the upgrade it succeeds and logs indicate the database is successful in the upgrade but whenever I clear cookies and cache I receive the following error. I have started and stopped the zabbix server process multiple times after this with no change. I have followed the upgrade procedure on the main zabbix website.

Database error

• The Zabbix database version does not match current requirements. Your database version: 5040000. Required version: 5020000. Please contact your system administrator.

83973:20210612:115115.224 Starting Zabbix Server. Zabbix 5.4.1 (revision ecb5b3378c).
83973:20210612:115115.225 ****** Enabled features ******
83973:20210612:115115.225 SNMP monitoring: YES
83973:20210612:115115.225 IPMI monitoring: YES
83973:20210612:115115.225 Web monitoring: YES
83973:20210612:115115.225 VMware monitoring: YES
83973:20210612:115115.225 SMTP authentication: YES
83973:20210612:115115.225 ODBC: YES
83973:20210612:115115.225 SSH support: YES
83973:20210612:115115.225 IPv6 support: YES
83973:20210612:115115.225 TLS support: YES
83973:20210612:115115.225 ******************************
83973:20210612:115115.225 using configuration file: /etc/zabbix/zabbix_server.conf
83973:20210612:115115.269 current database version (mandatory/optional): 05020000/05020000
83973:20210612:115115.269 required mandatory version: 05040000
83973:20210612:115115.269 starting automatic database upgrade
83973:20210612:115115.271 completed 0% of database upgrade
83973:20210612:115115.298 completed 1% of database upgrade
83973:20210612:115115.302 completed 2% of database upgrade
83973:20210612:115115.311 completed 3% of database upgrade
83973:20210612:115115.313 completed 4% of database upgrade
83973:20210612:115115.317 completed 5% of database upgrade
83973:20210612:115115.318 completed 6% of database upgrade
83973:20210612:115115.320 completed 7% of database upgrade
83973:20210612:115115.322 completed 8% of database upgrade
83973:20210612:115115.323 completed 9% of database upgrade
83973:20210612:115115.325 completed 10% of database upgrade
83973:20210612:115115.326 completed 11% of database upgrade
83973:20210612:115115.328 completed 12% of database upgrade
83973:20210612:115115.330 completed 13% of database upgrade
83973:20210612:115115.338 completed 14% of database upgrade
83973:20210612:115115.341 completed 15% of database upgrade
83973:20210612:115115.345 completed 16% of database upgrade
83973:20210612:115115.348 completed 17% of database upgrade
83973:20210612:115115.352 completed 18% of database upgrade
83973:20210612:115115.356 completed 19% of database upgrade
83973:20210612:115115.360 completed 20% of database upgrade
83973:20210612:115115.362 completed 21% of database upgrade
83973:20210612:115115.365 completed 22% of database upgrade
83973:20210612:115115.368 completed 23% of database upgrade
83973:20210612:115115.719 completed 24% of database upgrade
83973:20210612:115115.724 completed 25% of database upgrade
83973:20210612:115115.726 completed 26% of database upgrade
83973:20210612:115115.727 completed 27% of database upgrade
83973:20210612:115115.729 completed 28% of database upgrade
83973:20210612:115115.731 completed 29% of database upgrade
83973:20210612:115115.732 completed 30% of database upgrade
83973:20210612:115115.733 completed 31% of database upgrade
83973:20210612:115115.734 completed 32% of database upgrade
83973:20210612:115115.735 completed 33% of database upgrade
83973:20210612:115115.737 completed 34% of database upgrade
83973:20210612:115115.738 completed 35% of database upgrade
83973:20210612:115115.739 completed 36% of database upgrade
83973:20210612:115115.740 completed 37% of database upgrade
83973:20210612:115115.741 completed 38% of database upgrade
83973:20210612:115115.742 completed 39% of database upgrade
83973:20210612:115115.744 completed 40% of database upgrade
83973:20210612:115115.746 completed 41% of database upgrade
83973:20210612:115115.748 completed 42% of database upgrade
83973:20210612:115115.750 completed 43% of database upgrade
83973:20210612:115115.754 completed 44% of database upgrade
83973:20210612:115115.757 completed 45% of database upgrade
83973:20210612:115115.759 completed 46% of database upgrade
83973:20210612:115115.761 completed 47% of database upgrade
83973:20210612:115115.774 completed 48% of database upgrade
83973:20210612:115115.778 completed 49% of database upgrade
83973:20210612:115115.781 completed 50% of database upgrade
83973:20210612:115115.785 completed 51% of database upgrade
83973:20210612:115115.788 completed 52% of database upgrade
83973:20210612:115115.789 completed 53% of database upgrade
83973:20210612:115115.790 completed 54% of database upgrade
83973:20210612:115115.794 completed 55% of database upgrade
83973:20210612:115115.797 completed 56% of database upgrade
83973:20210612:115115.801 completed 57% of database upgrade
83973:20210612:115115.803 completed 58% of database upgrade
83973:20210612:115115.806 completed 59% of database upgrade
83973:20210612:115115.809 completed 60% of database upgrade
83973:20210612:115116.076 completed 61% of database upgrade
83973:20210612:115116.078 completed 62% of database upgrade
83973:20210612:115116.084 completed 63% of database upgrade
83973:20210612:115116.085 completed 64% of database upgrade
83973:20210612:115116.088 completed 65% of database upgrade
83973:20210612:115116.090 completed 66% of database upgrade
83973:20210612:115116.091 completed 67% of database upgrade
83973:20210612:115116.096 completed 68% of database upgrade
83973:20210612:115116.099 completed 69% of database upgrade
83973:20210612:115116.104 completed 70% of database upgrade
83973:20210612:115116.110 completed 71% of database upgrade
83973:20210612:115116.114 completed 72% of database upgrade
83973:20210612:115116.116 completed 73% of database upgrade
83973:20210612:115116.119 completed 74% of database upgrade
83973:20210612:115116.122 completed 75% of database upgrade
83973:20210612:115116.123 completed 76% of database upgrade
83973:20210612:115116.125 completed 77% of database upgrade
83973:20210612:115116.128 completed 78% of database upgrade
83973:20210612:115116.130 completed 79% of database upgrade
83973:20210612:115116.132 completed 80% of database upgrade
83973:20210612:115116.133 completed 81% of database upgrade
83973:20210612:115118.377 completed 82% of database upgrade
83973:20210612:115118.428 completed 83% of database upgrade
83973:20210612:115118.467 completed 84% of database upgrade
83973:20210612:115118.469 completed 85% of database upgrade
83973:20210612:115118.470 completed 86% of database upgrade
83973:20210612:115118.472 completed 87% of database upgrade
83973:20210612:115118.476 completed 88% of database upgrade
83973:20210612:115118.478 completed 89% of database upgrade
83973:20210612:115118.659 completed 90% of database upgrade
83973:20210612:115118.660 completed 91% of database upgrade
83973:20210612:115118.661 completed 92% of database upgrade
83973:20210612:115118.662 completed 93% of database upgrade
83973:20210612:115118.684 completed 94% of database upgrade
83973:20210612:115119.819 completed 95% of database upgrade
83973:20210612:115120.020 completed 96% of database upgrade
83973:20210612:115120.036 completed 97% of database upgrade
83973:20210612:115120.234 completed 98% of database upgrade
83973:20210612:115121.257 completed 99% of database upgrade
83973:20210612:115121.259 completed 100% of database upgrade
83973:20210612:115121.259 database upgrade fully completed

[Markku]

Hi, if the Zabbix frontend says it is expecting database version 0502xxxx, it basically means that your Zabbix frontend is still running version 5.2. Check that you have upgraded+restarted all the Zabbix components (whether they run on a single server or on separate servers).

Markku

[UntestedEngineer]

I am not quite sure what else I am missing because I have upgraded the frontend as well:

apt install --only-upgrade zabbix-server-pgsql zabbix-frontend-php zabbix-agent zabbix-apache-conf

zabbix-agent/unknown,now 1:5.4.1-1+ubuntu20.04 amd64 [installed]
zabbix-apache-conf/unknown,now 1:5.4.1-1+ubuntu20.04 all [installed]
zabbix-frontend-php/unknown,now 1:5.4.1-1+ubuntu20.04 all [installed]
zabbix-release/unknown,now 1:5.4-1+ubuntu20.04 all [installed]
zabbix-server-pgsql/unknown,now 1:5.4.1-1+ubuntu20.04 amd64 [installed]

All upgrades were successful. I even rebooted the server too. I have performed the upgrade at least half a dozen times by now with the same results.

No matter how many times I run the upgrade procedure the php front end will not upgrade. I have followed every stop but not sure why the front end won't upgrade.

/websites/zabbix/www/include$ sudo cat defines.inc.php | grep ZABBIX
define('ZABBIX_VERSION', '5.2.4');
define('ZABBIX_API_VERSION', '5.2.4');
define('ZABBIX_EXPORT_VERSION', '5.2');
define('ZABBIX_DB_VERSION', 5020000);

[Markku]

Based on your defines.inc.php location you have made a custom installation (instead of using the Zabbix-provided packages and locations), so there is no easy way for others to provide you help with this. Try to figure out what you have actually done when originally installing Zabbix frontend in your custom setup, and maybe try to do the same things again with the 5.4 files and settings (and then document your installation for your later use).

Markku

[UntestedEngineer]

I realize that now after my current zabbix install is reporting 5.2.4 yet the original directory is 5.2.6. It appears I went with a virtualhost setup for SSL redirect to the base URL of my website instead of having to put /zabbix every time. Is there any harm in copying the contents of the /usr/share/zabbix folder to my real document root of /websites/zabbix/www?