after apt upgrade: database version does not match current requirements

[fdpalma]

Hi all,

Please, I am facing issues with the DB auto upgrade after trying to run apt upgrade for ubuntu... From the website I get:

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

Checking the zabbix log in /var/log/zabbix/zabbix_server.log I have this:

2447:20240301:213252.549 ******************************
2447:20240301:213252.549 using configuration file: /etc/zabbix/zabbix_server.conf
2447:20240301:213252.567 current database version (mandatory/optional): 06050085/06050085
2447:20240301:213252.567 required mandatory version: 06050209
2447:20240301:213252.567 mandatory patches were found
2447:20240301:213252.569 starting automatic database upgrade
2447:20240301:213252.570 [Z3005] query failed: [1072] Key column 'proxyid' doesn't exist in table [create index task_2 on task (proxyid)]
2447:20240301:213252.570 database upgrade failed on patch 06050086, exiting in 10 seconds
2447:20240301:213302.570 Zabbix Server stopped. Zabbix 7.0.0beta1 (revision 9bc845eca94).

Also I can observe this:

1241:20240301:212043.416 completed 13% of database upgrade
1241:20240301:212043.450 completed 14% of database upgrade
1241:20240301:212043.469 completed 15% of database upgrade
1241:20240301:212043.600 completed 16% of database upgrade
1241:20240301:212043.631 completed 17% of database upgrade
1241:20240301:212043.664 completed 18% of database upgrade
1241:20240301:212043.691 completed 19% of database upgrade
1241:20240301:212043.708 database upgrade failed on patch 06050086, exiting in 10 seconds

I would appreciate any help. thanks.

[knownasdepe]

just update your zabbix vesion to 6.5

https://repo.zabbix.com/zabbix/6.5/ubuntu/pool/main/z/zabbix-release/zabbix-release_6.5-1%2Bubuntu22.04_all.deb

[cyber]

just update your zabbix vesion to 6.5

https://repo.zabbix.com/zabbix/6.5/u...u22.04_all.deb

that is 7.0 beta actually... What seems to be already in place... But whats wrong with that upgrade, I cannot tell.. beta software... happens...