Zabbix database error

[alvarocs]

Hi community

I have this schema: zabbix proxy5.2(vm1), zabbix web and server5.4(AKS Cluster) and database(vm2). AKS Clusterupgraded to 5.4 by accident but the database cant run. I have these errors:


If i try to modify db.version to 5.4, i have this error:


Alter table changes nothing.
If my zabbix-server pod restarts, db.version changes again to 5.3 and it give another different error like "query failed".

Any help is appreciated.

Thanks

[tim.mooney]

Modifying dbversion columns directly is almost always a mistake, unless you know every database alternation you need to make in other places to bring your database schema up to that point. Otherwise, you're lying to zabbix_server; telling it the database has already been modified appropriately and it can expect a database with the correct tables/columns/etc, when in reality some things will be wrong. I recommend you shut down zabbix_server and set dbversion.mandatory back to whatever it was prior to you changing it.

What version of zabbix-server package were you running prior to the accidental 5.4.x server upgrade?

Is the version of the database software you're using compatible with both the version of zabbix-server you were running previously and zabbix-server 5.4.x?

Do you want to be running zabbix 5.4.x (now), or would you rather be running the version you were on previously, until you can upgrade at a planned time?