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

Zabbix MySQL DB upgrade 5.0 -> 6.0 fails

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 6.0.0
    • None
    • Docker, MySQL 8.0, Ubuntu 20.04.4, Zabbix 6.0

      Steps to reproduce:

      docker-compose -f docker-compose_v3_ubuntu_mysql_latest.yaml up -d
      

      zabbix server container automatically attempts to upgrade MySQL DB from 05000000 to 06000000. MySQL Container is on version 8.0.

      Result:

      Starting Zabbix Server. Zabbix 6.0.0 (revision 5203d2e).
      Press Ctrl+C to exit.
      
       7:20220223:145114.601 Starting Zabbix Server. Zabbix 6.0.0 (revision 5203d2e).
       7:20220223:145114.601 ****** Enabled features ******
       7:20220223:145114.601 SNMP monitoring:           YES
       7:20220223:145114.601 IPMI monitoring:           YES
       7:20220223:145114.601 Web monitoring:            YES
       7:20220223:145114.601 VMware monitoring:         YES
       7:20220223:145114.601 SMTP authentication:       YES
       7:20220223:145114.601 ODBC:                      YES
       7:20220223:145114.601 SSH support:               YES
       7:20220223:145114.601 IPv6 support:              YES
       7:20220223:145114.601 TLS support:               YES
       7:20220223:145114.601 ******************************
       7:20220223:145114.601 using configuration file: /etc/zabbix/zabbix_server.conf
       7:20220223:145114.626 current database version (mandatory/optional): 05000000/05000002
       7:20220223:145114.626 required mandatory version: 06000000
       7:20220223:145114.626 starting automatic database upgrade
       7:20220223:145114.663 completed 0% of database upgrade
       7:20220223:145114.741 completed 1% of database upgrade
       7:20220223:145114.906 completed 2% of database upgrade
       7:20220223:145115.028 completed 3% of database upgrade
       7:20220223:145115.155 completed 4% of database upgrade
       7:20220223:145115.280 completed 5% of database upgrade
       7:20220223:145115.432 completed 6% of database upgrade
       7:20220223:145115.460 completed 7% of database upgrade
       7:20220223:145115.750 completed 8% of database upgrade
       7:20220223:145115.973 completed 9% of database upgrade
       7:20220223:145115.974 [Z3005] query failed: [1050] Table 'trigger_queue' already exists [create table trigger_queue (
      `objectid` bigint unsigned not null,
      `type` integer default '0' not null,
      `clock` integer default '0' not null,
      `ns` integer default '0' not null
      ) engine=innodb]
       7:20220223:145115.974 database upgrade failed
      

      Expected:

      Successful DB Upgrade

            zabbix.support Zabbix Support Team
            astro_Avery Avery Willard
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: