Bug 1045846
Summary: | [DWH-SETUP] - installation failed using remote db configuration, as installer tries to upgrade | ||||||
---|---|---|---|---|---|---|---|
Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Barak Dagan <bdagan> | ||||
Component: | ovirt-engine-dwh | Assignee: | Yedidyah Bar David <didi> | ||||
Status: | CLOSED ERRATA | QA Contact: | Jiri Belka <jbelka> | ||||
Severity: | urgent | Docs Contact: | |||||
Priority: | unspecified | ||||||
Version: | 3.3.0 | CC: | acathrow, alonbl, bdagan, didi, eedri, iheim, jbelka, pstehlik, Rhev-m-bugs, srevivo, yeylon, ylavi | ||||
Target Milestone: | --- | Keywords: | Reopened, Triaged | ||||
Target Release: | 3.3.0 | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | integration | ||||||
Fixed In Version: | IS30 - rhevm-dwh-3.3.0-27.el6ev.src.rpm | Doc Type: | Known Issue | ||||
Doc Text: |
Previously, a clean install with a remote database, wrongly behaved as an upgrade and failed. Now it correctly does a clean install.
|
Story Points: | --- | ||||
Clone Of: | Environment: | ||||||
Last Closed: | 2014-01-21 15:05:18 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: | |||||||
Bug Depends On: | |||||||
Bug Blocks: | 1026947, 1039946, 1043951, 1043957, 1056111 | ||||||
Attachments: |
|
who is the db owner? Yaniv Also is this clean install? Actually I'm not able to reproduce, on my system is filing in another point: 2013-12-23 13:32:37::ERROR::rhevm-dwh-setup::629::root:: Traceback (most recent call last): File "/usr/bin/rhevm-dwh-setup", line 481, in main dbExists, owned = getDBStatus(db_dict, PGPASS_TEMP) File "/usr/bin/rhevm-dwh-setup", line 308, in getDBStatus exists, owned = utils.dbExists(dbdict, TEMP_PGPASS) File "/usr/share/ovirt-engine-dwh/common_utils.py", line 648, in dbExists if rc == 0: UnboundLocalError: local variable 'rc' referenced before assignment (In reply to Sandro Bonazzola from comment #3) > Actually I'm not able to reproduce, on my system is filing in another point: > > 2013-12-23 13:32:37::ERROR::rhevm-dwh-setup::629::root:: Traceback (most > recent call last): > File "/usr/bin/rhevm-dwh-setup", line 481, in main > dbExists, owned = getDBStatus(db_dict, PGPASS_TEMP) > File "/usr/bin/rhevm-dwh-setup", line 308, in getDBStatus > exists, owned = utils.dbExists(dbdict, TEMP_PGPASS) > File "/usr/share/ovirt-engine-dwh/common_utils.py", line 648, in dbExists > if rc == 0: > UnboundLocalError: local variable 'rc' referenced before assignment this is unrelated to this bug. it's exploited by using non english locale. Opened a separate bug. You can not use engine as db owner in 3.3 clean install of dwh and reports. Yaniv 1) db owner is: remoteuser. create database ovirt_engine_history template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner remoteuser; 2) As can be seen from comment 1 line 4, it was on clean install. 3) engine user will not work, maybe engine_history, in that case the instructions (which are missing in this case - as it is an upgrade flow instead of installation) should be changed and require a specific user (which will fail in the field, imho). fail is32.1: - rhevm-dwh-setup when executed on clean install for first time and doing remote install still "thinks" it is doing upgrade... -%- # 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 ] Remote installation is selected. Remote installation selected. Make sure that DBA creates a user and the database in the following fashion: create role <role> with login encrypted password <password>; create database ovirt_engine_history template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner <role>; Provide a remote DB user: : [engine_history]remote_engine_history Please choose a password for the db user: Warning: Weak Password. Re-type password: Could not connect to remote database - please try again. ^^^^^^^^^^^ - ignore, i created remote db under different name (corrected later) Remote installation selected. Make sure that DBA creates a user and the database in the following fashion: create role <role> with login encrypted password <password>; create database ovirt_engine_history template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner <role>; Provide a remote DB user: : [remote_engine_history] Please choose a password for the db user: Warning: Weak Password. Re-type password: Existing DB was found on the system. The size of the detected DB is 5 MB, free space in the backup folder /var/lib/ovirt-engine/backups is approximately 12.0 GB. ^^^^^^^^^^^ - of course! rhevm-dwh-setup tells me to create it (see above for instructions for DBA) The upgrade utility can backup the existing database. The time and space required for the database backup depend on its size. The detected DB size is 5 MB. This process takes time, and in some cases (for instance, when the size is few GBs) may take few hours to complete. Would you like to continue and backup the existing database? Answering "no" will skip the backup step and continue the upgrade without backing up the database (yes|no): -%- It should not talk about any upgrade at all if I'm doing clean remote install. The BZ is about failure, not about 'upgrade' info in output. is32.2 it passed OK. Existing DB was found on the system. The size of the detected DB is 5 MB, free space in the backup folder /var/lib/ovirt-engine/backups is approximately 12.0 GB. The upgrade utility can backup the existing database. The time and space required for the database backup depend on its size. The detected DB size is 5 MB. This process takes time, and in some cases (for instance, when the size is few GBs) may take few hours to complete. Would you like to continue and backup the existing database? Answering "no" will skip the backup step and continue the upgrade without backing up the database (yes|no): yes Are you sure you would like to continue and backup database ovirt_engine_history? Answering "no" will stop the upgrade (yes|no): yes Backing up the DB... [ DONE ] The DB was backed up as '/var/lib/ovirt-engine/backups/ovirt-engine-history.backup.2014_01_16_14_25_29' The DB backup was created with compression. You must use "pg_restore" command if you need to recover the DB from the backup. Creating DB... [ DONE ] Setting DB connectivity... [ DONE ] Starting ovirt-engine... [ DONE ] Starting oVirt-ETL... [ DONE ] Successfully installed rhevm-dwh. The installation log file is available at: /var/log/ovirt-engine/rhevm-dwh-setup-2014_01_16_14_16_12.log 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/RHBA-2014-0036.html |
Created attachment 840347 [details] installation log + Default.properties before and after running the setup Description of problem: on clean remote installation: 1) Setup refers to the installation as upgrade:# rhevm-dwh-setupWelcome to ovirt-engine-dwh setup utilityIn order to proceed the installer must stop the ovirt-engine serviceWould you like to stop the ovirt-engine service (yes|no): yesStopping ovirt-engine... [ DONE ]Existing DB was found on the system. ...The upgrade utility can backup the existing database....Backing up the DB... [ DONE ]Upgrade DB... [ ERROR ]Error encountered while installing rhevm-dwh, please consult the log file: /var/log/ovirt-engine/rhevm-dwh-setup-2013_12_22_15_42_11.log2) As credentials were not asked, in log it tried to connect with some default user: 2013-12-22 15:42:16::DEBUG::common_utils::917::root:: stderr = psql: FATAL: password authentication failed for user "engine_history" Version-Release number of selected component (if applicable): is28.1 (rhevm-dwh-3.3.0-26.el6ev.noarch, rhevm-reports-3.3.0-27.el6ev.noarch) How reproducible: 100% (4 out of 4 tries) Steps to Reproduce: 1. On clean rhel 6.5 install is28.1 engine 2. yum install -y rhevm-dwh rhevm-reports 3. rhevm-dwh-setup Actual results: installation failes Expected results: Additional info: