Red Hat Bugzilla – Bug 1553795
[RFE] Move database maintenance to the application
Last modified: 2018-07-12 09:14:53 EDT
New commits detected on ManageIQ/manageiq/gaprindashvili: https://github.com/ManageIQ/manageiq/commit/f1c1203e5e8c70824b464f137183d52fb6544958 commit f1c1203e5e8c70824b464f137183d52fb6544958 Author: Nick Carboni <ncarboni@redhat.com> AuthorDate: Fri Feb 2 09:26:13 2018 -0500 Commit: Nick Carboni <ncarboni@redhat.com> 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@redhat.com> AuthorDate: Tue Feb 6 09:08:49 2018 -0500 Commit: Nick Carboni <ncarboni@redhat.com> 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(-)
New commit detected on ManageIQ/manageiq-appliance/gaprindashvili: https://github.com/ManageIQ/manageiq-appliance/commit/f8ff339ac4fd51d461d03c267507e0ca242f434e commit f8ff339ac4fd51d461d03c267507e0ca242f434e Author: Nick Carboni <ncarboni@redhat.com> AuthorDate: Wed Feb 28 11:28:10 2018 -0500 Commit: Nick Carboni <ncarboni@redhat.com> 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(-)
https://github.com/ManageIQ/manageiq/pull/17214
Verified on 5.9.3.0.
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