Bug 1733641

Summary: [RFE] Add purging of compliances
Product: Red Hat CloudForms Management Engine Reporter: Joe Rafaniello <jrafanie>
Component: ApplianceAssignee: drew uhlmann <duhlmann>
Status: CLOSED NOTABUG QA Contact: Jaroslav Henner <jhenner>
Severity: medium Docs Contact: Red Hat CloudForms Documentation <cloudforms-docs>
Priority: high    
Version: 5.9.0CC: abellott, dmetzger, jfrey, jhenner, jocarter, lavenel, obarenbo, yrudman
Target Milestone: GAKeywords: TestOnly, ZStream
Target Release: 5.12.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1767808 (view as bug list) Environment:
Last Closed: 2020-03-20 15:39:42 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: Feature
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1767808    

Description Joe Rafaniello 2019-07-26 21:15:35 UTC
Description of problem:
Compliance records aren't being purged.

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


How reproducible:
Very

Steps to Reproduce:
1. Customers have reported this table growing large, > 1.6 Million
2. Records > the the normal purge window size are not being removed on a schedule
3.

Actual results:
Compliances are not purged

Expected results:
Compliances are purged

Additional info:

Comment 3 Jason Frey 2019-07-26 21:46:53 UTC
See also BZ1648412 and https://github.com/ManageIQ/manageiq-ui-classic/pull/5283

Comment 4 drew uhlmann 2019-09-04 16:08:23 UTC
Cool, so Yuri mentioned this needs to be scheduled, so I need input from someone about how often this tool for purging compliances should run, and how old the compliances can be before we delete them.

Comment 5 drew uhlmann 2019-09-06 12:33:22 UTC
https://github.com/ManageIQ/manageiq/pull/19264

Comment 7 drew uhlmann 2019-09-10 18:56:07 UTC
So the current settings match what we have for drift state purging: once a day, we delete all records are older than six months, and the purge window size is 10000.