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

Do not keep history and trends doesn't work for TimeScaleDB

XMLWordPrintable

    • Sprint 62 (Mar 2020), Sprint 63 (Apr 2020), Sprint 64 (May 2020), Sprint 65 (Jun 2020), Sprint 66 (Jul 2020), Sprint 67 (Aug 2020), Sprint 68 (Sep 2020), Sprint 69 (Oct 2020), Sprint 70 (Nov 2020), Sprint 71 (Dec 2020), Sprint 72 (Jan 2021), Sprint 73 (Feb 2021)
    • 0.25

      Steps to reproduce:

      1. Setup Zabbix with TimescaleDB support
      2. Collect some data from items
      3. Go to Administration -> General-> Housekeeping
      4. Check that option "Override item period" is selected for history and trends
      5. Type 0 in "Data storage period" for history and trends, which means do not keep history and trends
      6. Reload configuration cache and execute housekeeper "zabbix_server -R housekeeper_execute"
      7. Check log and items values in DB

      Result: warnings in log:

      invalid history storage period for table 'history'
invalid history storage period for table 'history_str'
...
invalid history storage period for table 'trends'

      Items values remained in the database.
      Expected:
      Items values deleted from DB and no warnings in log

            arimdjonoks Artjoms Rimdjonoks
            natalja.zabbix Natalja Romancaka
            Team C
            Votes:
            2 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: