Bug 1361939

Summary:	[RFE] Include a mechanism to perform VMDB reindexing and full vacuums as necessitate by each table
Product:	Red Hat CloudForms Management Engine	Reporter:	Thomas Hennessy <thenness>
Component:	Appliance	Assignee:	Joe Vlcek <jvlcek>
Status:	CLOSED ERRATA	QA Contact:	Alex Newman <anewman>
Severity:	high	Docs Contact:
Priority:	high
Version:	5.6.0	CC:	abellott, anewman, benglish, jdeubel, jhardy, jocarter, jvlcek, mfeifer, ncarboni, obarenbo, simaishi
Target Milestone:	GA	Keywords:	FutureFeature
Target Release:	5.7.0
Hardware:	x86_64
OS:	Linux
Whiteboard:	appliance:database
Fixed In Version:	5.7.0.1	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-01-04 12:58:42 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1382216

Description Thomas Hennessy 2016-08-01 02:01:52 UTC

Description of problem: no mechanism for VMDB table or index maintenance is provided in any release of cloudforms necessitating GSS to build and adpapt for each new release a set of scripts to perform continuous database maintenance to prevent the filesystem from filling when there is space available to be reclaimed and to  maintain CFME VMDB responsiveness.

This request is to implement something along the lines of what can be found via the article https://access.redhat.com/solutions/1419333 ("Continuous Maintenance for Cloudforms Management Engine VMDB to maintain Responsiveness ")


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


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 3 Nick Carboni 2016-08-22 17:23:37 UTC

These scripts were added to the appliance in https://github.com/ManageIQ/manageiq-appliance/pull/85

Adjusted for upstream use in https://github.com/ManageIQ/manageiq-appliance/pull/86

And there is currently work in progress to make a configuration option to enable them on the appliance.

Comment 4 Joe Vlcek 2016-09-13 21:24:40 UTC

This BZ is address by the following 2 commits:

https://github.com/ManageIQ/manageiq/pull/11122
https://github.com/ManageIQ/manageiq/commit/a6fcd1b302ab10a924e4f5bd0b1d0384514f7254

and

https://github.com/ManageIQ/manageiq/pull/10889
https://github.com/ManageIQ/manageiq/commit/a759b3d7c7b36b19f266d13cc01785a34529911e

Comment 6 errata-xmlrpc 2017-01-04 12:58:42 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://rhn.redhat.com/errata/RHBA-2017-0012.html