Bug 1445803
| Summary: | Restore to global region fails due to connection to database | ||
|---|---|---|---|
| Product: | Red Hat CloudForms Management Engine | Reporter: | Satoe Imaishi <simaishi> |
| Component: | Appliance | Assignee: | Gregg Tanzillo <gtanzill> |
| Status: | CLOSED ERRATA | QA Contact: | luke couzens <lcouzens> |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 5.8.0 | CC: | abellott, cpelland, dajohnso, gtanzill, jhardy, ncarboni, obarenbo |
| Target Milestone: | GA | Keywords: | Regression |
| Target Release: | 5.8.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | black:replication | ||
| Fixed In Version: | 5.8.0.14 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | 1444993 | Environment: | |
| Last Closed: | 2017-05-31 15:01:21 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | CFME Core | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | 1444993 | ||
| Bug Blocks: | |||
|
Comment 2
CFME Bot
2017-04-26 21:07:53 UTC
I am still seeing the same behavior in 5.8.0.13, when running the restore through appliance console I still see: Are you sure you would like to restore the database? (Y/N): y Restoring the database... Database restore failed There are 1 connection preventing a database restore Press any key to continue. New commit detected on ManageIQ/manageiq-gems-pending/master: https://github.com/ManageIQ/manageiq-gems-pending/commit/6f17bbf10fa1e92e487c8e7c8d08915144a471da commit 6f17bbf10fa1e92e487c8e7c8d08915144a471da Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 14:46:44 2017 -0400 Commit: Gregg Tanzillo <gtanzill> CommitDate: Thu May 4 12:01:02 2017 -0400 Fix typo dropping pglogical extension https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 lib/gems/pending/util/postgres_admin.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commit detected on ManageIQ/manageiq-gems-pending/master: https://github.com/ManageIQ/manageiq-gems-pending/commit/cdb3b1355349387cc0b41fe54477d4e620666199 commit cdb3b1355349387cc0b41fe54477d4e620666199 Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 14:52:22 2017 -0400 Commit: Gregg Tanzillo <gtanzill> CommitDate: Thu May 4 12:01:25 2017 -0400 Wait for "pglogical manager" db connection to go away before allowing pg_restore to proceed https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 lib/gems/pending/util/postgres_admin.rb | 15 +++++++++++++++ 1 file changed, 15 insertions(+) New commit detected on ManageIQ/manageiq-gems-pending/master: https://github.com/ManageIQ/manageiq-gems-pending/commit/d8263c8d1ec86fffefb9ddf4397ff1793b29848b commit d8263c8d1ec86fffefb9ddf4397ff1793b29848b Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 14:51:00 2017 -0400 Commit: Gregg Tanzillo <gtanzill> CommitDate: Thu May 4 12:01:20 2017 -0400 Move logic for dropping pglogical extension to a separate method https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 lib/gems/pending/util/postgres_admin.rb | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) New commit detected on ManageIQ/manageiq-gems-pending/fine: https://github.com/ManageIQ/manageiq-gems-pending/commit/b3dd664074a840a7d4fab1467091cc3305278937 commit b3dd664074a840a7d4fab1467091cc3305278937 Author: Joe Rafaniello <jrafanie.github.com> AuthorDate: Thu May 4 15:39:07 2017 -0400 Commit: Satoe Imaishi <simaishi> CommitDate: Thu May 4 15:58:57 2017 -0400 Merge pull request #149 from gtanzillo/quiesce-pglogical-manager-connection Quiesce pglogical manager DB connection before allowing pg_restore to proceed (cherry picked from commit 5ea4214b6287b3307d4fe6ff93eed835f6d57612) https://bugzilla.redhat.com/show_bug.cgi?id=1445803 lib/gems/pending/util/postgres_admin.rb | 27 ++++++++++++++++++++++++--- 1 file changed, 24 insertions(+), 3 deletions(-) Verified in 5.8.0.14 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. https://access.redhat.com/errata/RHSA-2017:1367 New commit detected on ManageIQ/manageiq-appliance_console/master: https://github.com/ManageIQ/manageiq-appliance_console/commit/98701fbc84181a52c643428cf102f4480739a2f1 commit 98701fbc84181a52c643428cf102f4480739a2f1 Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 18:46:44 2017 +0000 Commit: Nick LaMuro <nicklamuro> CommitDate: Tue Mar 16 19:25:16 2021 +0000 Fix typo dropping pglogical extension https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 (transferred from ManageIQ/manageiq-gems-pending@6f17bbf10fa1e92e487c8e7c8d08915144a471da) lib/manageiq/appliance_console/postgres_admin.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) https://github.com/ManageIQ/manageiq-appliance_console/commit/ef6e1a378d9fd8bab438434bfcae5ab73376391c commit ef6e1a378d9fd8bab438434bfcae5ab73376391c Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 18:51:00 2017 +0000 Commit: Nick LaMuro <nicklamuro> CommitDate: Tue Mar 16 19:25:16 2021 +0000 Move logic for dropping pglogical extension to a separate method https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 (transferred from ManageIQ/manageiq-gems-pending@d8263c8d1ec86fffefb9ddf4397ff1793b29848b) lib/manageiq/appliance_console/postgres_admin.rb | 10 +- 1 file changed, 8 insertions(+), 2 deletions(-) https://github.com/ManageIQ/manageiq-appliance_console/commit/1d7e9243af30bfba1f7a469491287af831934abb commit 1d7e9243af30bfba1f7a469491287af831934abb Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 18:52:22 2017 +0000 Commit: Nick LaMuro <nicklamuro> CommitDate: Tue Mar 16 19:25:16 2021 +0000 Wait for "pglogical manager" db connection to go away before allowing pg_restore to proceed https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 (transferred from ManageIQ/manageiq-gems-pending@cdb3b1355349387cc0b41fe54477d4e620666199) lib/manageiq/appliance_console/postgres_admin.rb | 15 + 1 file changed, 15 insertions(+) |