-
Problem report
-
Resolution: Duplicate
-
Trivial
-
None
-
7.0.0alpha5
-
Ubuntu 20.04 (focal), Postgresql 14, timescaleDB 2.11.1
Upgrading from 6.4.1 to 7.0.0alpha5 fails during the database upgrade with:
44973:20230928:184943.699 starting automatic database upgrade 44973:20230928:184943.700 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: operation not supported on hypertables that have compression enabled [alter table history alter value type double precision; alter table history alter value set default '0.0000'] 44973:20230928:184943.700 database upgrade failed on patch 06050008
The 'value' field in the history table is already 'double precision' so wasn't expecting this DB patch to be applied:
zabbix=# \d history Table "public.history" Column | Type | Collation | Nullable | Default --------+------------------+-----------+----------+----------------------- itemid | bigint | | not null | clock | integer | | not null | 0 value | double precision | | not null | '0'::double precision ns | integer | | not null | 0
- duplicates
-
ZBX-23146 TSDB upgrade doesn't work
- Closed