hi, thank for the reply. i am sorry to ask this stupid question but i did not this command anywhere in manuals to run zabbix binaries.
Ad Widget
Collapse
Zabbix 3.2 upgrade failed
Collapse
X
-
-
Upgrade from 2.2.x to 3.2.x
I'm trying to run through the upgrade by building a new server with version 2.2, import my data base and running the upgrade using repos - keep all the data we currently have is very important for us.
here is the error im getting (It also failed earlier but i was able to move forward by running SET GLOBAL FOREIGN_KEY_CHECKS=0; ):
16808:20170508:165809.778 database upgrade failed
16817:20170508:165820.027 Starting Zabbix Server. Zabbix 3.2.6 (revision 67849).
16817:20170508:165820.027 ****** Enabled features ******
16817:20170508:165820.027 SNMP monitoring: YES
16817:20170508:165820.027 IPMI monitoring: YES
16817:20170508:165820.027 Web monitoring: YES
16817:20170508:165820.027 VMware monitoring: YES
16817:20170508:165820.027 SMTP authentication: YES
16817:20170508:165820.027 Jabber notifications: YES
16817:20170508:165820.027 Ez Texting notifications: YES
16817:20170508:165820.027 ODBC: YES
16817:20170508:165820.027 SSH2 support: YES
16817:20170508:165820.027 IPv6 support: YES
16817:20170508:165820.027 TLS support: YES
16817:20170508:165820.027 ******************************
16817:20170508:165820.027 using configuration file: /etc/zabbix/zabbix_server.conf
16817:20170508:165820.030 current database version (mandatory/optional): 02030020/02030020
16817:20170508:165820.030 required mandatory version: 03020000
16817:20170508:165820.030 starting automatic database upgrade
16817:20170508:165820.030 [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]
16817:20170508:165820.030 database upgrade failedComment
Comment