Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1053225

Summary: "rhevm-dwh-setup" command fails after upgrading the reports packages from RHEV 3.2 to RHEV 3.3
Product: Red Hat Enterprise Virtualization Manager Reporter: Narmadha K <narmadha.k>
Component: ovirt-engine-dwhAssignee: Yaniv Lavi <ylavi>
Status: CLOSED CURRENTRELEASE QA Contact: Barak Dagan <bdagan>
Severity: high Docs Contact:
Priority: unspecified    
Version: 3.3.0CC: acathrow, gklein, iheim, pstehlik, Rhev-m-bugs, yeylon
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-01-14 21:58:53 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:
Attachments:
Description Flags
Log file
none
Log file none

Description Narmadha K 2014-01-14 21:38:26 UTC
Created attachment 850216 [details]
Log file

Description of problem:After upgrading the reports packages from RHEV 3.2 to RHEV 3.3 and upon executing "rhevm-dwh-setup", the command fails with installation error. 


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

How reproducible:


Steps to Reproduce:
1. Install RHEV 3.2 including the reports packages.
2. Upgrade RHEV 3.2 to RHEV 3.3 including the reports packages.
3. Execute rhevm-dwh-setup and notice the installation error.

Actual results:
root@ovirt-dev1 /]# rhevm-dwh-setup
Welcome to ovirt-engine-dwh setup utility

In order to proceed the installer must stop the ovirt-engine service
Would you like to stop the ovirt-engine service (yes|no): yes
Stopping ovirt-engine...                              [ DONE ]

This utility can configure a read only user for DB access. Would you like to do so? (yes|no): no
Skipping creation of read only DB user.
Error encountered while installing rhevm-dwh, please consult the log file: /var/log/ovirt-engine/rhevm-dwh-setup-2014_01_09_07_41_03.log

*******************************************************************

Following was tried by providing "yes" as response,
---------------------------------------------------

root@ovirt-dev1 /]# rhevm-dwh-setup
Welcome to ovirt-engine-dwh setup utility


This utility can configure a read only user for DB access. Would you like to do so? (yes|no): yes
Error: user name cannot be empty
Provide a username for read-only user : test
Provide a password for read-only user:
Warning: Weak Password.
Re-type password:
Should postgresql be setup with secure connection? (yes|no): yes
Error encountered while installing rhevm-dwh, please consult the log file: /var/log/ovirt-engine/rhevm-dwh-setup-2014_01_10_02_56_10.log

Following is the error message from log file: 
2014-01-09 07:41:21::DEBUG::common_utils::917::root:: stderr = 
2014-01-09 07:41:21::DEBUG::common_utils::918::root:: retcode = 0
2014-01-09 07:41:21::DEBUG::common_utils::719::root:: Found IP Address: 172.30.60.21
2014-01-09 07:41:21::DEBUG::common_utils::1115::root:: Adding user engine
2014-01-09 07:41:21::DEBUG::common_utils::874::root:: Executing command --> '/bin/su -l postgres -c /usr/bin/psql -U postgres -c "CREATE ROLE engine with createdb login encrypted password 'compaq123';"' in working directory '/'
2014-01-09 07:41:21::DEBUG::common_utils::916::root:: output = 
2014-01-09 07:41:21::DEBUG::common_utils::917::root:: stderr = ERROR:  role "engine" already exists

2014-01-09 07:41:21::DEBUG::common_utils::918::root:: retcode = 1
2014-01-09 07:41:21::ERROR::rhevm-dwh-setup::628::root:: Exception caught!
2014-01-09 07:41:21::ERROR::rhevm-dwh-setup::629::root:: Traceback (most recent call last):
  File "/usr/bin/rhevm-dwh-setup", line 489, in main
    validate=False,
  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 1153, in createUser
    failOnError=True
  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 921, in execCmd
    raise Exception(msg)
Exception: Return Code is not zero



Expected results:
Installation must succeed without errors.

Additional info:
This issue is seen only when in an upgrade scenario. On a fresh install of RHEV3.3, there are no issues.

Comment 1 Narmadha K 2014-01-14 21:39:40 UTC
Created attachment 850217 [details]
Log file

Comment 2 Yaniv Lavi 2014-01-14 21:58:53 UTC
There were many issues fixed between RC and the GA versions. Please use the GA version to upgrade the environments, it should work as expected. 



Yaniv