Bug 1553795

Summary:	[RFE] Move database maintenance to the application
Product:	Red Hat CloudForms Management Engine	Reporter:	Satoe Imaishi <simaishi>
Component:	Appliance	Assignee:	Gregg Tanzillo <gtanzill>
Status:	CLOSED ERRATA	QA Contact:	Tasos Papaioannou <tpapaioa>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	5.9.0	CC:	abellott, cpelland, fdewaley, gekis, ncarboni, obarenbo, simaishi, tpapaioa
Target Milestone:	GA	Keywords:	FutureFeature, ZStream
Target Release:	cfme-future
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	5.9.2.0	Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:	1553772	Environment:
Last Closed:	2018-07-12 13:14:16 UTC	Type:	---
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:	1553772
Bug Blocks:

Comment 2 CFME Bot 2018-03-09 15:01:09 UTC

New commits detected on ManageIQ/manageiq/gaprindashvili:

https://github.com/ManageIQ/manageiq/commit/f1c1203e5e8c70824b464f137183d52fb6544958
commit f1c1203e5e8c70824b464f137183d52fb6544958
Author:     Nick Carboni <ncarboni>
AuthorDate: Fri Feb  2 09:26:13 2018 -0500
Commit:     Nick Carboni <ncarboni>
CommitDate: Fri Feb  2 09:26:13 2018 -0500

    Merge pull request #16929 from jntullo/db_maintenance

    Add reindex to job scheduler
    (cherry picked from commit da512b21dc63f23324e1d05a10ee3b00ef693d73)

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

 app/models/metric.rb | 4 +
 app/models/miq_schedule_worker/jobs.rb | 6 +
 app/models/miq_schedule_worker/runner.rb | 7 +
 config/settings.yml | 6 +
 lib/extensions/ar_base.rb | 10 +
 spec/models/miq_schedule_worker/runner_spec.rb | 19 +-
 6 files changed, 50 insertions(+), 2 deletions(-)


https://github.com/ManageIQ/manageiq/commit/23bd29d183da6428b8c436181ce38453ba508429
commit 23bd29d183da6428b8c436181ce38453ba508429
Author:     Nick Carboni <ncarboni>
AuthorDate: Tue Feb  6 09:08:49 2018 -0500
Commit:     Nick Carboni <ncarboni>
CommitDate: Tue Feb  6 09:08:49 2018 -0500

    Merge pull request #16940 from jntullo/vacuum

    Add Vacuum to Job Scheduler
    (cherry picked from commit c2c05d5461cea5333e9f1dae8c9d6f4b54ced3ce)

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

 app/models/miq_schedule_worker/jobs.rb | 6 +
 app/models/miq_schedule_worker/runner.rb | 7 +
 config/settings.yml | 25 +
 lib/extensions/ar_base.rb | 10 +-
 spec/models/miq_schedule_worker/runner_spec.rb | 30 +-
 5 files changed, 72 insertions(+), 6 deletions(-)

Comment 3 CFME Bot 2018-03-09 15:07:15 UTC

New commit detected on ManageIQ/manageiq-appliance/gaprindashvili:

https://github.com/ManageIQ/manageiq-appliance/commit/f8ff339ac4fd51d461d03c267507e0ca242f434e
commit f8ff339ac4fd51d461d03c267507e0ca242f434e
Author:     Nick Carboni <ncarboni>
AuthorDate: Wed Feb 28 11:28:10 2018 -0500
Commit:     Nick Carboni <ncarboni>
CommitDate: Wed Feb 28 11:28:10 2018 -0500

    Merge pull request #180 from jntullo/remove_maintenance_scripts

    Remove reindex and vacuum scripts
    (cherry picked from commit 5289e1ea3041a7b30f211cdc8d96d97ef0c9b9f1)

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

 LINK/usr/bin/hourly_reindex_metrics_tables | 10 -
 LINK/usr/bin/hourly_reindex_miq_queue_table | 9 -
 LINK/usr/bin/hourly_reindex_miq_workers_table | 9 -
 LINK/usr/bin/periodic_vacuum_full_tables | 36 -
 4 files changed, 64 deletions(-)

Comment 5 CFME Bot 2018-03-27 21:44:41 UTC

https://github.com/ManageIQ/manageiq/pull/17214

Comment 6 Tasos Papaioannou 2018-05-23 18:06:42 UTC

Verified on 5.9.3.0.

Comment 8 errata-xmlrpc 2018-07-12 13:14:16 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-2018:2184