-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
5.4.2
-
None
-
None
-
Raspberry Pi OS
Steps to reproduce:
- Update packages to 5.2 or 5.4
- tested with native packages and docker images for 5.2 and 5.4. All yeild the same database upgrade issue. It seems it tries to recreate the database rather than update the existing database?
- Restart services
- Database upgrade fails
Result:
18213:20210703:134859.510 Starting Zabbix Server. Zabbix 5.4.2 (revision 4c8f9aabe1). 18213:20210703:134859.510 ****** Enabled features ****** 18213:20210703:134859.510 SNMP monitoring: YES 18213:20210703:134859.510 IPMI monitoring: YES 18213:20210703:134859.511 Web monitoring: YES 18213:20210703:134859.511 VMware monitoring: YES 18213:20210703:134859.511 SMTP authentication: YES 18213:20210703:134859.511 ODBC: YES 18213:20210703:134859.511 SSH support: YES 18213:20210703:134859.511 IPv6 support: YES 18213:20210703:134859.511 TLS support: YES 18213:20210703:134859.511 ****************************** 18213:20210703:134859.511 using configuration file: /etc/zabbix/zabbix_server.conf 18213:20210703:134859.791 Unsupported DB! MySQL version is 50651 which is smaller than minimum of 50728 18213:20210703:134859.954 current database version (mandatory/optional): 05010052/05010052 18213:20210703:134859.954 required mandatory version: 05040000 18213:20210703:134859.954 starting automatic database upgrade 18213:20210703:134859.992 [Z3005] query failed: [1050] Table 'role' already exists [create table role ( `roleid` bigint unsigned not null, `name` varchar(255) default '' not null, `type` integer default '0' not null, `readonly` integer default '0' not null, primary key (roleid) ) engine=innodb] 18213:20210703:134900.019 database upgrade failed
Expected:
Database upgrade should succeed.
Also reported here:
https://www.zabbix.com/forum/zabbix-help/413928-erro-ap%C3%B3s-atualizar-para-a-vers%C3%A3o-5-2-1