Zabbix docker upgrade from 5.4 to 6.0.1 failed with database version error

[fengerzh]

Hi, all,

My Zabbix server is installed by docker. Firstly installed with version 4.4, upgrade to 5.0 and 5.4 is successfully, but now when upgrade from 5.4 to 6.0.1 failed with following messages:

** Preparing Zabbix server
** Using MYSQL_USER variable from ENV
** Using MYSQL_PASSWORD variable from ENV
** Using MYSQL_ROOT_PASSWORD variable from ENV
********************
* DB_SERVER_HOST: zabbix-mysql
* DB_SERVER_PORT: 3306
* DB_SERVER_DBNAME: zabbix
********************
** Creating 'zabbix' user in MySQL database
** Database 'zabbix' already exists. Please be careful with database COLLATE!
** Table 'zabbix.dbversion' already exists.
** Preparing Zabbix server configuration file
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ListenIP": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ListenPort": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ListenBacklog": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "SourceIP": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogType": 'console'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogFileSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "PidFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DebugLevel": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBHost": 'zabbix-mysql'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBName": 'zabbix'...updated
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBSchema": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBPort": '3306'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "VaultDBPath": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "VaultURL": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBUser": 'zabbix'...updated
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBPassword": '****'. Enable DEBUG_MODE to view value ...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "AllowUnsupportedDBVersions": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartReportWriters": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "WebServiceURL": 'http://zabbix-web-service:10053/report'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryStorageURL": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryStorageTypes": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryStorageDateIndex": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBSocket": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StatsAllowedIP": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPollers": '20'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartIPMIPollers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPollersUnreachable": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartTrappers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPingers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartDiscoverers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartHistoryPollers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartHTTPPollers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPreprocessors": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartTimers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartEscalators": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartAlerters": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartTimers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartEscalators": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartLLDProcessors": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "JavaGateway": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "JavaGatewayPort": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartJavaPollers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartVMwareCollectors": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwareFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwarePerfFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwareCacheSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwareTimeout": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "SNMPTrapperFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartSNMPTrapper": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "HousekeepingFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "MaxHousekeeperDelete": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ServiceManagerSyncFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "SenderFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "CacheSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "CacheUpdateFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartDBSyncers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryCacheSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryIndexCacheSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TrendCacheSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TrendFunctionCacheSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ValueCacheSize": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "Timeout": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TrapperTimeout": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "UnreachablePeriod": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "UnavailableDelay": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "UnreachableDelay": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "AlertScriptsPath": '/usr/lib/zabbix/alertscripts'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ExternalScripts": '/usr/lib/zabbix/externalscripts'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "FpingLocation": '/usr/bin/fping'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "Fping6Location": '/usr/bin/fping6'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSHKeyLocation": '/var/lib/zabbix/ssh_keys'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogSlowQueries": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartProxyPollers": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ProxyConfigFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ProxyDataFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSLCertLocation": '/var/lib/zabbix/ssl/certs/'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSLKeyLocation": '/var/lib/zabbix/ssl/keys/'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSLCALocation": '/var/lib/zabbix/ssl/ssl_ca/'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "LoadModulePath": '/var/lib/zabbix/modules/'...added
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCAFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCRLFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCertFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCipherAll": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCipherAll13": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCipherCert": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCipherCert13": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCipherPSK": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCipherPSK13": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSKeyFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSPSKIdentity": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSPSKFile": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "ServiceManagerSyncFrequency": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "HANodeName": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "NodeAddress": ''...removed
** Updating '/etc/zabbix/zabbix_server.conf' parameter "User": 'zabbix'...added
Starting Zabbix Server. Zabbix 6.0.1 (revision a80cb13).
Press Ctrl+C to exit.

8:20220305:095124.514 Starting Zabbix Server. Zabbix 6.0.1 (revision a80cb13).
8:20220305:095124.516 ****** Enabled features ******
8:20220305:095124.516 SNMP monitoring: YES
8:20220305:095124.516 IPMI monitoring: YES
8:20220305:095124.516 Web monitoring: YES
8:20220305:095124.516 VMware monitoring: YES
8:20220305:095124.516 SMTP authentication: YES
8:20220305:095124.516 ODBC: YES
8:20220305:095124.516 SSH support: YES
8:20220305:095124.516 IPv6 support: YES
8:20220305:095124.516 TLS support: YES
8:20220305:095124.516 ******************************
8:20220305:095124.516 using configuration file: /etc/zabbix/zabbix_server.conf
8:20220305:095124.528 Unsupported DB! MySQL version is 50714 which is smaller than minimum of 50728
8:20220305:095124.528 Error! Current MySQL database server version is too old (5.07.14)
8:20220305:095124.528 Must be a least 5.07.28
8:20220305:095124.530 database could be upgraded to use primary keys in history tables

I see some documents saying that for upgrading to Zabbix 6.0, need to run sql script of history_pk_prepare.sql, but I don't know how to upgrade from 50714 to 50728? Please help, thanks!