[ZBX-23482] Upgrade to 7.0.0alpha5 fails on database upgrade on patch 06050008 Created: 2023 Sep 28  Updated: 2023 Sep 29  Resolved: 2023 Sep 29

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 7.0.0alpha5
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: Adrian Cunnelly Assignee: Zabbix Support Team
Resolution: Duplicate Votes: 0
Labels: database, server, upgrade
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Ubuntu 20.04 (focal), Postgresql 14, timescaleDB 2.11.1

Issue Links:
Duplicate
duplicates ZBX-23146 TSDB upgrade doesn't work Closed

 Description   

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

 Comments   
Comment by Rodrigo P [ 2023 Sep 29 ]

Hi.
There is an open issue related to this: ZBX-23146.

 

Generated at Sat May 03 07:00:27 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.