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

Details

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

    Description

      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)]
      
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: