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

Zabbix 5.0.11 doesn't work with PostgreSQL 12 and TimescaleDB 2.5

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • None
    • Server (S)
    • None

      Environment:

      TimescaleDB is indeed 2.5 for PostgreSQL 12.

      Zabbix server is in version 5.0.11.

      -----------------------------------

      package timescale : 12-2.5.0-0
      version postgres : 
      postgres=# SELECT version();
                                                       version
      ---------------------------------------------------------------------------------------------------------
      PostgreSQL 12.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
      (1 row)
      
      zabbix=# SELECT * FROM pg_available_extensions ORDER BY name;
              name        | default_version | installed_version |                               comment
      ---------------------------------------------------+---------------------------------------------------------------------
       adminpack          | 2.0             |                   | administrative functions for PostgreSQL
       amcheck            | 1.2             |                   | functions for verifying relation integrity
       autoinc            | 1.0             |                   | functions for autoincrementing fields
       bloom              | 1.0             |                   | bloom access method - signature file based index
       btree_gin          | 1.3             |                   | support for indexing common datatypes in GIN
       btree_gist         | 1.5             |                   | support for indexing common datatypes in GiST
       citext             | 1.6             |                   | data type for case-insensitive character strings
       cube               | 1.4             |                   | data type for multidimensional cubes
       dblink             | 1.2             |                   | connect to other PostgreSQL databases from within a database
       dict_int           | 1.0             |                   | text search dictionary template for integers
       dict_xsyn          | 1.0             |                   | text search dictionary template for extended synonym processing
       earthdistance      | 1.1             |                   | calculate great-circle distances on the surface of the Earth
       file_fdw           | 1.0             |                   | foreign-data wrapper for flat file access
       fuzzystrmatch      | 1.1             |                   | determine similarities and distance between strings
       hstore             | 1.6             |                   | data type for storing sets of (key, value) pairs
       hstore_plperl      | 1.0             |                   | transform between hstore and plperl
       hstore_plperlu     | 1.0             |                   | transform between hstore and plperlu
       insert_username    | 1.0             |                   | functions for tracking who changed a table
       intagg             | 1.1             |                   | integer aggregator and enumerator (obsolete)
       intarray           | 1.2             |                   | functions, operators, and index support for 1-D arrays of integers
       isn                | 1.2             |                   | data types for international product numbering standards
       jsonb_plperl       | 1.0             |                   | transform between jsonb and plperl
       jsonb_plperlu      | 1.0             |                   | transform between jsonb and plperlu
       lo                 | 1.1             |                   | Large Object maintenance
       ltree              | 1.1             |                   | data type for hierarchical tree-like structures
       moddatetime        | 1.0             |                   | functions for tracking last modification time
       pageinspect        | 1.7             |                   | inspect the contents of database pages at a low level
       pg_buffercache     | 1.3             |                   | examine the shared buffer cache
       pg_freespacemap    | 1.2             |                   | examine the free space map (FSM)
       pg_prewarm         | 1.2             |                   | prewarm relation data
       pg_stat_statements | 1.7             |                   | track execution statistics of all SQL statements executed
       pg_trgm            | 1.4             |                   | text similarity measurement and index searching based on trigrams
       pg_visibility      | 1.2             |                   | examine the visibility map (VM) and page-level visibility info
       pgcrypto           | 1.3             |                   | cryptographic functions
       pgrowlocks         | 1.2             |                   | show row-level locking information
       pgstattuple        | 1.5             |                   | show tuple-level statistics
       plpgsql            | 1.0             | 1.0               | PL/pgSQL procedural language
       postgres_fdw       | 1.0             |                   | foreign-data wrapper for remote PostgreSQL servers
       refint             | 1.0             |                   | functions for implementing referential integrity (obsolete)
       seg                | 1.3             |                   | data type for representing line segments or floating-point intervals
       sslinfo            | 1.2             |                   | information about SSL certificates
       tablefunc          | 1.0             |                   | functions that manipulate whole tables, including crosstab
       tcn                | 1.0             |                   | Triggered change notifications
       timescaledb        | 2.5.0           | 2.5.0             | Enables scalable inserts and complex queries for time-series data
       tsm_system_rows    | 1.0             |                   | TABLESAMPLE method which accepts number of rows as a limit
       tsm_system_time    | 1.0             |                   | TABLESAMPLE method which accepts time in milliseconds as a limit
       unaccent           | 1.1             |                   | text search dictionary that removes accents
       uuid-ossp          | 1.1             |                   | generate universally unique identifiers (UUIDs)
       xml2               | 1.1             |                   | XPath querying and XSLT
      -------------------------------------------------------------------------------------------
      

      Errors:

         181:20211122:100044.155 log level has been increased to 2 (error)
         181:20211122:100100.405 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid hypertable or continuous aggregate[SELECT drop_chunks(1629795660,'history')]
         181:20211122:100100.405 cannot drop chunks for history
         181:20211122:100100.406 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid hypertable or continuous aggregate[SELECT drop_chunks(1629795660,'history_str')]
         181:20211122:100100.406 cannot drop chunks for history_str
         181:20211122:100100.407 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid hypertable or continuous aggregate[SELECT drop_chunks(1629795660,'history_log')]
         181:20211122:100100.407 cannot drop chunks for history_log
         181:20211122:100100.407 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid hypertable or continuous aggregate[SELECT drop_chunks(1629795660,'history_uint')]
         181:20211122:100100.407 cannot drop chunks for history_uint
         181:20211122:100100.407 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid hypertable or continuous aggregate[SELECT drop_chunks(1629795660,'history_text')]
         181:20211122:100100.407 cannot drop chunks for history_text
         181:20211122:100100.410 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid hypertable or continuous aggregate[SELECT drop_chunks(1606035660,'trends')]
         181:20211122:100100.410 cannot drop chunks for trends
         181:20211122:100100.410 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid hypertable or continuous aggregate[SELECT drop_chunks(1606035660,'trends_uint')]
         181:20211122:100100.411 cannot drop chunks for trends_uint

            zabbix.support Zabbix Support Team
            avolodin Aleksey Volodin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: