Bug 843495
| Summary: | [rhevm-update] Upgrade fails when dwh service is up | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Kiril Nesenko <knesenko> | ||||||
| Component: | ovirt-engine-setup | Assignee: | Kiril Nesenko <knesenko> | ||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | David Botzer <dbotzer> | ||||||
| Severity: | unspecified | Docs Contact: | |||||||
| Priority: | medium | ||||||||
| Version: | 3.1.0 | CC: | bazulay, dfediuck, dyasny, iheim, mgoldboi, pstehlik, Rhev-m-bugs, sgrinber, ykaul | ||||||
| Target Milestone: | --- | ||||||||
| Target Release: | --- | ||||||||
| Hardware: | x86_64 | ||||||||
| OS: | Linux | ||||||||
| Whiteboard: | integration | ||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2012-12-04 20:02:19 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: |
|
||||||||
Patch posted for review: http://gerrit.ovirt.org/#/c/7691/ Merged upstream: http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=c5f777a45a04a1231ab08f1ea501ee8e25a1f2bc Not Fixed, 3.1/si17 --> si18
1. I install si17 clean, with reports+dwh
2. I add in REPO the si18 url
3. I run yum update rhevm-setup & rhevm-upgrade
Backing Up Database... [ DONE ]
Rename Database... [ ERROR ]
Error: Database rename failed. Check that there are no active connections to the DB and try again.
Error: Upgrade failed.
Not Fixed, 3.1/si17 --> si18
See attached,
------------------------------------------
2012-09-19 08:01:30::ERROR::rhevm-upgrade::930::root:: Traceback (most recent call last):
File "/usr/bin/rhevm-upgrade", line 923, in <module>
main(options)
File "/usr/bin/rhevm-upgrade", line 834, in main
runFunc([[db.rename, DB_NAME_TEMP]], MSG_INFO_RENAME_DB)
File "/usr/bin/rhevm-upgrade", line 595, in runFunc
func[0](*func[1:])
File "/usr/bin/rhevm-upgrade", line 551, in rename
utils.execRemoteSqlCommand(SERVER_ADMIN, SERVER_NAME, SERVER_PORT, basedefs.DB_TEMPLATE, query, True, MSG_ERROR_RENAME_DB)
File "/usr/share/ovirt-engine/scripts/common_utils.py", line 365, in execRemoteSqlCommand
return execCmd(cmdList=cmd, failOnError=failOnError, msg=errMsg, envDict=env)
File "/usr/share/ovirt-engine/scripts/common_utils.py", line 339, in execCmd
raise Exception(msg)
Exception: Error: Database rename failed. Check that there are no active connections to the DB and try again.
Created attachment 614200 [details]
si17-si18
Why this bz moved to assigned ? The fix was to print a nice error message: Error: Database rename failed. Check that there are no active connections to the DB and try again. That what it does. David take a look on the patch fix. Hi Kiril, Thanks now I see, what the fix is, but why doesnt upgrade handles the open connections to the DB, If a user wants to upgrade, Why should they do it manually ? Waiting for ack on my replay and later on I will move it to verify. Fixed, 3.1/si18 User should stop the DWH manually. (If not solving the issue - User should restart postgresql service in order to close open connections.) Fixed, 3.1/si18 |
Created attachment 600505 [details] logs Description of problem: Upgrade fails when dwh service is up. There are live connection to the DB. Version-Release number of selected component (if applicable): si12 How reproducible: Steps to Reproduce: 1. Try to run rhevm-update when dwh service is up. 2. 3. Actual results: update fails due to DB connections Expected results: Additional info: