How to upgrade MariaDB from 10.03 to 10.05 or higher.

[hsv]

Hi
After upgrading from 5.4 to 6.0
The upgrade failed because the database was not upgraded in the Zabbix upgrade process.
From
sudo tail -f /var/log/zabbix/zabbix_server.log

3764:20230323:001505.131 using configuration file: /etc/zabbix/zabbix_server.conf
3764:20230323:001505.142
3764:20230323:001505.142 Unable to start Zabbix server due to unsupported MariaDB database version (10.03.38).
3764:20230323:001505.142 Must be at least (10.05.00).
3764:20230323:001505.143 Use of supported database version is highly recommended.
3764:20230323:001505.143 Override by setting AllowUnsupportedDBVersions=1 in Zabbix server configuration file at your own risk.
3764:20230323:001505.143
3764:20230323:001505.144 database could be upgraded to use primary keys in history tables

3787:20230323:001517.374 Starting Zabbix Server. Zabbix 6.0.14 (revision 3f184b456c7).
3787:20230323:001517.374 ****** Enabled features ******
3787:20230323:001517.374 SNMP monitoring: YES
3787:20230323:001517.374 IPMI monitoring: YES
3787:20230323:001517.375 Web monitoring: YES
3787:20230323:001517.375 VMware monitoring: YES
3787:20230323:001517.375 SMTP authentication: YES
3787:20230323:001517.375 ODBC: YES
3787:20230323:001517.375 SSH support: YES
3787:20230323:001517.375 IPv6 support: YES
3787:20230323:001517.375 TLS support: YES
3787:20230323:001517.375 ******************************

Regards
Henning

[tim.mooney]

Normally, before installing or upgrading to a new version of Zabbix, you shut down the old version and then update any software dependencies (database version, PHP version for the front end, etc.). Only then would you upgrade Zabbix, after all the new version's dependencies are in place.

In this particular case, because zabbix-server hasn't done anything to your database yet, you could just shut down zabbix-server 6.0.14 and do the database dependency upgrade and then restart zabbix-server 6.0.14.

You don't say anything about what distro or version you're using, so I can't give more detailed info than "upgrade your MariaDB version, run mysql_upgrade (which might be in a separate package), and then restart zabbix-server 6.0.14".

It's best to always read the upgrade documentation before upgrading between non-micro versions.