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...
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Database.Core
Version: ---
Hardware: Unspecified
OS: Unspecified
Target Milestone: ovirt-4.2.4
: ---
Assignee: Eli Mesika
QA Contact: Pavol Brilla
Depends On:
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:
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

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

Run again:

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]

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.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-

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.