Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25648

Unable to upgrade DB from 6.4 to 7.0 due to name_upper column

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 6.4.20, 7.0.5
    • None
    • None
    • Ubuntu 22.04 Server LTS

      Steps to reproduce:

      1. Follow the upgrade instruction from https://www.zabbix.com/documentation/current/en/manual/installation/upgrade/packages/debian_ubuntu
      2. 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.

            zabbix.support Zabbix Support Team
            Nono Nono
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: