Bug 1583562 - Failed to active host after upgrade (host was in PreparingForMaintenance before upgrade)
Summary: Failed to active host after upgrade (host was in PreparingForMaintenance befo...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Database.Core
Version: ---
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ovirt-4.2.4
: ---
Assignee: Eli Mesika
QA Contact: Pavol Brilla
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-05-29 09:08 UTC by Israel Pinto
Modified: 2019-04-28 09:19 UTC (History)
11 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-06-26 08:36:21 UTC
oVirt Team: Infra
rule-engine: ovirt-4.2+
rule-engine: blocker+

Attachments (Terms of Use)
engine log (475.14 KB, application/x-xz)
2018-05-29 09:10 UTC, Israel Pinto 		no flags Details
setup_logs (367.33 KB, application/x-xz)
2018-05-29 11:02 UTC, Israel Pinto 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1583664 0 unspecified CLOSED After update "provider_binding_host_id" table doesn't exist, hosts are stuck in Activating state 2021-02-22 00:41:40 UTC
oVirt gerrit 91874 0 ovirt-engine-4.2 MERGED core: Align db upgrade script names between 4.2.3.z and 4.2.4 2020-03-03 07:57:52 UTC

Internal Links: 1583664

Description Israel Pinto 2018-05-29 09:08:54 UTC 
Description of problem:
I set host to maintenance with running vm on it, the host did not succeeded since the BZ 1582483.
I upgrade to latest version and activate the host.
Host stuck in activating.

Version-Release number of selected component (if applicable):
4.2.3-6 to 4.2.4-1



Additional info:

Engine log:
2018-05-29 10:47:07,736+03 ERROR [org.ovirt.engine.core.vdsbroker.monitoring.HostMonitoring] (EE-ManagedThreadFactory-engineScheduled-Thread-40) [] Unable to RefreshCapabilities beforeFirstRefreshTreatment: PSQLException: ERROR: relation "provider_binding_host_id" does not exist
<ipinto_>   Where: PL/pgSQL function updatehostproviderbinding(uuid,character varying[],character varying[]) line 3 at PERFORM

W/A: 
Run again:
 /usr/share/ovirt-engine/dbscripts/upgrade/04_02_1090_add_host_provider_binding_ids.sql
Comment 1 Israel Pinto 2018-05-29 09:10:45 UTC 
Created attachment 1445271 [details]
engine log
Comment 2 Israel Pinto 2018-05-29 11:02:10 UTC 
Created attachment 1445337 [details]
setup_logs
Comment 3 Martin Perina 2018-05-30 11:58:58 UTC 
*** Bug 1583664 has been marked as a duplicate of this bug. ***
Comment 4 Lukas Svaty 2018-06-11 12:29:03 UTC 
Hi, can you provide reproduction steps, please?
Comment 5 Pavol Brilla 2018-06-12 12:37:29 UTC 
Upgrade 4.2.3.10 -> 4.2.4 skipped 04_02_1090_enlarge_custom_cpu_type.sql and ran newly installed scripts: 04_02_1100_add_host_provider_binding_ids, 04_02_1110_remove_test_imageio_connection_config_value.sql, 04_02_1120_add_confirmed_size_warning.sql ...
So the table provider_binding_host_id exists.

verified in ovirt-engine-setup-4.2.4.2-0.1.el7_3.noarch
Comment 6 Sandro Bonazzola 2018-06-26 08:36:21 UTC 
This bugzilla is included in oVirt 4.2.4 release, published on June 26th 2018.

Since the problem described in this bug report should be
resolved in oVirt 4.2.4 release, it has been closed with a resolution of CURRENT RELEASE.

If the solution does not work for you, please open a new bug report.
Note You need to log in before you can comment on or make changes to this bug.