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

Database upgrade 04030035 to 05000000

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 5.0.1
    • Server (S)
    • None
    • Debian Linux nas 5.5.0-2-amd64 #1 SMP Debian 5.5.17-1 (2020-04-15) x86_64 GNU/Linux

      mysql Ver 15.1 Distrib 10.3.22-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

      Hi,

      I'm using zabbix since 2.x version and successfully upgraded to 3.x > 4.x version, but upgrade to 5.x failed. Installed from repository.

      Steps to reproduce:

      1. Upgrade Zabbix from 4.x to 5.0.1
      2. Start zabbix_server service

      Result:
      Service not started, error in logs:

      2152208:20200615:095741.694 Starting Zabbix Server. Zabbix 5.0.1 (revision c2a0b03480).
      2152208:20200615:095741.694 ****** Enabled features ******
      2152208:20200615:095741.694 SNMP monitoring:           YES
      2152208:20200615:095741.694 IPMI monitoring:           YES
      2152208:20200615:095741.694 Web monitoring:            YES
      2152208:20200615:095741.694 VMware monitoring:         YES
      2152208:20200615:095741.694 SMTP authentication:       YES
      2152208:20200615:095741.694 ODBC:                      YES
      2152208:20200615:095741.694 SSH support:               YES
      2152208:20200615:095741.694 IPv6 support:              YES
      2152208:20200615:095741.694 TLS support:               YES
      2152208:20200615:095741.694 ******************************
      2152208:20200615:095741.694 using configuration file: /etc/zabbix/zabbix_server.conf
      2152208:20200615:095741.696 current database version (mandatory/optional): 04030035/04030035
      2152208:20200615:095741.696 required mandatory version: 05000000
      2152208:20200615:095741.696 starting automatic database upgrade
      2152208:20200615:095741.696 [Z3005] query failed: [1091] Can't DROP FOREIGN KEY `c_host_inventory_1`; check that it exists [alter table host_inventory drop foreign key c_host_inventory_1]
      2152208:20200615:095741.696 database upgrade failed
      
      

      zabbix.sql

      Expected:
      Successful database upgrade

            zabbix.support Zabbix Support Team
            coudy Coudy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: