[ZBXNEXT-9535] Support for TimescaleDB 2.17 Created: 2024 Oct 13  Updated: 2024 Oct 16  Resolved: 2024 Oct 14

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature Request Priority: Trivial
Reporter: Arkadiusz Wszolek Assignee: Zabbix Development Team
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBXNEXT-9532 Add Timescale 2.17.x support Closed

 Description   

112597:20241013:165138.458 Starting Zabbix Server. Zabbix 7.0.4 (revision f383737f108).
112597:20241013:165138.458 ****** Enabled features ******
112597:20241013:165138.458 SNMP monitoring:           YES
112597:20241013:165138.458 IPMI monitoring:           YES
112597:20241013:165138.458 Web monitoring:            YES
112597:20241013:165138.458 VMware monitoring:         YES
112597:20241013:165138.458 SMTP authentication:       YES
112597:20241013:165138.458 ODBC:                      YES
112597:20241013:165138.458 SSH support:               YES
112597:20241013:165138.458 IPv6 support:              YES
112597:20241013:165138.458 TLS support:               YES
112597:20241013:165138.458 ******************************
112597:20241013:165138.458 using configuration file: /etc/zabbix/zabbix_server.conf
112597:20241013:165138.484 Unsupported DB! timescaledb version 21700 is newer than 21699
112597:20241013:165138.484 TimescaleDB version is too new. Recommended version is up to TimescaleDB Community Edition 2.16.
112597:20241013:165138.488 Zabbix Server stopped. Zabbix 7.0.4 (revision f383737f108).
 
When I tried install 2.16 version my system requires version 2.17
 
apt install timescaledb-2-porstgresql-16='2.16.0*' timescaledb-2-loader-postgresql-16='2.16.0*' postgresql-client-16
 
115756:20241013:183905.719 Starting Zabbix Server. Zabbix 7.0.4 (revision f383737f108).
115756:20241013:183905.719 ****** Enabled features ******
115756:20241013:183905.719 SNMP monitoring:           YES
115756:20241013:183905.719 IPMI monitoring:           YES
115756:20241013:183905.719 Web monitoring:            YES
115756:20241013:183905.720 VMware monitoring:         YES
115756:20241013:183905.720 SMTP authentication:       YES
115756:20241013:183905.720 ODBC:                      YES
115756:20241013:183905.720 SSH support:               YES
115756:20241013:183905.720 IPv6 support:              YES
115756:20241013:183905.720 TLS support:               YES
115756:20241013:183905.720 ******************************
115756:20241013:183905.720 using configuration file: /etc/zabbix/zabbix_server.conf
115756:20241013:183905.734 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  could not access file "$libdir/timescaledb-2.17.0": No such file or directory
[set escape_string_warning to off]
 
I don't understand because i didn't instal version 2.17 only 2.16
 
echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix
ERROR:  could not access file "$libdir/timescaledb-2.17.0": No such file or directory
 

 Comments   
Comment by Alexander Vladishev [ 2024 Oct 14 ]

Closed as duplicate of ZBXNEXT-9532. Please follow updates there.

Comment by Arkadiusz Wszolek [ 2024 Oct 14 ]

sasha I don't understand. I tried to install version lower as 2.17 and this is the problem. How can I install version 2.16. Maybe I have to create bug with version 2.16 ? I know that I can change AllowUnsupportedDBVersions to 1 in the Zabbix server configuration file but this is for version 2.17 and is working. Follow your updates is unresolved, we have to wait for resolusion for version 2.17 ? I tried configure zabbix with TSDB 2.16 but it's not possible because something is missing.

Comment by Alexander Vladishev [ 2024 Oct 14 ]

As I understand it, this ticket is requesting support for TSDB 2.17. Such support will be added as part of ticket ZBXNEXT-9532 in upcoming Zabbix releases. This will not require any changes to the Zabbix code, so you can use TSDB 2.17 with the AllowUnsupportedDBVersions flag.

The error visible in the server log file points to an issue with the TSDB configuration, not with Zabbix.

could not access file "$libdir/timescaledb-2.17.0": No such file or directory
Generated at Tue Mar 11 04:56:26 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.