-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
3.0.31, 5.2.4
-
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)