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

Housekeeping not working

    XMLWordPrintable

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 47, Dec 2018, Sprint 56 (Sep 2019), Sprint 55 (Aug 2019), Sprint 49 (Feb 2019), Sprint 50 (Mar 2019), Sprint 51 (Apr 2019), Sprint 52 (May 2019), Sprint 53 (Jun 2019), Sprint 54 (Jul 2019), Sprint 57 (Oct 2019)
    • Story Points:
      0.5

      Description

      Hi,

      Either there is a bug or something I don't understand, apologies if it's the latter!

      We're planning an upgrade from v3.4.14 to v4 and in anticipation of a large and slow data upgrade (85GB DB) we've reduced the history period to 1d in Administration > Housekeeping.  Typical values are 1w to 2w.

      As data sizes didn't reduce significantly, we're looked in the DB and found very old data which hasn't been removed by the housekeeper (which we've confirmed is running in the log and also run manually).

      Current settings: 

      Events and alerts
      Enable internal housekeeping YES

      Trigger data storage period 90d
      Internal data storage period 30d
      Network discovery data storage period 7d
      Auto-registration data storage period 7d

      Services
      Enable internal housekeeping YES
      Data storage period 7d

      Audit
      Enable internal housekeeping YES
      Data storage period 7d

      User sessions
      Enable internal housekeeping YES
      Data storage period 7d

      History
      Enable internal housekeeping YES
      Override item history period YES
      Data storage period 1d

      Trends
      Enable internal housekeeping YES
      Override item trend period YES
      Data storage period 365d

      Data which we see in the DB is as follows:

      • events: 2017-09-27
      • history: 2018-09-14
      • history_text: 2016-07-11
      • history_uint: 2014-10-14
      • trends: 2014-10-08
      • trends_uint: 2014-10-08
      • Data sizes and row counts:
       Table  Size in MB  Row count
       trends_uint 21,220 307,061,092
       history_uint 19,208 45,394,092
       event_recovery 13,271 62,080,921
       EVENTS 12,427 152,549,952
       trends 2,612 33,321,085
       history 1,802 3,772,682
       history_text 1,695 1,911,462
       history_str 567 3,605,497

       

      Thanks!

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              vso Vladislavs Sokurenko
              Reporter:
              seannienaber@gmail.com Sean Nienaber
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: