Archives

Zabbix 2.2.2 → 2.4.7 で、バージョンアップの際に、困難だったことが解決できました。

[crayon]
$ sudo vi /var/log/zabbix-server/zabbix_server.log

———————————————————————————–
5588:20170527:131024.917 Starting Zabbix Server. Zabbix 2.4.7 (revision 56694).
5588:20170527:131024.919 ****** Enabled features ******
5588:20170527:131024.919 SNMP monitoring: YES
5588:20170527:131024.919 IPMI monitoring: YES
5588:20170527:131024.919 WEB monitoring: YES
5588:20170527:131024.919 VMware monitoring: YES
5588:20170527:131024.919 Jabber notifications: YES
5588:20170527:131024.919 Ez Texting notifications: YES
5588:20170527:131024.919 ODBC: YES
5588:20170527:131024.919 SSH2 support: YES
5588:20170527:131024.919 IPv6 support: YES
5588:20170527:131024.919 ******************************
5588:20170527:131024.919 using configuration file: /etc/zabbix/zabbix_server.conf
5588:20170527:131024.934 current database version (mandatory/optional): 02020000/02020000
5588:20170527:131024.935 required mandatory version: 02040000
5588:20170527:131024.935 starting automatic database upgrade
5588:20170527:131024.939 completed 0% of database upgrade
5588:20170527:131024.948 completed 1% of database upgrade
5588:20170527:131024.963 completed 2% of database upgrade
5588:20170527:131024.967 completed 3% of database upgrade
5588:20170527:131024.976 completed 4% of database upgrade
5588:20170527:131024.991 completed 5% of database upgrade
5588:20170527:131025.071 completed 6% of database upgrade
5588:20170527:131025.108 completed 7% of database upgrade
5588:20170527:131025.111 completed 8% of database upgrade
5588:20170527:131025.120 completed 9% of database upgrade
5588:20170527:131025.195 completed 10% of database upgrade
5588:20170527:131025.262 completed 11% of database upgrade
5588:20170527:131025.283 completed 12% of database upgrade
5588:20170527:131025.310 completed 13% of database upgrade
5588:20170527:131025.322 completed 14% of database upgrade
5588:20170527:131025.359 completed 15% of database upgrade
5588:20170527:131025.399 completed 16% of database upgrade
5588:20170527:131025.416 completed 17% of database upgrade
5588:20170527:131025.417 [Z3005] query failed: [1050] Table ‘item_condition’ already exists [create table item_condition (
item_conditionid bigint unsigned not null,
itemid bigint unsigned not null,
operator integer default ‘8’ not null,
macro varchar(64) default ” not null,
value varchar(255) default ” not null,
primary key (item_conditionid)
) engine=innodb]
5588:20170527:131025.417 database upgrade failed
[/crayon]

こんなエラーが出ておりました。そして、あれこれ試した結果、下記に書いてある通り、「item_condition」を消してみたところ、上手くZabbixがインストールが出来ました。

参照:zabbix2.4 update/database upgrade failedにハマる・・・ – ぽぽぽぽーんのネットワークとOSS http://komeiy.hatenablog.com/entry/2014/10/14/234405