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

Stock TimescaleDB extension at Azure cloud

    XMLWordPrintable

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 65 (Jun 2020), Sprint 66 (Jul 2020), Sprint 67 (Aug 2020)
    • Story Points:
      1

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            talbergs Mārtiņš Tālbergs (Inactive)
            Reporter:
            aigars.kadikis Aigars Kadikis
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: