Zabbix 7.2 upgrade fail

[ericdano]

Followed upgrade procedure, now I get this. What do I do?

"

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

"

[mrnobody]

Followed upgrade procedure, now I get this. What do I do?

"

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

"

The version of your DB need to be newer.

You can check it here

2 Requirements

Software and it's supported version (on the table, in the link) must be compatible to Zabbix 7.2

[Tristis Oris]

i got this with latest postgres. Nothing about DB at changelog.

scripts moved to new folder. nothing at changelog. again.

cat /usr/share/zabbix/sql-scripts/postgresql/timescaledb/schema.sql | sudo -u postgres psql zabbix
CREATE FUNCTION
NOTICE:  function base36_decode(pg_catalog.varchar) does not exist, skipping
DROP FUNCTION
NOTICE:  PostgreSQL version 16.6 (Ubuntu 16.6-1.pgdg24.04+1) is valid
NOTICE:  TimescaleDB extension is detected
NOTICE:  TimescaleDB version 2.17.2 is valid
NOTICE:  table "history" is already a hypertable, skipping
NOTICE:  table "history_uint" is already a hypertable, skipping
NOTICE:  table "history_log" is already a hypertable, skipping
NOTICE:  table "history_text" is already a hypertable, skipping
NOTICE:  table "history_str" is already a hypertable, skipping
NOTICE:  table "history_bin" is already a hypertable, skipping
NOTICE:  table "auditlog" is already a hypertable, skipping
NOTICE:  table "trends" is already a hypertable, skipping
NOTICE:  table "trends_uint" is already a hypertable, skipping
NOTICE:  TimescaleDB extension is already installed; not changing configuration
NOTICE:  TimescaleDB is configured successfully
DO

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

[cyber]

If you upgrade you dont have to run those db creation scripts again... you should just start up your server and during first startup it shoudl do all necessary things in DB...

[zebmoon]

I'm running mine as a docker stack same here, I was using
image: postgres:16.4
moved that to 16.6

no go on that, then tried 17 and now just get

2024-12-12 10:50:01.091 UTC [1] FATAL: database files are incompatible with server
2024-12-12 10:50:01.091 UTC [1] DETAIL: The data directory was initialized by PostgreSQL version 16, which is not compatible with this version 17.2 (Debian 17.2-1.pgdg120+1).

Any ideas please

[zebmoon]

I've just re-read what I've put and for me its

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

The other way around

[cyber]

I'm running mine as a docker stack same here, I was using
image: postgres:16.4
moved that to 16.6

no go on that, then tried 17 and now just get

2024-12-12 10:50:01.091 UTC [1] FATAL: database files are incompatible with server
2024-12-12 10:50:01.091 UTC [1] DETAIL: The data directory was initialized by PostgreSQL version 16, which is not compatible with this version 17.2 (Debian 17.2-1.pgdg120+1).

Any ideas please

you cannot just transfer DB files and expect it to work with different version. You probably need to run pg_upgrade (https://www.postgresql.org/docs/current/pgupgrade.html) after that. And only then your v17 PG starts up (probably).

[zebmoon]

I'm thinking that for some reaosn the zabbix database version has been updated to 7020000 and the front end i.e. web is still behind and is expecting to see the zabnbix database as 7000000, so its not postgre issue rather than a something hasnt updated in zabbix issue.

I've repulled all the containers and still no luck, is there a manual way to che ck the front end and or update it.

[cyber]

As you hijacked the topic, your issue is the opposite of what OP has...
if that "The Zabbix database version does not match current requirements. Your database version: 7020000. Required version: 7000000. Please contact your system administrator." is in your server logfile, then it is your server version, that is 7 but needs to be 7.2...

[lukeluke1979]

Hi guys,
i have the same issues. could you help me?

I have Zabbix on docker.

My Docker compose:
services:

postgresql-server:

image: postgres:16

zabbix-server:

image: zabbix/zabbix-server-pgsql:latest

zabbix-web-nginx-pgsql:

image: zabbix/zabbix-web-nginx-pgsql:latest

After docker-compose pull and then docker-compose up this is the log:

Starting Zabbix Server. Zabbix 7.2.0 (revision 6265587).
zabbix-server | Press Ctrl+C to exit.
zabbix-server |
zabbix-server | 1:20241219:150529.432 Starting Zabbix Server. Zabbix 7.2.0 (revision 6265587).
zabbix-server | 1:20241219:150529.432 ****** Enabled features ******
zabbix-server | 1:20241219:150529.432 SNMP monitoring: YES
zabbix-server | 1:20241219:150529.432 IPMI monitoring: YES
zabbix-server | 1:20241219:150529.432 Web monitoring: YES
zabbix-server | 1:20241219:150529.432 VMware monitoring: YES
zabbix-server | 1:20241219:150529.432 SMTP authentication: YES
zabbix-server | 1:20241219:150529.432 ODBC: YES
zabbix-server | 1:20241219:150529.432 SSH support: YES
zabbix-server | 1:20241219:150529.432 IPv6 support: YES
zabbix-server | 1:20241219:150529.432 TLS support: YES
zabbix-server | 1:20241219:150529.432 ******************************
zabbix-server | 1:20241219:150529.432 using configuration file: /etc/zabbix/zabbix_server.conf
[B]zabbix-server | 1:20241219:150529.477 current database version (mandatory/optional): 07020000/07020000
zabbix-server | 1:20241219:150529.477 required mandatory version: 07020000[/B]
zabbix-server | 203:20241219:150529.493 starting HA manager
zabbix-server | 203:20241219:150529.519 HA manager started in active mode
​

but when i try to connect on my zabbix URL, i receive this error:



Thanks a lot

[Michelsup]

Hi guys,
but when i try to connect on my zabbix URL, i receive this error:

I have the same setup and the same issue.

[cyber]

Hi guys,
i have the same issues. could you help me?

I have Zabbix on docker.

My Docker compose:
services:

postgresql-server:

image: postgres:16

zabbix-server:

image: zabbix/zabbix-server-pgsql:latest

zabbix-web-nginx-pgsql:

image: zabbix/zabbix-web-nginx-pgsql:latest

After docker-compose pull and then docker-compose up this is the log:

Starting Zabbix Server. Zabbix 7.2.0 (revision 6265587).
zabbix-server | Press Ctrl+C to exit.
zabbix-server |
zabbix-server | 1:20241219:150529.432 Starting Zabbix Server. Zabbix 7.2.0 (revision 6265587).
zabbix-server | 1:20241219:150529.432 ****** Enabled features ******
zabbix-server | 1:20241219:150529.432 SNMP monitoring: YES
zabbix-server | 1:20241219:150529.432 IPMI monitoring: YES
zabbix-server | 1:20241219:150529.432 Web monitoring: YES
zabbix-server | 1:20241219:150529.432 VMware monitoring: YES
zabbix-server | 1:20241219:150529.432 SMTP authentication: YES
zabbix-server | 1:20241219:150529.432 ODBC: YES
zabbix-server | 1:20241219:150529.432 SSH support: YES
zabbix-server | 1:20241219:150529.432 IPv6 support: YES
zabbix-server | 1:20241219:150529.432 TLS support: YES
zabbix-server | 1:20241219:150529.432 ******************************
zabbix-server | 1:20241219:150529.432 using configuration file: /etc/zabbix/zabbix_server.conf
[B]zabbix-server | 1:20241219:150529.477 current database version (mandatory/optional): 07020000/07020000
zabbix-server | 1:20241219:150529.477 required mandatory version: 07020000[/B]
zabbix-server | 203:20241219:150529.493 starting HA manager
zabbix-server | 203:20241219:150529.519 HA manager started in active mode
​

but when i try to connect on my zabbix URL, i receive this error:



Thanks a lot

This for me says, that your frontend is of wrong version. Server started up OK.
I seem to remember something from topics during last coupe of weeks, that there are issues with certain flavors of containers... only alpine should be used... Something along the lines...

[mlazzarotto]

This for me says, that your frontend is of wrong version. Server started up OK.
I seem to remember something from topics during last coupe of weeks, that there are issues with certain flavors of containers... only alpine should be used... Something along the lines...

I tried replacing the alpine image tag with alpine-latest tag, but I'm still having that error.

[Michelsup]

define('ZABBIX_VERSION', '7.0.6');
define('ZABBIX_API_VERSION', '7.0.6');
define('ZABBIX_EXPORT_VERSION', '7.0');

So the all docker images for the front end are still in 7.0.6. Can we expect an update soon ?

Edit: So from rage I deleted

zabbix-web

and recreated it. Everything is now fine.

[mlazzarotto]

define('ZABBIX_VERSION', '7.0.6');
define('ZABBIX_API_VERSION', '7.0.6');
define('ZABBIX_EXPORT_VERSION', '7.0');

So the all docker images for the front end are still in 7.0.6. Can we expect an update soon ?

Edit: So from rage I deleted

zabbix-web

and recreated it. Everything is now fine.

Hi MicelSup, what do you mean? Did you recreate the Docker container only or the Docker volume as well?

[Michelsup]

I deleted the Docker container only.