Bug 1553795 - [RFE] Move database maintenance to the application
Summary: [RFE] Move database maintenance to the application
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Appliance
Version: 5.9.0
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: GA
: cfme-future
Assignee: Gregg Tanzillo
QA Contact: Tasos Papaioannou
URL:
Whiteboard:
Depends On: 1553772
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-03-09 14:55 UTC by Satoe Imaishi
Modified: 2022-07-09 09:52 UTC (History)
8 users (show)

Fixed In Version: 5.9.2.0
Doc Type: Enhancement
Doc Text:
Clone Of: 1553772
Environment:
Last Closed: 2018-07-12 13:14:16 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2018:2184 0 None None None 2018-07-12 13:14:52 UTC

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 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


Note You need to log in before you can comment on or make changes to this bug.