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

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Incomplete
    • Affects Version/s: 3.0.7
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      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

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

                Dates

                Created:
                Updated:
                Resolved: