-
Problem report
-
Resolution: Unresolved
-
Trivial
-
None
-
5.4.0
-
Debian GNU/Linux 10 4.19.160-2
PostgreSQL 12.7
timescaledb-2.2.1~debian10
Steps to reproduce:
- Have zabbix Server 5.2.6 installed
- Update to 5.4.0 via PPA-sources
- Find message in errorlog
[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: foreign key constraint "c_items_3" cannot be implementedDETAIL: Key columns "valuemapid" and "valuemapid" are of incompatible types: numeric and bigint. '[alter table items add constraint c_items_3 foreign key (valuemapid) references valuemap (valuemapid)]
database upgrade failed
- Fixing this issue by switching valuemap.valuemapid from BIGINT to NUMERIC
- Find next message in errorlog:
[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: index "users_1" does not exist [drop index users_1]
database upgrade failed