Bug 863757 - [RFE] [rhevm-dwh] - Cleanup Tool - Removing/Cleaning DWH installation
[RFE] [rhevm-dwh] - Cleanup Tool - Removing/Cleaning DWH installation
Status: CLOSED ERRATA
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh (Show other bugs)
3.1.0
Unspecified Linux
medium Severity medium
: ---
: 3.4.0
Assigned To: Sandro Bonazzola
Barak Dagan
integration
: FutureFeature, Reopened
Depends On:
Blocks: rhev3.4beta 1142926
  Show dependency treegraph
 
Reported: 2012-10-07 05:12 EDT by David Botzer
Modified: 2014-09-18 08:24 EDT (History)
10 users (show)

See Also:
Fixed In Version: ovirt-3.4.0-beta2
Doc Type: Enhancement
Doc Text:
A cleanup tool for removing/cleaning Data Warehouse installation is now available with the inclusion of OTOPI. Cleanup is available by running the 'engine-cleanup' command.
Story Points: ---
Clone Of:
Environment:
Last Closed: 2014-06-09 11:16:05 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---
dyasny: Triaged+


Attachments (Terms of Use)

  None (edit)
Description David Botzer 2012-10-07 05:12:07 EDT
Description of problem:
RFE Cleanup Tool - For Removing/Cleaning DWH installation

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

How reproducible:
Always

Steps to Reproduce:
1.Install rhevm+dwh+reports
2.Remove installation of (1)

  
Actual results:
User cannot be sure all DWH components were removed

Expected results:
Should remove all relevant DWH components

Additional info:
Comment 1 Dan Yasny 2013-02-07 06:35:12 EST
Requirements:

1. be able to remove only the reports/dwh leaving rhevm intact
2. be able to clean up the history db, so that it's clean, but reports remain operational and ETL start gathering data from this moment on
3. rhevm-cleanup should call this utility as well, so it will remove everything, and not just rhev-m


I suggest adding this functionality to rhevm-cleanup instead of writing a separate tool, but that's not necessary
Comment 3 RHEL Product and Program Management 2013-06-09 05:45:09 EDT
Development Management has reviewed and declined this request.
You may appeal this decision by reopening this request.
Comment 5 Yaniv Lavi (Dary) 2013-10-28 11:00:03 EDT
You can use this kbase:
https://access.redhat.com/site/solutions/291973

and the rpm uninstall clause to see the needed steps.


Yaniv
Comment 7 Sandro Bonazzola 2014-02-13 10:20:16 EST
Since we've otopi based setup, cleanup should now be available just running engine-cleanup.
Comment 8 Barak Dagan 2014-03-05 08:56:06 EST
Verified on av2

rhevm-dwh-3.4.0-0.4.master.20140224152332.el6ev.noarch
rhevm-dwh-setup-3.4.0-0.4.master.20140224152332.el6ev.noarch

rhevm-reports-3.4.0-0.4.master.20140226133324.el6ev.noarch
rhevm-reports-setup-3.4.0-0.4.master.20140226133324.el6ev.noarch

jasperreports-server-pro-5.5.0-7.el6ev.noarch

answerfile:
OVESETUP_REMOVE/confirmUninstallGroups=bool:True
OVESETUP_REMOVE/removeAll=bool:True
OVESETUP_REMOVE/database=bool:True
OVESETUP_REMOVE/enabledFileGroups=str:,ca_pki,versionlock,ca_config,core,ssl,versionlock,ovirt_reports_files,ovirt_dwh_files,core
OVESETUP_DWH_REMOVE/database=bool:True
OVESETUP_REPORTS_REMOVE/database=bool:True



bash-4.1$ psql -l
                                             List of databases
         Name         |        Owner         | Encoding |  Collation  |    Ctype    |   Access privileges   
----------------------+----------------------+----------+-------------+-------------+-----------------------
 engine               | engine               | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 ovirt_engine_history | ovirt_engine_history | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 ovirt_engine_reports | ovirt_engine_reports | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres             | postgres             | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0            | postgres             | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                                    : postgres=CTc/postgres
 template1            | postgres             | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                                    : postgres=CTc/postgres


bash-4.1$ psql -d engine -c '\d'
No relations found.
bash-4.1$ psql -d ovirt_engine_history -c '\d'
No relations found.
bash-4.1$ psql -d ovirt_engine_reports -c '\d'
No relations found.
Comment 9 errata-xmlrpc 2014-06-09 11:16:05 EDT
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.

http://rhn.redhat.com/errata/RHEA-2014-0601.html

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