Bug 1553772 - [RFE] Move database maintenance to the application
Summary: [RFE] Move database maintenance to the application
Keywords:
Status: CLOSED CURRENTRELEASE
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
: 5.10.0
Assignee: Gregg Tanzillo
QA Contact: Tasos Papaioannou
URL:
Whiteboard:
Depends On:
Blocks: 1553795
TreeView+ depends on / blocked
 
Reported: 2018-03-09 14:11 UTC by Jillian Tullo
Modified: 2019-02-11 14:01 UTC (History)
7 users (show)

Fixed In Version: 5.10.0.0
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1553795 (view as bug list)
Environment:
Last Closed: 2019-02-11 14:01:10 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

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


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