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

Bug 844667

Summary: [rhevm-dwh] - Remote DB - DWH Setup fails to upgrade remote history DB
Product: Red Hat Enterprise Virtualization Manager Reporter: David Botzer <dbotzer>
Component: ovirt-engine-dwhAssignee: Alex Lourie <alourie>
Status: CLOSED CURRENTRELEASE QA Contact: David Botzer <dbotzer>
Severity: high Docs Contact:
Priority: high    
Version: 3.1.0CC: bazulay, dyasny, iheim, mkenneth, pstehlik, Rhev-m-bugs, sgrinber, ykaul, ylavi
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: SI15 - rhevm-dwh-3.1.0-9.el6ev.noarch.rpm Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-12-04 19:58:34 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
dwh-setup-Remote none

Description David Botzer 2012-07-31 10:35:14 UTC
Created attachment 601501 [details]
dwh-setup-Remote

Description of problem:
DWH Setup fails to upgrade remote history DB

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

How reproducible:
Always

Steps to Reproduce:
1.install rhevm+dwh and select remote db
2.run dwh-setup
  
Actual results:
Fails Upgrade DB...

* When i dropdb previous history db, and run dwh-setup it works

Expected results:
Should succeed

Additional info:
012-07-31 13:17:12::DEBUG::common_utils::169::root:: stderr = psql: could not connect to server: Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5432?
could not connect to server: Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5432?

2012-07-31 13:17:12::DEBUG::common_utils::170::root:: retcode = 2
2012-07-31 13:17:12::ERROR::decorators::27::root:: Traceback (most recent call last):
  File "/usr/share/ovirt-engine-dwh/decorators.py", line 20, in wrapped_f
    output = f(*args)
  File "/usr/bin/ovirt-engine-dwh-setup", line 98, in upgradeDB
    output, rc = utils.execExternalCmd(cmd, True, "Error while trying to upgrade ovirt_engine_history DB")
  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 173, in execExternalCmd
    raise Exception(msg)
Exception: Error while trying to upgrade ovirt_engine_history DB

2012-07-31 13:17:12::ERROR::ovirt-engine-dwh-setup::257::root:: Exception caught!
2012-07-31 13:17:12::ERROR::ovirt-engine-dwh-setup::258::root:: Traceback (most recent call last):
  File "/usr/bin/ovirt-engine-dwh-setup", line 241, in main
    upgradeDB(db_dict)
  File "/usr/share/ovirt-engine-dwh/decorators.py", line 28, in wrapped_f
    raise Exception(instance)
Exception: Error while trying to upgrade ovirt_engine_history DB

Comment 1 Yaniv Lavi 2012-08-06 11:08:33 UTC
*** Bug 842117 has been marked as a duplicate of this bug. ***

Comment 2 Alex Lourie 2012-08-16 10:47:32 UTC
Fix posted, http://gerrit.ovirt.org/#/c/7250

Comment 3 David Botzer 2012-08-30 06:40:23 UTC
Fixed, 3.1/si16
Remote history DB is upgraded successfully
also creates a new History DB if necessary
Fixed, 3.1/si16