Hi
I am doing a migration of zabbix from version 4.4 to version 5.2
I am running a new server appliance 5.2. From the old zabbix 4.4 I exported the database and imported it on the new server. The problem is that I need to upgrade the database from version 4050015 to 5020000. Automatic upgrade failed.
4650:20210223:091207.982 database upgrade failed
4654:20210223:091218.221 Starting Zabbix Server. Zabbix 5.2.4 (revision e9f58de09c).
4654:20210223:091218.221 ****** Enabled features ******
4654:20210223:091218.221 SNMP monitoring: YES
4654:20210223:091218.221 IPMI monitoring: YES
4654:20210223:091218.221 Web monitoring: YES
4654:20210223:091218.221 VMware monitoring: YES
4654:20210223:091218.221 SMTP authentication: YES
4654:20210223:091218.221 ODBC: YES
4654:20210223:091218.221 SSH support: YES
4654:20210223:091218.221 IPv6 support: YES
4654:20210223:091218.221 TLS support: YES
4654:20210223:091218.221 ******************************
4654:20210223:091218.221 using configuration file: /etc/zabbix/zabbix_server.conf
4654:20210223:091218.228 current database version (mandatory/optional): 04050015/04050015
4654:20210223:091218.228 required mandatory version: 05020000
4654:20210223:091218.228 starting automatic database upgrade
4654:20210223:091218.241 completed 0% of database upgrade
4654:20210223:091218.275 completed 1% of database upgrade
4654:20210223:091218.293 completed 2% of database upgrade
4654:20210223:091218.311 completed 3% of database upgrade
4654:20210223:091218.392 completed 4% of database upgrade
4654:20210223:091218.468 completed 5% of database upgrade
4654:20210223:091218.543 completed 6% of database upgrade
4654:20210223:091218.544 [Z3005] query failed: [1050] Table 'module' already exists [create table module (
`moduleid` bigint unsigned not null,
`id` varchar(255) default '' not null,
`relative_path` varchar(255) default '' not null,
`status` integer default '0' not null,
`config` text not null,
primary key (moduleid)
) engine=innodb]
I am doing a migration of zabbix from version 4.4 to version 5.2
I am running a new server appliance 5.2. From the old zabbix 4.4 I exported the database and imported it on the new server. The problem is that I need to upgrade the database from version 4050015 to 5020000. Automatic upgrade failed.
4650:20210223:091207.982 database upgrade failed
4654:20210223:091218.221 Starting Zabbix Server. Zabbix 5.2.4 (revision e9f58de09c).
4654:20210223:091218.221 ****** Enabled features ******
4654:20210223:091218.221 SNMP monitoring: YES
4654:20210223:091218.221 IPMI monitoring: YES
4654:20210223:091218.221 Web monitoring: YES
4654:20210223:091218.221 VMware monitoring: YES
4654:20210223:091218.221 SMTP authentication: YES
4654:20210223:091218.221 ODBC: YES
4654:20210223:091218.221 SSH support: YES
4654:20210223:091218.221 IPv6 support: YES
4654:20210223:091218.221 TLS support: YES
4654:20210223:091218.221 ******************************
4654:20210223:091218.221 using configuration file: /etc/zabbix/zabbix_server.conf
4654:20210223:091218.228 current database version (mandatory/optional): 04050015/04050015
4654:20210223:091218.228 required mandatory version: 05020000
4654:20210223:091218.228 starting automatic database upgrade
4654:20210223:091218.241 completed 0% of database upgrade
4654:20210223:091218.275 completed 1% of database upgrade
4654:20210223:091218.293 completed 2% of database upgrade
4654:20210223:091218.311 completed 3% of database upgrade
4654:20210223:091218.392 completed 4% of database upgrade
4654:20210223:091218.468 completed 5% of database upgrade
4654:20210223:091218.543 completed 6% of database upgrade
4654:20210223:091218.544 [Z3005] query failed: [1050] Table 'module' already exists [create table module (
`moduleid` bigint unsigned not null,
`id` varchar(255) default '' not null,
`relative_path` varchar(255) default '' not null,
`status` integer default '0' not null,
`config` text not null,
primary key (moduleid)
) engine=innodb]