Bug 1512840
Summary: | Reset DB configuration is failing | ||||||
---|---|---|---|---|---|---|---|
Product: | Red Hat CloudForms Management Engine | Reporter: | Ilanit Stein <istein> | ||||
Component: | Appliance | Assignee: | Gregg Tanzillo <gtanzill> | ||||
Status: | CLOSED CURRENTRELEASE | QA Contact: | luke couzens <lcouzens> | ||||
Severity: | high | Docs Contact: | |||||
Priority: | medium | ||||||
Version: | 5.9.0 | CC: | abellott, dagur, dajohnso, gtanzill, istein, jhardy, obarenbo, simaishi, smallamp, yrudman | ||||
Target Milestone: | GA | Keywords: | TestOnly | ||||
Target Release: | 5.10.0 | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | black | ||||||
Fixed In Version: | 5.10.0.0 | Doc Type: | If docs needed, set a value | ||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | |||||||
: | 1526108 (view as bug list) | Environment: | |||||
Last Closed: | 2019-02-11 13:53:40 UTC | Type: | Bug | ||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | Bug | |||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | CFME Core | Target Upstream Version: | |||||
Embargoed: | |||||||
Bug Depends On: | |||||||
Bug Blocks: | 1526108 | ||||||
Attachments: |
|
Description
Ilanit Stein
2017-11-14 09:21:05 UTC
Can you be more specific about the steps to reproduce and provide logs/screenshots (if applicable)? Have a CFME-5.9.0.4, connected to RHV-4.1 provider. Run the following commands: $ appliance_console, 5)Configure Database 4)Reset Configured Database Enter database region number:-> Enter the region number that was entered when DB was configured Getting in response: Checking for connections to the database... Warning: There are 19 existing connections to the database preventing the setup of a database region. Press any key to continue. (Screenshot attached) * Couldn't find any relevant log, that document this failure. Created attachment 1351909 [details]
reset_DB_screenshot
Execute "15) Stop EVM Server Processes" from appliance_console first - it should close open connections to DB. Yuri, Thanks a lot for the tip! Just tried it on CFME-5.8.2.3, and was able to Reset the configured DB. I am aware of at least 4 people, that met this problem, recently, but weren't aware to this solution. IMO, If we could have this tip displayed, when trying to reset the configured DB, aside to the "Warning: There are 19 existing connections...", it would be very helpful. What do you think, can we add it please? btw, do you know if this flow is documented in the CFME docs? Found another related problem. After running reset configured DB successfully. I then tried to run Configure the Database, and I chose same region number that was set, before the reset. The Configure Database failed as follows: Activating the configuration using the following settings... Host: localhost Username: root Database: vmdb_production Region: 0 An internal database already exists. Choose "Reset Internal Database" to reset the existing installation Configuration failed Press any key to continue. Yuri, Can you please advise? In continue to comment 7, Running 16) Start EVM Server Processes, allowed to connect to the UI, without Configuring the Database, as mentioned above, as it failed. Ilanit, I guess taht last sentence "Configuration failed" slightly confusing and may be need to be deleted since there is no any changes made to existing configuration. (In reply to Yuri Rudman from comment #9) > Ilanit, I guess taht last sentence "Configuration failed" slightly > confusing and may be need to be deleted since there is no any changes made > to existing configuration. This and good hint for reset external db is not difficult to fix. But for internal one in Comment 7, is that by intention? Thanks Bo, the best fix for Comment 7 is to find-out that internal DB already exists and show appropriate message without asking many question (user, password, etc..) and after that saying sorry, db already exists New commit detected on ManageIQ/manageiq-appliance_console/master: https://github.com/ManageIQ/manageiq-appliance_console/commit/bbfd3a8c3520df1811f305572344cd9e96bf0aa0 commit bbfd3a8c3520df1811f305572344cd9e96bf0aa0 Author: Bo Yao <icerove> AuthorDate: Wed Nov 15 09:55:02 2017 -0500 Commit: Bo Yao <icerove> CommitDate: Fri Nov 17 08:58:24 2017 -0500 hint for reset db with appliances connected https://bugzilla.redhat.com/show_bug.cgi?id=1512840 lib/manageiq/appliance_console/database_configuration.rb | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) PR to bump manageiq-appliance_console version: https://github.com/ManageIQ/manageiq-appliance/pull/163 Verified in 5.10 |