-
Problem report
-
Resolution: Duplicate
-
Critical
-
None
-
None
-
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
- part of
-
ZBXNEXT-7068 Compression doesn't work with TimescaleDB 2.5.0
- Closed