Bug 863757 - [RFE] [rhevm-dwh] - Cleanup Tool - Removing/Cleaning DWH installation
[RFE] [rhevm-dwh] - Cleanup Tool - Removing/Cleaning DWH installation
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh (Show other bugs)
Unspecified Linux
medium Severity medium
: ---
: 3.4.0
Assigned To: Sandro Bonazzola
Barak Dagan
: 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:
Last Closed: 2014-06-09 11:16:05 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
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):

How reproducible:

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

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 2013-10-28 11:00:03 EDT
You can use this kbase:

and the rpm uninstall clause to see the needed steps.

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





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.


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