Postgresql update from 15 to 17 with TimescaleDB

[Sined_r]

Hello,

I would like to migrate my Zabbix server to a new VM and upgrade the somewhat older PostgreSQL version, but then I have the problem that my graphs displaying data older than 7 days are partially defective.

Zabbix LTS 7 on debian 12 with php and nginx

First I upgraded the timescale DB version to 2.7.2:

sudo service zabbix-server stop  
sudo service zabbix-agent stop

su postgres
psql -X
\c zabbix
ALTER EXTENSION timescaledb UPDATE TO '2.17.2';

after a restart I have no errors in the log or on the web interface.

When updating the Postgresql database

sudo service zabbix-server stop  
sudo service zabbix-agent stop

sudo apt-get -y install postgresql-16
sudo apt-get -y install timescaledb-2-postgresql-16='2.17.2*' timescaledb-2-loader-postgresql-16='2.17.2*'
sudo pg_lsclusters
sudo pg_dropcluster 16 main --stop
sudo pg_upgradecluster 15 main
sudo pg_dropcluster 15 main
sudo apt purge postgresql-15 postgresql-client-15 -y
sudo pg_lsclusters

but I get many such errors:

pg_restore: error: could not execute query: ERROR: operation not supported on chunk tables
The statement was: ALTER TABLE _timescaledb_internal._hyper_1_5960_chunk DISABLE TRIGGER ALL;

The values of the items all seem to be retrievable.
But when I want to view the items in a graph, I often get the following error:


Unfortunately, I can't get a better display of the error
I have also tried to create a dump, then go to 16 and import the dump again. Same behavior.

Any idea how I can fix this problem?

Thanks for your help!!!