Created attachment 673304 [details] logs Description of problem: Running upgrade sql script upgrade/03_02_0030_drop_auto_suspend_column.sql ... 2013-01-06 11:41:11::DEBUG::common_utils::552::root:: stderr = psql:upgrade/03_02_0030_drop_auto_suspend_column.sql:1: ERROR: syntax error at or near "EXISTS" LINE 1: ALTER TABLE vm_configuration DROP COLUMN IF EXISTS auto_susp... ^ 2013-01-06 11:41:11::DEBUG::common_utils::553::root:: retcode = 3 2013-01-06 11:41:11::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.execCmd(cmdList=cmd, failOnError=True, msg="Error while trying to upgrade %s DB" % DB_NAME) File "/usr/share/ovirt-engine-dwh/common_utils.py", line 556, in execCmd raise Exception(msg) Exception: Error while trying to upgrade ovirt_engine_history DB 2013-01-06 11:41:11::ERROR::ovirt-engine-dwh-setup::267::root:: Exception caught! 2013-01-06 11:41:11::ERROR::ovirt-engine-dwh-setup::268::root:: Traceback (most recent call last): File "/usr/bin/ovirt-engine-dwh-setup", line 249, 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 Version-Release number of selected component (if applicable): rhevm-dwh-3.2.0-2.el6ev.noarch How reproducible: Always Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Eli seems like its related to the DB, can you take a look please ?
This was due to syntax in the upgrade not being compatible with 8.4. Fixed in patch: http://gerrit.ovirt.org/#/c/10677 Also re-based to downstream. Yaniv
Works for me with a new build.
Is it correct to test upgrade SF5 to SF6 ? and run rhevm-dwh-setup ?
(In reply to comment #8) > Is it correct to test upgrade SF5 to SF6 ? > and run rhevm-dwh-setup ? Yes
3.2/SF6 (upgraded from SF5) DWH works fine, aggreg for samples/hourly 3.2/SF6 (upgraded from SF5) Waiting for Daily to be verified
3.2/SF6 (upgraded from SF5) DWH works fine, aggreg for samples/hourly/daily 3.2/SF6 (upgraded from SF5)
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-2013-0926.html