Bug 1670202

Summary: The event_streams table does not get auto-vacuumed
Product: Red Hat CloudForms Management Engine Reporter: Satoe Imaishi <simaishi>
Component: ApplianceAssignee: Gregg Tanzillo <gtanzill>
Status: CLOSED ERRATA QA Contact: John Dupuy <jdupuy>
Severity: high Docs Contact: Red Hat CloudForms Documentation <cloudforms-docs>
Priority: unspecified    
Version: 5.9.7CC: abellott, obarenbo, smallamp
Target Milestone: GAKeywords: ZStream
Target Release: 5.9.8   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 5.9.8.1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1669541 Environment:
Last Closed: 2019-02-12 13:58:53 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:
Bug Depends On: 1669541    
Bug Blocks:    

Comment 2 Satoe Imaishi 2019-01-29 17:24:26 UTC
Note (from https://github.com/ManageIQ/manageiq/pull/18402#issuecomment-458310827):

"Is this is something we definitely need everyone to have we should write a migration to add it to the settings changes in case they have previously edited the list.

As it stands, if the list was edited this alone won't be enough. But I don't think it's all that common to edit this list of models."

Comment 3 John Dupuy 2019-01-30 18:13:37 UTC
Verified in 5.9.8.1.20190129182003_5fdf738

Steps for verification:
1) Navigate to advanced settings 
2) verified that the "EventStream" table appears under "vacuum_tables" in the advanced setting yaml

Comment 5 errata-xmlrpc 2019-02-12 13:58:53 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2019:0315

Comment 6 CFME Bot 2019-02-14 14:16:28 UTC
New commit detected on ManageIQ/manageiq/gaprindashvili:

https://github.com/ManageIQ/manageiq/commit/4cd962a3e2cc502b67f2b3bf7caafb1e4515d675
commit 4cd962a3e2cc502b67f2b3bf7caafb1e4515d675
Author:     Nick Carboni <ncarboni>
AuthorDate: Mon Jan 28 16:34:22 2019 -0500
Commit:     Nick Carboni <ncarboni>
CommitDate: Mon Jan 28 16:34:22 2019 -0500

    Merge pull request #18402 from gtanzillo/add-event_streams-to-autovacuum-list

    Adding event_streams to autovacuum list

    (cherry picked from commit c909edb411e169486a0f07dc7f993645e4048893)

    https://bugzilla.redhat.com/show_bug.cgi?id=1670202

 config/settings.yml | 1 +
 1 file changed, 1 insertion(+)