Bug 906270
| Summary: | Upgrade from 3.1 shows error in DB upgrade | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | [Retired] oVirt | Reporter: | Alex Lourie <alourie> | ||||||||||
| Component: | ovirt-engine-installer | Assignee: | Alex Lourie <alourie> | ||||||||||
| Status: | CLOSED INSUFFICIENT_DATA | QA Contact: | |||||||||||
| Severity: | unspecified | Docs Contact: | |||||||||||
| Priority: | urgent | ||||||||||||
| Version: | 3.2 | CC: | acathrow, iheim, jkt, karli.sjoberg, mgoldboi, sbonazzo | ||||||||||
| Target Milestone: | --- | ||||||||||||
| Target Release: | --- | ||||||||||||
| Hardware: | Unspecified | ||||||||||||
| OS: | Unspecified | ||||||||||||
| Whiteboard: | integration | ||||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||||
| Doc Text: | Story Points: | --- | |||||||||||
| Clone Of: | Environment: | ||||||||||||
| Last Closed: | 2013-07-16 06:42:25 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: |
|
||||||||||||
Created attachment 691079 [details]
stdout of engine-upgrade
engine-upgrade asks about 8 times the db password after the rpms upgrade. here is what I can see in the console.
Sandro Please attach the content of the /etc/ovirt-engine/.pgpass file? Thanks. Here is the content of /etc/ovirt-engine/.pgpass. ##### oVirt-engine DB ADMIN settings section. Do not change!! localhost:5432:*:postgres:qum5net localhost:5432:engine:engine:qum5net ##### End of oVirt-engine DB ADMIN settings section. Hi Sandro Could you please try to reproduce the "password prompts" issue? If you can, please enter wrong password. I need to see where it fails. Thanks. Created attachment 693289 [details] output with a wrong password As requested in comment #5, I can reproduce the password prompt issue. I've used a wrong password after rpm update. Here is the output. Do you need to retry using wrong password on other successive prompt? Created attachment 693406 [details]
engine upgrade log with wrong password
Alex, what is the status of this bug? We are still working on the upgrade actions. Some configuration files need updating when upgrading from 3.1; that's a part way to solving this bug. @Karli Please update us on your progress. Thanks. closing on no feedback - please re-open if relevant |
Created attachment 690841 [details] upgrade log Description of problem: During the upgrade of the 3.1 installation on F17 to 3.2 on F18 there's a following error appears: engine_2013_01_30_21_30_41' 2013-01-30 21:33:54::DEBUG::common_utils::472::root:: output = /usr/share/ovirt-engine/dbscripts /usr/share/ovirt-engine/dbscripts upgrade script detected a change in Config, View or Stored Procedure... 2013-01-30 21:33:54::DEBUG::common_utils::473::root:: stderr = psql:drop_old_uuid_functions.sql:25: ERROR: cannot drop function uuid_nil() because extension uuid-ossp requires it HINT: You can drop extension uuid-ossp instead. CONTEXT: SQL statement "drop function if exists uuid_nil()" PL/pgSQL function __temp_drop_old_uuid_functions() line 10 at SQL statement psql:create_functions.sql:671: ERROR: must be owner of function uuid_generate_v1 2013-01-30 21:33:54::DEBUG::common_utils::474::root:: retcode = 3 2013-01-30 21:33:54::ERROR::engine-upgrade::1078::root:: Traceback (most recent call last): File "/bin/engine-upgrade", line 1065, in main runFunc([db.update], MSG_INFO_DB_UPDATE) File "/bin/engine-upgrade", line 594, in runFunc func() File "/bin/engine-upgrade", line 429, in update output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg=MSG_ERROR_UPDATE_DB) File "/usr/share/ovirt-engine/scripts/common_utils.py", line 477, in execCmd raise Exception(msg) Exception: Error: Database update failed