Description of problem: The event_streams database table no longer gets auto-vacuumed since the vacuuming task was added to the Job Scheduler (https://github.com/ManageIQ/manageiq/pull/16940), whereas it used to be in the old database maintenance scripts. This is one of the larger tables and so could probably benefit from auto-vacuuming. Suggest it probably just needs adding to the advanced configuration yaml under: :database: :maintenance: :reindex_schedule: 1 * * * * :reindex_tables: - Metric - MiqQueue - MiqWorker :vacuum_schedule: 0 2 * * 6 :vacuum_tables: Version-Release number of selected component (if applicable): 5.9.7.2 How reproducible: Every time
New commit detected on ManageIQ/manageiq/hammer: https://github.com/ManageIQ/manageiq/commit/c6f868d50198db566b1c8454a7d418fbbe05b6a0 commit c6f868d50198db566b1c8454a7d418fbbe05b6a0 Author: Gregg Tanzillo <gtanzill> AuthorDate: Tue Jan 29 18:12:41 2019 -0500 Commit: Gregg Tanzillo <gtanzill> CommitDate: Tue Jan 29 18:12:41 2019 -0500 Adding event_streams to autovacuum list https://bugzilla.redhat.com/show_bug.cgi?id=1669541 config/settings.yml | 1 + 1 file changed, 1 insertion(+)
New commit detected on ManageIQ/manageiq/master: https://github.com/ManageIQ/manageiq/commit/e499a4c1ada5a1d32c6d661eda8de3c0e867f07d commit e499a4c1ada5a1d32c6d661eda8de3c0e867f07d Author: Gregg Tanzillo <gtanzill> AuthorDate: Mon Jan 28 14:21:24 2019 -0500 Commit: Gregg Tanzillo <gtanzill> CommitDate: Mon Jan 28 14:21:24 2019 -0500 Adding event_streams to autovacuum list https://bugzilla.redhat.com/show_bug.cgi?id=1669541 config/settings.yml | 1 + 1 file changed, 1 insertion(+)
Verified in 5.11.0.1.20190424210327_58b5dbd Steps of verification: 1) Navigate to advanced settings config 2) Verified that "EventStream" appears under ":vacuum_tables:"