Details
-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
None
-
None
-
None
Description
I'm testing zabbix v6.0 beta with the specifications below ;
OS : CentOS Stream release 8
Zabbix version : zabbix-release-5.5-1.el8
PostgreSQL version : PostgreSQL 13.5
After finishing the setup of Zabbix + PGSQL, I created the timescaledb repo. I ran following commands.
# sudo tee /etc/yum.repos.d/timescale_timescaledb.repo <<EOL [timescale_timescaledb] name=timescale_timescaledb baseurl=https://packagecloud.io/timescale/timescaledb/el/8/\$basearch repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https://packagecloud.io/timescale/timescaledb/gpgkey sslverify=1 sslcacert=/etc/pki/tls/certs/ca-bundle.crt metadata_expire=300 EOL # yum install timescaledb-2-loader-postgresql-13-2.1.1 # yum install timescaledb-2-postgresql-13-2.1.1 # echo "shared_preload_libraries = 'timescaledb'" >> /var/lib/pgsql/13/data/postgresql.conf # echo "timescaledb.license=timescale" >> /var/lib/pgsql/13/data/postgresql.conf # sudo systemctl restart postgresql-13 # sudo -u postgres timescaledb-tune --quiet --yes --pg-config=/usr/pgsql-13/bin/pg_config # echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix 2>/dev/nullcat /usr/share/doc/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix
After executing the last command ,whatever I change I receive the same error.
NOTICE: PostgreSQL version 13.5 is valid NOTICE: TimescaleDB extension is detected NOTICE: TimescaleDB version 2.2.1 is valid ERROR: relation "history" does not exist LINE 1: SELECT create_hypertable('history', 'clock', chunk_time_inte... ^ QUERY: SELECT create_hypertable('history', 'clock', chunk_time_interval => 86400, migrate_data => true) CONTEXT: PL/pgSQL function inline_code_block line 59 at PERFORM
I made my tests beginning from timescaleDB v2.1 to v2.3. Each time I got the same results.
Regards.
Mehmet