Upgrade to Zabbix 5.0: database is not upgraded to use double precision values

[fansari]

I have tried to upgrade Zabbix 4.4.7 with this procedure.

https://www.zabbix.com/documentation...rade_notes_500

After the upgrade the GUI shows a 404 error and in the zabbix_server.log in find this error after the database upgrade was completed:

"database is not upgraded to use double precision values"

In the upgrade notes was this hint to patch the database:

database/mysql/double.sql

But I could not find this files anywhere on my system. From where do I get this patch?

[Atsushi]

It seems that double.sql is only on Git.

https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/database/mysql

[fansari]

Thank you! Now it is working.

(BTW: the 404 error had nothing to do with that. Was some misconfig in my nginx.)

[whit3h0rse]

You can find a step-by-step guide on how to upgrade Zabbix to version 5 and how to apply patch double.sql on this link:

https://bestmonitoringtools.com/upgr...atest-version/

Regards

[aasanov]

How to run this in Postgres?database/postgresql/double.sql