Bug 1553772

Summary: [RFE] Move database maintenance to the application
Product: Red Hat CloudForms Management Engine Reporter: Jillian Tullo <jtullo>
Component: ApplianceAssignee: Gregg Tanzillo <gtanzill>
Status: CLOSED CURRENTRELEASE QA Contact: Tasos Papaioannou <tpapaioa>
Severity: medium Docs Contact:
Priority: medium    
Version: 5.9.0CC: abellott, cpelland, greartes, jan.hladik, obarenbo, simaishi, tpapaioa
Target Milestone: GAKeywords: FutureFeature, TestOnly, ZStream
Target Release: 5.10.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 5.10.0.0 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1553795 (view as bug list) Environment:
Last Closed: 2019-02-11 14:01:10 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: 1553795    

Description Jillian Tullo 2018-03-09 14:11:06 UTC 
Description of problem:
Database maintenance (vacuum, reindex) should live in the application and not on the appliance console.

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


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:
Comment 2 Satoe Imaishi 2018-03-09 14:55:32 UTC 
https://github.com/ManageIQ/manageiq/pull/16929
https://github.com/ManageIQ/manageiq/pull/16940
https://github.com/ManageIQ/manageiq-appliance/pull/180
Comment 5 Reartes Guillermo 2018-05-15 17:48:08 UTC 
Hi,

On CFME Version: 5.9.2.4 in AP there is this option: 

7) translation missing: en.advanced_settings.db_maintenance

If this is no longer needed, please remove such option from AP command menu.

RHBZ 1578419 was closed NOTABUG but the option was not removed, please make sure that if such option us no longer needed, it is removed for 5.9.x

Thanks in advance.
Comment 6 Tasos Papaioannou 2018-07-11 14:26:19 UTC 
Verified on 5.10.0.3.
Comment 7 Jan Hladik 2018-09-18 09:15:14 UTC 
CFME version 5.9.4.7

Menu #7 Database Maintenace is not in AP now

But there are still entries in cron.hourly.

So is needed to remove all these entries, because it is causing errors entries in root mails.

From root@server  Tue Sep 18 12:01:02 2018
Subject: Cron <root@server> run-parts /etc/cron.hourly
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
Precedence: bulk
X-Cron-Env: <XDG_SESSION_ID=1084>
X-Cron-Env: <XDG_RUNTIME_DIR=/run/user/0>
X-Cron-Env: <LANG=en_US.UTF-8>
X-Cron-Env: <SHELL=/bin/bash>
X-Cron-Env: <PATH=/sbin:/bin:/usr/sbin:/usr/bin>
X-Cron-Env: <MAILTO=root>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>
Message-Id: <20180918090102.5202BFF5B@server>
Date: Tue, 18 Sep 2018 12:01:01 +0300 (EEST)

/etc/cron.hourly/miq-pg-maintenance-hourly.cron:

/etc/cron.hourly/miq-pg-maintenance-hourly.cron: line 2: /usr/bin/hourly_reindex_metrics_tables: No such file or directory
/etc/cron.hourly/miq-pg-maintenance-hourly.cron: line 3: /usr/bin/hourly_reindex_miq_queue_table: No such file or directory
/etc/cron.hourly/miq-pg-maintenance-hourly.cron: line 4: /usr/bin/hourly_reindex_miq_workers_table: No such file or directory