-
Problem report
-
Resolution: Fixed
-
Major
-
5.0.1
-
None
-
Sprint 65 (Jun 2020), Sprint 66 (Jul 2020), Sprint 67 (Aug 2020)
-
1
PostgreSQL 11 running at Azure RDS.
Zabbix 5.0.1.
TimescaleDB 1.3.2
When cleaning history and trends for an individual item it produces an error:
pg_query(): Query failed: ERROR: relation "timescaledb_information.compressed_hypertable_stats" does not exist LINE 1: ...esce(sum(number_compressed_chunks),0) chunks FROM timescaled... ^ [items.php:886 → CHistoryManager->deleteHistory() → CHistoryManager->deleteHistoryFromSql() → PostgresqlDbBackend::isCompressed() → DBselect() → pg_query() in include/db.inc.php:247] Error in query [SELECT coalesce(sum(number_compressed_chunks),0) chunks FROM timescaledb_information.compressed_hypertable_stats WHERE number_compressed_chunks != 0 AND (hypertable_name::text IN ('history_uint','trends_uint'))] [ERROR: relation "timescaledb_information.compressed_hypertable_stats" does not exist LINE 1: ...esce(sum(number_compressed_chunks),0) chunks FROM timescaled... ^] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [items.php:886 → CHistoryManager->deleteHistory() → CHistoryManager->deleteHistoryFromSql() → DBexecute() → pg_query() in include/db.inc.php:348] Error in query [DELETE FROM history_uint WHERE itemid=584727] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
The version of extensions is not customizable. Currently, it's tied with version 1.3.2
https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions
Is it possible to have a user-friendly solution/workaround?
P.S. With TimescaleDB 1.5.0 or 1.7.0 and PostgreSQL 11 the "Clear History and Trends" button works well.
