Ad Widget

Collapse

Database update version

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Shady79
    Junior Member
    • Feb 2021
    • 1

    #1

    Database update version

    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]

    Last edited by Shady79; 23-02-2021, 11:29.
Working...