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

Zabbix Upgrade 3.2 to 3.4 - database upgrade failed

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Blocker
    • Resolution: Won't fix
    • None
    • None
    • Server (S)
    • None

    Description

      Hi Everyone,

      i have upaded my Zabbix version 3.2 to 3.4 with the help of the official documentation https://www.zabbix.com/documentation/3.4/manual/installation/upgrade_packages/rhel_centos

      When i'm starting the Zabbix-Server service, in the log i get error for the database upgrade.

       24328:20180607:235936.448 Starting Zabbix Server. Zabbix 3.4.9 (revision 80550).
      
       24328:20180607:235936.448 ****** Enabled features ******
      
       24328:20180607:235936.448 SNMP monitoring:           YES
      
       24328:20180607:235936.448 IPMI monitoring:           YES
      
       24328:20180607:235936.448 Web monitoring:            YES
      
       24328:20180607:235936.448 VMware monitoring:         YES
      
       24328:20180607:235936.448 SMTP authentication:       YES
      
       24328:20180607:235936.448 Jabber notifications:      YES
      
       24328:20180607:235936.448 Ez Texting notifications:  YES
      
       24328:20180607:235936.448 ODBC:                      YES
      
       24328:20180607:235936.449 SSH2 support:              YES
      
       24328:20180607:235936.449 IPv6 support:              YES
      
       24328:20180607:235936.449 TLS support:               YES
      
       24328:20180607:235936.449 ******************************
      
       24328:20180607:235936.449 using configuration file: /etc/zabbix/zabbix_server.conf
      
       24328:20180607:235936.457 current database version (mandatory/optional): 03030004/03030004
      
       24328:20180607:235936.457 required mandatory version: 03040000
      
       24328:20180607:235936.457 optional patches were found
      
       24328:20180607:235936.457 starting automatic database upgrade
      
       24328:20180607:235936.465 [Z3005] query failed: [1025] Error on rename of './zabbix/dservices' to './zabbix/#sql2-42ce-e3' (errno: 152) [alter table dservices drop fo
      
      reign key c_dservices_2]
      
       24328:20180607:235936.465 database upgrade failed
      

      This is table structure:

      | dservices | CREATE TABLE `dservices` (
      
        `dserviceid` bigint(20) unsigned NOT NULL,
      
        `dhostid` bigint(20) unsigned NOT NULL,
      
        `type` int(11) NOT NULL DEFAULT '0',
      
        `key_` varchar(255) NOT NULL DEFAULT '',
      
        `value` varchar(255) NOT NULL DEFAULT '',
      
        `port` int(11) NOT NULL DEFAULT '0',
      
        `status` int(11) NOT NULL DEFAULT '0',
      
        `lastup` int(11) NOT NULL DEFAULT '0',
      
        `lastdown` int(11) NOT NULL DEFAULT '0',
      
        `dcheckid` bigint(20) unsigned NOT NULL,
      
        `ip` varchar(39) NOT NULL DEFAULT '',
      
        `dns` varchar(64) NOT NULL DEFAULT '',
      
        PRIMARY KEY (`dserviceid`),
      
        UNIQUE KEY `dservices_1` (`dcheckid`,`type`,`key_`,`ip`,`port`),
      
        KEY `dservices_2` (`dhostid`),
      
        CONSTRAINT `_c_dservices_1` FOREIGN KEY (`dhostid`) REFERENCES `dhosts` (`dhostid`) ON DELETE CASCADE,
      
        CONSTRAINT `_c_dservices_2` FOREIGN KEY (`dcheckid`) REFERENCES `dchecks` (`dcheckid`) ON DELETE CASCADE
      
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
      
      

       

      Have got any solution, please ?

      Thank you in advance for your time.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            Z Maxim
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: