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

Can't upgrade from ZABBIX 5 to Zabbix 7 (database upgrade not possible)

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Cannot Reproduce
    • Icon: Trivial Trivial
    • None
    • 7.0.17
    • Server (S)
    • Frontend :RHEL 8.2, Apache Server. Backend: RHEL 8.2, Mysql 8.0
    • S25-W30/31

      Steps to reproduce:

      1. Dump production database data with mysqldump.
      2. Import data into DEV environment.
      3. Followed upgrade procedure in https://www.zabbix.com/documentation/7.0/en/manual/installation/upgrade/packages/rhel
      4. Starting Zabbix-server service fails

      Result:
      Zabbix-server.log content: 

      140412:20250724:151705.863 Starting Zabbix Server. Zabbix 7.0.17 (revision 77c670937ef).
      140412:20250724:151705.863 ****** Enabled features ******
      140412:20250724:151705.863 SNMP monitoring:           YES
      140412:20250724:151705.863 IPMI monitoring:           YES
      140412:20250724:151705.863 Web monitoring:            YES
      140412:20250724:151705.863 VMware monitoring:         YES
      140412:20250724:151705.863 SMTP authentication:       YES
      140412:20250724:151705.863 ODBC:                      YES
      140412:20250724:151705.863 SSH support:               YES
      140412:20250724:151705.863 IPv6 support:              YES
      140412:20250724:151705.863 TLS support:               YES
      140412:20250724:151705.863 ******************************
      140412:20250724:151705.863 using configuration file: /etc/zabbix/zabbix_server.conf
      140412:20250724:151705.876 current database version (mandatory/optional): 05000000/05000007
      140412:20250724:151705.876 required mandatory version: 07000000
      140412:20250724:151705.876 mandatory patches were found
      140412:20250724:151705.877 [Z3005] query failed: [1054] Unknown column 'ha_failover_delay' in 'field list' [select unix_timestamp(),ha_failover_delay from config]
      140412:20250724:151705.877 cannot retrieve database time
      140412:20250724:151705.877 Zabbix Server stopped. Zabbix 7.0.17 (revision 77c670937ef).
      

      Expected:

      Database ugprade procedure started and completed.

            Unassigned Unassigned
            carnotan Iván Lago
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 5h
                5h