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

Обновление базы данных zabbix-server c версии 3.0.1 до версии 5.2.4

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 3.0.31, 5.2.4
    • Server (S)
    • None
    • Debian 10

      Добрый день!

      Я обновляю Zabbix  с версии   3.0.1 до версии 5.2.4 .

      При обновлении базы данных  происходит сбой обновления 

       

        3562:20210214:173821.142 Starting Zabbix Server. Zabbix 5.2.4 (revision e9f58de09c).
        3562:20210214:173821.142 ****** Enabled features ******
        3562:20210214:173821.142 SNMP monitoring:           YES
        3562:20210214:173821.142 IPMI monitoring:           YES
        3562:20210214:173821.142 Web monitoring:            YES
        3562:20210214:173821.142 VMware monitoring:         YES
        3562:20210214:173821.143 SMTP authentication:       YES
        3562:20210214:173821.143 ODBC:                      YES
        3562:20210214:173821.143 SSH support:               YES
        3562:20210214:173821.143 IPv6 support:              YES
        3562:20210214:173821.143 TLS support:               YES
        3562:20210214:173821.143 ******************************
        3562:20210214:173821.143 using configuration file: /etc/zabbix/zabbix_server.conf
        3562:20210214:173821.145 current database version (mandatory/optional): 03010000/03010000
        3562:20210214:173821.145 required mandatory version: 05020000
        3562:20210214:173821.145 starting automatic database upgrade
        3562:20210214:173821.146 [Z3005] query failed: [1072] Key column 'id' doesn't exist in table [alter table history_log drop column id]
        3562:20210214:173821.146 database upgrade failed
      

      Но если сделать SHOW CREATE TABLE `history_log`;

       

       

      CREATE TABLE `history_log` (
       `id` bigint(20) unsigned NOT NULL,
       `itemid` bigint(20) unsigned NOT NULL,
       `clock` int(11) NOT NULL DEFAULT 0,
       `timestamp` int(11) NOT NULL DEFAULT 0,
       `source` varchar(64) NOT NULL DEFAULT '',
       `severity` int(11) NOT NULL DEFAULT 0,
       `value` text NOT NULL,
       `logeventid` int(11) NOT NULL DEFAULT 0,
       `ns` int(11) NOT NULL DEFAULT 0,
       PRIMARY KEY (`id`,`clock`),
       KEY `history_log_1` (`itemid`,`clock`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8
       PARTITION BY RANGE (`clock`)
      (PARTITION `p2020_10_15` VALUES LESS THAN (1602792000) ENGINE = InnoDB,
       PARTITION `p2020_10_16` VALUES LESS THAN (1602878400) ENGINE = InnoDB,
       PARTITION `p2020_10_17` VALUES LESS THAN (1602964800) ENGINE = InnoDB,
       PARTITION `p2020_10_18` VALUES LESS THAN (1603051200) ENGINE = InnoDB,
       PARTITION `p2020_10_19` VALUES LESS THAN (1603137600) ENGINE = InnoDB,
       PARTITION `p2020_10_20` VALUES LESS THAN (1603224000) ENGINE = InnoDB,
       PARTITION `p2020_10_21` VALUES LESS THAN (1603310400) ENGINE = InnoDB,
       PARTITION `p2020_10_22` VALUES LESS THAN (1603396800) ENGINE = InnoDB,
       PARTITION `p2020_10_23` VALUES LESS THAN (1603483200) ENGINE = InnoDB,
       PARTITION `p2020_10_24` VALUES LESS THAN (1603569600) ENGINE = InnoDB,
       PARTITION `p2020_10_25` VALUES LESS THAN (1603656000) ENGINE = InnoDB,
       PARTITION `p2020_10_26` VALUES LESS THAN (1603742400) ENGINE = InnoDB,
       PARTITION `p2020_10_27` VALUES LESS THAN (1603828800) ENGINE = InnoDB,
       PARTITION `p2020_10_28` VALUES LESS THAN (1603915200) ENGINE = InnoDB,
       PARTITION `p2020_10_29` VALUES LESS THAN (1604001600) ENGINE = InnoDB,
       PARTITION `p2020_10_30` VALUES LESS THAN (1604088000) ENGINE = InnoDB,
       PARTITION `p2020_10_31` VALUES LESS THAN (1604174400) ENGINE = InnoDB,
       PARTITION `p2020_11_01` VALUES LESS THAN (1604260800) ENGINE = InnoDB,
       PARTITION `p2020_11_02` VALUES LESS THAN (1604347200) ENGINE = InnoDB,
       PARTITION `p2020_11_03` VALUES LESS THAN (1604433600) ENGINE = InnoDB,
       PARTITION `p2020_11_04` VALUES LESS THAN (1604520000) ENGINE = InnoDB,
       PARTITION `p2020_11_05` VALUES LESS THAN (1604606400) ENGINE = InnoDB,
       PARTITION `p2020_11_06` VALUES LESS THAN (1604692800) ENGINE = InnoDB,
       PARTITION `p2020_11_07` VALUES LESS THAN (1604779200) ENGINE = InnoDB,
       PARTITION `p2020_11_08` VALUES LESS THAN (1604865600) ENGINE = InnoDB,
       PARTITION `p2020_11_09` VALUES LESS THAN (1604952000) ENGINE = InnoDB,
       PARTITION `p2020_11_10` VALUES LESS THAN (1605038400) ENGINE = InnoDB,
       PARTITION `p2020_11_11` VALUES LESS THAN (1605124800) ENGINE = InnoDB,
       PARTITION `p2020_11_12` VALUES LESS THAN (1605211200) ENGINE = InnoDB,
       PARTITION `p2020_11_13` VALUES LESS THAN (1605297600) ENGINE = InnoDB,
       PARTITION `p2020_11_14` VALUES LESS THAN (1605384000) ENGINE = InnoDB,
       PARTITION `p2020_11_15` VALUES LESS THAN (1605470400) ENGINE = InnoDB,
       PARTITION `p2020_11_16` VALUES LESS THAN (1605556800) ENGINE = InnoDB,
       PARTITION `p2020_11_17` VALUES LESS THAN (1605643200) ENGINE = InnoDB,
       PARTITION `p2020_11_18` VALUES LESS THAN (1605729600) ENGINE = InnoDB,
       PARTITION `p2020_11_19` VALUES LESS THAN (1605816000) ENGINE = InnoDB,
       PARTITION `p2020_11_20` VALUES LESS THAN (1605902400) ENGINE = InnoDB,
       PARTITION `p2020_11_21` VALUES LESS THAN (1605988800) ENGINE = InnoDB,
       PARTITION `p2020_11_22` VALUES LESS THAN (1606075200) ENGINE = InnoDB,
       PARTITION `p2020_11_23` VALUES LESS THAN (1606161600) ENGINE = InnoDB,
       PARTITION `p2020_11_24` VALUES LESS THAN (1606248000) ENGINE = InnoDB,
       PARTITION `p2020_11_25` VALUES LESS THAN (1606334400) ENGINE = InnoDB,
       PARTITION `p2020_11_26` VALUES LESS THAN (1606420800) ENGINE = InnoDB,
       PARTITION `p2020_11_27` VALUES LESS THAN (1606507200) ENGINE = InnoDB,
       PARTITION `p2020_11_28` VALUES LESS THAN (1606593600) ENGINE = InnoDB,
       PARTITION `p2020_11_29` VALUES LESS THAN (1606680000) ENGINE = InnoDB,
       PARTITION `p2020_11_30` VALUES LESS THAN (1606766400) ENGINE = InnoDB,
       PARTITION `p2020_12_01` VALUES LESS THAN (1606852800) ENGINE = InnoDB,
       PARTITION `p2020_12_02` VALUES LESS THAN (1606939200) ENGINE = InnoDB,
       PARTITION `p2020_12_03` VALUES LESS THAN (1607025600) ENGINE = InnoDB,
       PARTITION `p2020_12_04` VALUES LESS THAN (1607112000) ENGINE = InnoDB,
       PARTITION `p2020_12_05` VALUES LESS THAN (1607198400) ENGINE = InnoDB,
       PARTITION `p2020_12_06` VALUES LESS THAN (1607284800) ENGINE = InnoDB,
       PARTITION `p2020_12_07` VALUES LESS THAN (1607371200) ENGINE = InnoDB,
       PARTITION `p2020_12_08` VALUES LESS THAN (1607457600) ENGINE = InnoDB,
       PARTITION `p2020_12_09` VALUES LESS THAN (1607544000) ENGINE = InnoDB,
       PARTITION `p2020_12_10` VALUES LESS THAN (1607630400) ENGINE = InnoDB,
       PARTITION `p2020_12_11` VALUES LESS THAN (1607716800) ENGINE = InnoDB,
       PARTITION `p2020_12_12` VALUES LESS THAN (1607803200) ENGINE = InnoDB,
       PARTITION `p2020_12_13` VALUES LESS THAN (1607889600) ENGINE = InnoDB,
       PARTITION `p2020_12_14` VALUES LESS THAN (1607976000) ENGINE = InnoDB,
       PARTITION `p2020_12_15` VALUES LESS THAN (1608062400) ENGINE = InnoDB,
       PARTITION `p2020_12_16` VALUES LESS THAN (1608148800) ENGINE = InnoDB,
       PARTITION `p2020_12_17` VALUES LESS THAN (1608235200) ENGINE = InnoDB,
       PARTITION `p2020_12_18` VALUES LESS THAN (1608321600) ENGINE = InnoDB,
       PARTITION `p2020_12_19` VALUES LESS THAN (1608408000) ENGINE = InnoDB,
       PARTITION `p2020_12_20` VALUES LESS THAN (1608494400) ENGINE = InnoDB,
       PARTITION `p2020_12_21` VALUES LESS THAN (1608580800) ENGINE = InnoDB,
       PARTITION `p2020_12_22` VALUES LESS THAN (1608667200) ENGINE = InnoDB,
       PARTITION `p2020_12_23` VALUES LESS THAN (1608753600) ENGINE = InnoDB,
       PARTITION `p2020_12_24` VALUES LESS THAN (1608840000) ENGINE = InnoDB,
       PARTITION `p2020_12_25` VALUES LESS THAN (1608926400) ENGINE = InnoDB,
       PARTITION `p2020_12_26` VALUES LESS THAN (1609012800) ENGINE = InnoDB,
       PARTITION `p2020_12_27` VALUES LESS THAN (1609099200) ENGINE = InnoDB,
       PARTITION `p2020_12_28` VALUES LESS THAN (1609185600) ENGINE = InnoDB,
       PARTITION `p2020_12_29` VALUES LESS THAN (1609272000) ENGINE = InnoDB,
       PARTITION `p2020_12_30` VALUES LESS THAN (1609358400) ENGINE = InnoDB,
       PARTITION `p2020_12_31` VALUES LESS THAN (1609444800) ENGINE = InnoDB,
       PARTITION `p2021_01_01` VALUES LESS THAN (1609531200) ENGINE = InnoDB,
       PARTITION `p2021_01_02` VALUES LESS THAN (1609617600) ENGINE = InnoDB,
       PARTITION `p2021_01_03` VALUES LESS THAN (1609704000) ENGINE = InnoDB,
       PARTITION `p2021_01_04` VALUES LESS THAN (1609790400) ENGINE = InnoDB,
       PARTITION `p2021_01_05` VALUES LESS THAN (1609876800) ENGINE = InnoDB,
       PARTITION `p2021_01_06` VALUES LESS THAN (1609963200) ENGINE = InnoDB,
       PARTITION `p2021_01_07` VALUES LESS THAN (1610049600) ENGINE = InnoDB,
       PARTITION `p2021_01_08` VALUES LESS THAN (1610136000) ENGINE = InnoDB,
       PARTITION `p2021_01_09` VALUES LESS THAN (1610222400) ENGINE = InnoDB,
       PARTITION `p2021_01_10` VALUES LESS THAN (1610308800) ENGINE = InnoDB,
       PARTITION `p2021_01_11` VALUES LESS THAN (1610395200) ENGINE = InnoDB,
       PARTITION `p2021_01_12` VALUES LESS THAN (1610481600) ENGINE = InnoDB,
       PARTITION `p2021_01_13` VALUES LESS THAN (1610568000) ENGINE = InnoDB,
       PARTITION `p2021_01_14` VALUES LESS THAN (1610654400) ENGINE = InnoDB,
       PARTITION `p2021_01_15` VALUES LESS THAN (1610740800) ENGINE = InnoDB,
       PARTITION `p2021_01_16` VALUES LESS THAN (1610827200) ENGINE = InnoDB,
       PARTITION `p2021_01_17` VALUES LESS THAN (1610913600) ENGINE = InnoDB,
       PARTITION `p2021_01_18` VALUES LESS THAN (1611000000) ENGINE = InnoDB,
       PARTITION `p2021_01_19` VALUES LESS THAN (1611086400) ENGINE = InnoDB,
       PARTITION `p2021_01_20` VALUES LESS THAN (1611172800) ENGINE = InnoDB,
       PARTITION `p2021_01_21` VALUES LESS THAN (1611259200) ENGINE = InnoDB,
       PARTITION `p2021_01_22` VALUES LESS THAN (1611345600) ENGINE = InnoDB,
       PARTITION `p2021_01_23` VALUES LESS THAN (1611432000) ENGINE = InnoDB,
       PARTITION `p2021_01_24` VALUES LESS THAN (1611518400) ENGINE = InnoDB,
       PARTITION `p2021_01_25` VALUES LESS THAN (1611604800) ENGINE = InnoDB,
       PARTITION `p2021_01_26` VALUES LESS THAN (1611691200) ENGINE = InnoDB,
       PARTITION `p2021_01_27` VALUES LESS THAN (1611777600) ENGINE = InnoDB,
       PARTITION `p2021_01_28` VALUES LESS THAN (1611864000) ENGINE = InnoDB,
       PARTITION `p2021_01_29` VALUES LESS THAN (1611950400) ENGINE = InnoDB,
       PARTITION `p2021_01_30` VALUES LESS THAN (1612036800) ENGINE = InnoDB,
       PARTITION `p2021_01_31` VALUES LESS THAN (1612123200) ENGINE = InnoDB,
       PARTITION `p2021_02_01` VALUES LESS THAN (1612209600) ENGINE = InnoDB,
       PARTITION `p2021_02_02` VALUES LESS THAN (1612296000) ENGINE = InnoDB,
       PARTITION `p2021_02_03` VALUES LESS THAN (1612382400) ENGINE = InnoDB,
       PARTITION `p2021_02_04` VALUES LESS THAN (1612468800) ENGINE = InnoDB,
       PARTITION `p2021_02_05` VALUES LESS THAN (1612555200) ENGINE = InnoDB,
       PARTITION `p2021_02_06` VALUES LESS THAN (1612641600) ENGINE = InnoDB,
       PARTITION `p2021_02_07` VALUES LESS THAN (1612728000) ENGINE = InnoDB,
       PARTITION `p2021_02_08` VALUES LESS THAN (1612814400) ENGINE = InnoDB,
       PARTITION `p2021_02_09` VALUES LESS THAN (1612900800) ENGINE = InnoDB,
       PARTITION `p2021_02_10` VALUES LESS THAN (1612987200) ENGINE = InnoDB,
       PARTITION `p2021_02_11` VALUES LESS THAN (1613073600) ENGINE = InnoDB,
       PARTITION `p2021_02_12` VALUES LESS THAN (1613160000) ENGINE = InnoDB,
       PARTITION `p2021_02_13` VALUES LESS THAN (1613246400) ENGINE = InnoDB)
       
      

       

            elina.kuzyutkina Elina Kuzyutkina (Inactive)
            Slavka163 Slavka
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: