[ZBXNEXT-8570] Remove TimescaleDB v1.x support Created: 2023 Jul 12  Updated: 2024 Jun 10  Resolved: 2023 Sep 26

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Frontend (F), Server (S)
Affects Version/s: None
Fix Version/s: 7.0.0alpha5, 7.0 (plan)

Type: Change Request Priority: Trivial
Reporter: Alex Kalimulin Assignee: dimir
Resolution: Fixed Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PDF File ZBXNEXT-8570-after.pdf     PDF File ZBXNEXT-8570-before.pdf    
Issue Links:
Causes
causes ZBX-24594 Removal of TimescaleDB v1.x support i... Closed
causes ZBX-24589 The upgrade from Zabbix 6.4 to 7.0 fa... Closed
Sub-task
part of ZBX-23301 Incompatible TimescaleDB version list... Closed
Team: Team I
Sprint: Sprint 102 (Jul 2023), Sprint 103 (Aug 2023), Sprint 104 (Sep 2023)
Story Points: 2

 Description   

Remove support for TSDB 1.x from Zabbix server and frontend.

This means bumping ZBX_TIMESCALE_MIN_VERSION to 20000 (or 20001) and removing all the code that is surrounded by ZBX_DB_TSDB_V1 from the server.

The frontend must also remove any TSDB v1.x conditional code (e.g. isCompressed() in PostgresqlDbBackend).

The docs must remove mentions of TSDB v1.x (if any, I didn’t find ones).

 Comments   
Comment by dimir [ 2023 Aug 31 ]

As I understand we drop support for versions <= 1.7.5 (Feb 16, 2021)

Comment by dimir [ 2023 Sep 01 ]

Talking about TimescaleDB versions that Zabbix supports, in 7.0 we will increase the absolute minimum supported version to 2.0.1 and recommended minimum to 2.10.0:

Description Before After Comment
Absolute minimum version ​1.5.0 ​2.0.1 Zabbix will not work with version less than that under no circumstances 
Minimum version 2.0.1 2.10.0 Zabbix will work with version less than that if AllowUnsupportedDBVersions=1 (see here for more information)
Maximum version 2.11.* 2.11.* Zabbix will work normally with version up to that (including)
Too new version 2.12+ 2.12+ Zabbix will work with that version if AllowUnsupportedDBVersions=1
Comment by dimir [ 2023 Sep 06 ]

Fixed in development branch for pre-7.0.

Before this fix there were 2 separate functions:

  • for getting TSDB details
  • for checking TSDB details

The latter function was reporting error when TSDB version was too old, while details were already collected (by the previous function). The first function was using different SQL queries when talking to v1 and v2 TSDB (for getting license and compressed chunk flags).

ZBXNEXT-8570-before.pdf

Since we removed support for v1 we must perform the version check first.

This is why it was decided to combine those 2 functions and go one by one, getting a detail, reporting error if it isn't satisfactory.

ZBXNEXT-8570-after.pdf

One issue, I'm not sure if the function zbx_tsdb_get_license() that was moved from zbxdb to zbxdbhigh should be using zbx_db_*() or zbx_db_*_basic() functions.

Comment by dimir [ 2023 Sep 25 ]

Overview

The TimescaleDB version requirements from Zabbix perspective where changed in this commit.

Description Before this change After this change Comment
Absolute minimum version ​1.5.0 ​2.0.1 Zabbix will not work with version less than that under no circumstances 
Minimum version 2.0.1 2.10.0 Zabbix will work with version less than that if AllowUnsupportedDBVersions=1 (see here for more information)
Maximum version 2.11.* 2.11.* Zabbix will work normally with version up to that (including)
Too new version 2.12+ 2.12+ Zabbix will work with that version if AllowUnsupportedDBVersions=1

Fixed in

Generated at Mon Mar 31 04:50:04 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.