-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
6.4.20, 7.0.5
-
None
-
None
-
Ubuntu 22.04 Server LTS
Steps to reproduce:
- Follow the upgrade instruction from https://www.zabbix.com/documentation/current/en/manual/installation/upgrade/packages/debian_ubuntu
- Get the Some errors
Result:
First error (on /var/log/zabbix/zabbix_server.log) :
Code:
4244:20241128:124848.131 starting automatic database upgrade
4244:20241128:124848.140 [Z3005] query failed: [1060] Duplicate column name 'name_upper' [alter table `hosts` add `name_upper` varchar(128) default '' not null]
4244:20241128:124848.141 database upgrade failed on patch 06030064, exiting in 10 seconds
Note: I've an "history" with this specific column, at wasn't updated automatically (see https://support.zabbix.com/browse/ZBX-22760 ) so we ran from time to time :
update hosts set name_upper=upper(name) where name_upper='';
as a workaround.
I've added more information about the issue on https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/495024-name_upper-already-exists-on-zabbix-6-4-unable-to-properly-upgrade-to-zabbix-7-0
Expected:
The upgrade shall work without issue.