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

Execution of housekeeper on TimescaleDB causes query error on history_bin table

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 7.0.0alpha6, 7.0 (plan)
    • 7.0.0alpha1
    • Server (S)
    • None
    • Sprint 103 (Aug 2023), Sprint 104 (Sep 2023)
    • 1

      Forced execution of housekeeper after Zabbix server with Timescale start produces the following error:

       55029:20230726:110845.126 forced execution of the housekeeper
 55029:20230726:110845.126 executing housekeeper
 55029:20230726:110845.159 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  "history_bin" is not a hypertable or a continuous aggregate
HINT:  The operation is only possible on a hypertable or continuous aggregate.
 [select drop_chunks(relation=>'history_bin',older_than=>1682582925)]
 55029:20230726:110845.160 cannot drop chunks for history_bin
 55029:20230726:110845.170 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 0.029770 sec, idle for 1 hour(s)]

            arimdjonoks Artjoms Rimdjonoks
            ak Andrejs Kozlovs
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: