Project

General

Profile

Actions

Feature #27024

closed

Audits cleanup

Added by Kavita Gaikwad almost 5 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
High
Category:
Audit Log
Target version:
-
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1703496

Description of problem:
Satellite audits cleanup

Version-Release number of selected component (if applicable):
Satellite 6.4.2

How reproducible:
Always

Steps to Reproduce:
1.Some production Satellites have more than 5 million audit entries which degrades the performance of Satellite audit UI. Need an automatic cleanup mechanism to remove old audit entries.

Actual results:
Production Satellites accumulate large of Audit data which are not purged.

  1. time curl k -u admin https://satellite.example.com/api/audits > audit
    Enter host password for user 'admin':
    % Total % Received % Xferd Average Speed Time Time Time Current
    Dload Upload Total Spent Left Speed
    100 13950 0 13950 0 0 817 0 -
    :--:-- 0:00:17 --:--:-- 3534

real 0m19.485s
user 0m0.047s
sys 0m0.066s

  1. head audit {
    "total": 5136427,
    "subtotal": 5136427,
    "page": 1,
    "per_page": 30,
    "search": null,
    "sort": {
    "by": null,
    "order": null
    },

Expected results:
Need an automated purge mechanism for audits.

Additional info:


Related issues 2 (0 open2 closed)

Related to Foreman - Feature #22158: Add a rake task for audits cleanupClosedTomer Brisker01/04/2018Actions
Related to Packaging - Feature #33623: Add cron to audits cleanupClosedDominik MatoulekActions
Actions #1

Updated by Lukas Zapletal almost 5 years ago

Actions #2

Updated by Marek Hulán almost 5 years ago

The rake task is there, we should make it automatically executed, similar to how we clean up reports https://github.com/theforeman/foreman-packaging/blob/rpm/develop/packages/foreman/foreman/foreman.cron.d

Actions #3

Updated by Ondřej Ezr about 3 years ago

  • Subject changed from Satellite audits cleanup to Audits cleanup
Actions #4

Updated by Ondřej Ezr about 3 years ago

I do not agree we should run the cleanup automatically. Audits should stay forever unless user say otherwise.
Unless we name this Activity log.

Actions #5

Updated by Dominik Matoulek over 2 years ago

Actions #6

Updated by Dominik Matoulek over 2 years ago

  • Assignee set to Dominik Matoulek
Actions #7

Updated by The Foreman Bot over 2 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/8844 added
Actions #8

Updated by The Foreman Bot over 2 years ago

  • Fixed in Releases 3.1.0 added
Actions #9

Updated by Dominik Matoulek over 2 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF