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

Upgrade from 5.0 to 5.2/5.4 database upgrade fails

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Won't fix
    • 5.4.2
    • None
    • None
    • None
    • Raspberry Pi OS

    Description

      Steps to reproduce:

      1. Update packages to 5.2 or 5.4
        1. tested with native packages and docker images for 5.2 and 5.4. All yeild the same database upgrade issue. It seems it tries to recreate the database rather than update the existing database?
      2. Restart services
      3. Database upgrade fails

      Result:

       18213:20210703:134859.510 Starting Zabbix Server. Zabbix 5.4.2 (revision 4c8f9aabe1).
       18213:20210703:134859.510 ****** Enabled features ******
       18213:20210703:134859.510 SNMP monitoring:           YES
       18213:20210703:134859.510 IPMI monitoring:           YES
       18213:20210703:134859.511 Web monitoring:            YES
       18213:20210703:134859.511 VMware monitoring:         YES
       18213:20210703:134859.511 SMTP authentication:       YES
       18213:20210703:134859.511 ODBC:                      YES
       18213:20210703:134859.511 SSH support:               YES
       18213:20210703:134859.511 IPv6 support:              YES
       18213:20210703:134859.511 TLS support:               YES
       18213:20210703:134859.511 ******************************
       18213:20210703:134859.511 using configuration file: /etc/zabbix/zabbix_server.conf
       18213:20210703:134859.791 Unsupported DB! MySQL version is 50651 which is smaller than minimum of 50728
       18213:20210703:134859.954 current database version (mandatory/optional): 05010052/05010052
       18213:20210703:134859.954 required mandatory version: 05040000
       18213:20210703:134859.954 starting automatic database upgrade
       18213:20210703:134859.992 [Z3005] query failed: [1050] Table 'role' already exists [create table role (
      `roleid` bigint unsigned not null,
      `name` varchar(255) default '' not null,
      `type` integer default '0' not null,
      `readonly` integer default '0' not null,
      primary key (roleid)
      ) engine=innodb]
       18213:20210703:134900.019 database upgrade failed
      

      Expected:
      Database upgrade should succeed.

       

      Also reported here:

       

      https://www.zabbix.com/forum/zabbix-help/413928-erro-ap%C3%B3s-atualizar-para-a-vers%C3%A3o-5-2-1

      Attachments

        Activity

          People

            edgar.akhmetshin Edgar Akhmetshin
            dom_b Dominic Bird
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: