Upgrade from 6.2.3 to 6.4.0 on Debian failed. After upgraded all packages.

[GerryBass]

HiHello everyone,

I just upgrade from 6.2.3 to 6.4.0 this morning and at the end ...

I got:
The Zabbix database version does not match current requirements. Your database version: 6020000. Required version: 6040000.

I reviewed all step and at the end I checked the actual version.

root@cpopapzab01:~# apt list --installed | grep zabbix

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

zabbix-agent/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-apache-conf/now 1:6.2.3-1+debian11 all [installed,upgradable to: 1:6.4.0-1+debian11]
zabbix-frontend-php/unknown,now 1:6.4.0-1+debian11 all [installed]
zabbix-release/unknown,now 1:6.4-1+debian11 all [installed]
zabbix-sender/now 1:6.2.3-1+debian11 amd64 [installed,upgradable to: 1:6.4.0-1+debian11]
zabbix-server-mysql/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-sql-scripts/now 1:6.2.3-1+debian11 all [installed,upgradable to: 1:6.4.0-1+debian11]
root@cpopapzab01:~#

The upgrade process did not worked properly
apt-get install --only-upgrade zabbix-server-mysql zabbix-frontend-php zabbix-agent

I re-installed the failed one individually like this

apt-get install --only-upgrade zabbix-frontend-php
apt-get install --only-upgrade zabbix-apache-conf
apt-get install --only-upgrade zabbix-sender

Now I have this:

zabbix-agent/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-apache-conf/unknown,now 1:6.4.0-1+debian11 all [installed]
zabbix-frontend-php/unknown,now 1:6.4.0-1+debian11 all [installed]
zabbix-release/unknown,now 1:6.4-1+debian11 all [installed]
zabbix-sender/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-server-mysql/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-sql-scripts/unknown,now 1:6.4.0-1+debian11 all [installed]
root@cpopapzab01:~#

Reboot Zabbix server, .. clear browser cash, etc ...

I still have the same message !!!

Database error

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

Someone can help me ? There is a way to fix this ? "This server is virtual, so I did a reverse snapshot to restore it. It's a POC server for a proposed monitoring system."


Thanks a lot.

[GerryBass]

Hi Mr.Mooney

For the required, I'm ok.
Need MariaDB version 10.5.00-10.10.X, I have 10.5.18-MariaDB-0+deb11u1
The minimum required libssh version has been raised from 0.6.0 to 0.9.0 I have Version: 0.9.5-1+deb11u1

In Logs, I found error.
Access denied for user 'zabbix'@'localhost' (using password: NO)

I fixed the situation with this.
mysql -u root -p
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost' IDENTIFIED BY 'NewPassword';
FLUSH PRIVILEGES;

You were right to go check the logs, I didn't think to do it at first. Thank you very much :-)


All is fine now :-)

[tim.mooney]

Now I have this:

zabbix-agent/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-apache-conf/unknown,now 1:6.4.0-1+debian11 all [installed]
zabbix-frontend-php/unknown,now 1:6.4.0-1+debian11 all [installed]
zabbix-release/unknown,now 1:6.4-1+debian11 all [installed]
zabbix-sender/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-server-mysql/unknown,now 1:6.4.0-1+debian11 amd64 [installed]
zabbix-sql-scripts/unknown,now 1:6.4.0-1+debian11 all [installed]
root@cpopapzab01:~#

All your packages are upgraded finally, which is good. When you restart the zabbix-server service, it should upgrade your MySQL database if it can.

When database upgrades fail, there is typically a very good clue about what the problem is in the zabbix_server.log file. Have you checked that? What does it say?

You didn't say what version of MySQL/MariaDB/Percona you're using, but there are special upgrade instructions for those databases. Have you read them: https://www.zabbix.com/documentation...rade_notes_640

[GerryBass]

Hi Mr.Mooney

For the required, I'm ok.
Need MariaDB version 10.5.00-10.10.X, I have 10.5.18-MariaDB-0+deb11u1
The minimum required libssh version has been raised from 0.6.0 to 0.9.0 I have Version: 0.9.5-1+deb11u1

In Logs, I found error.
Access denied for user 'zabbix'@'localhost' (using password: NO)

I fixed the situation with this.
mysql -u root -p
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost' IDENTIFIED BY 'NewPassword';
FLUSH PRIVILEGES;

You were right to go check the logs, I didn't think to do it at first. Thank you very much :-)


All is fine now :-)