Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20423

timescaledb error during zabbix v6.0 setup

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Won't fix
    • 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

       

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            mbuyukkarakas Mehmet Ali Buyukkarakas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: