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

Error upgrading from 3.0 to 3.2.4

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Critical
    • Resolution: Incomplete
    • 3.0.7
    • None
    • Server (S)
    • None
    • CentOS Linux release 7.3.1611 (Core)

    Description

      Got an DB error when upgrading to 3.2.4:

      7678:20170315:124407.503 using configuration file: /etc/zabbix/zabbix_server.conf
        7678:20170315:124407.509 current database version (mandatory/optional): 03010047/03010047
        7678:20170315:124407.509 required mandatory version: 03020000
        7678:20170315:124407.512 [Z3005] query failed: [1005] Can't create table 'zabbix.#sql-5ac_1338fd' (errno: 121) [alter table event_recovery add constraint c_event_recovery_3 foreign key (c_eventid) references events (eventid) on delete cascade]
        7678:20170315:124407.512 database upgrade failed
      

      on db i've got this table with constrains:

      MariaDB [zabbix]> show create table `event_recovery`;
      +----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Table          | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
      +----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | event_recovery | CREATE TABLE `event_recovery` (
        `eventid` bigint(20) unsigned NOT NULL,
        `r_eventid` bigint(20) unsigned NOT NULL,
        `c_eventid` bigint(20) unsigned DEFAULT NULL,
        `correlationid` bigint(20) unsigned DEFAULT NULL,
        PRIMARY KEY (`eventid`),
        KEY `event_recovery_1` (`r_eventid`),
        KEY `event_recovery_2` (`c_eventid`),
        CONSTRAINT `c_event_recovery_3` FOREIGN KEY (`c_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE,
        CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE,
        CONSTRAINT `c_event_recovery_2` FOREIGN KEY (`r_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE
      ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin |
      +----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              tsyc_emitel Tomasz Syc
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: