Zabbix Server Update 5.0 -> 6.2 - Database won't update

[OndZaj]

Hello,

I am trying to update our Zabbix Server 5.0 to the latest stable version, 6.2, on Ubuntu 20.4.

Using these instructions:

https://bestmonitoringtools.com/upgrade-zabbix-to-the-latest-version/

It's fine until the step 4 database update. When I try :

cat /var/log/zabbix/zabbix_server.log | grep database

I get this:


I do appreciate any help! I have already spent many hours on this without a solution.

I have looked everywhere but couldn't find any solution :/

Thank you very much!
Ondrej

[tim.mooney]

I generally recommend the Zabbix documentation for installs and updates, rather than 3rd party documentation. I think the documentation on the site you referenced is generally pretty good, but my recommendation is that it's used to supplement the official documentation, not instead of it.

You don't say anything about what database backend and database version you're using, and that may be relevant. It's difficult to give good advice to help someone when we don't know all the basics for the environment.

Overall, the repeated "free_database_cache" messages from zabbix_server are not normal. Is this an all-in-one install, where the database, Zabbix server, and Zabbix web (front end) are all on the same system? If so, how much virtual memory has been set aside for the database?

Beyond the repeating "free_database_cache" messages and the schema version messages, there should have been other messages when you started zabbix_serverd. Those may be important to debug the issue, so can you include them?

[guille.rodriguez]

I used this website for upgrade from 5.0 to 6.0 and then 6.0 to 6.2, and all works fine.

When I upgrade to 6.2 i need to restart 2 times Zabbix Server , the second time Zabbix Server starts database migration.

If you can rollback changes to 5.X (do you have an snapshot?) try to upgrade to 6.0 LTS and then to 6.2