Hi!
Tried to upgrade from 4.2 to 4.4, bt during database update the error occcured. I restored database from backup but upgrade is failed again
I downgraded zabbix server to 4.2.8, but when start it have another error
Which version of zabbix server should I use to conect database version 04030002?
And why do I have this error [Z3005] query failed: [1050] Table 'item_rtdata' already exists [create table item_rtdata ?
Tried to upgrade from 4.2 to 4.4, bt during database update the error occcured. I restored database from backup but upgrade is failed again
24038:20191213:083540.179 current database version (mandatory/optional): 04030002/04030002
24038:20191213:083540.179 required mandatory version: 04040000
24038:20191213:083540.179 starting automatic database upgrade
24038:20191213:083540.179 [Z3005] query failed: [1050] Table 'item_rtdata' already exists [create table item_rtdata (
`itemid` bigint unsigned not null,
`lastlogsize` bigint unsigned default '0' not null,
`state` integer default '0' not null,
`mtime` integer default '0' not null,
`error` varchar(2048) default '' not null,
primary key (itemid)
) engine=innodb]
24038:20191213:083540.179 database upgrade failed
24038:20191213:083540.179 required mandatory version: 04040000
24038:20191213:083540.179 starting automatic database upgrade
24038:20191213:083540.179 [Z3005] query failed: [1050] Table 'item_rtdata' already exists [create table item_rtdata (
`itemid` bigint unsigned not null,
`lastlogsize` bigint unsigned default '0' not null,
`state` integer default '0' not null,
`mtime` integer default '0' not null,
`error` varchar(2048) default '' not null,
primary key (itemid)
) engine=innodb]
24038:20191213:083540.179 database upgrade failed
24419:20191213:084453.697 The server does not match Zabbix database. Current database version (mandatory/optional): 04030002/04030002. Required mandatory version: 04020000.
And why do I have this error [Z3005] query failed: [1050] Table 'item_rtdata' already exists [create table item_rtdata ?