Bug 1655482 - [engine-setup] Engine schema refresh failed when upgrading from/through 4.2.5 to 4.3
Summary: [engine-setup] Engine schema refresh failed when upgrading from/through 4.2.5...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Database.Core
Version: 4.3.0
Hardware: x86_64
OS: Linux
urgent
high
Target Milestone: ovirt-4.3.0
: ---
Assignee: Eli Mesika
QA Contact: Lucie Leistnerova
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-12-03 09:36 UTC by Michael Burman
Modified: 2019-02-13 07:45 UTC (History)
5 users (show)

Fixed In Version: ovirt-engine-4.3.0_rc
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-02-13 07:45:02 UTC
oVirt Team: Infra
Embargoed:
rule-engine: ovirt-4.3+
rule-engine: blocker+


Attachments (Terms of Use)
logs (2.53 MB, application/x-gzip)
2018-12-03 09:36 UTC, Michael Burman
no flags Details


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 95931 0 master ABANDONED Do not merge: Revert "core: clean stale image_transfer on upgrade" 2020-05-26 01:45:25 UTC
oVirt gerrit 95946 0 master MERGED dbscripts: remove image_transfers FK if exists 2020-05-26 01:45:24 UTC

Description Michael Burman 2018-12-03 09:36:42 UTC
Created attachment 1510838 [details]
logs

Description of problem:
Failed to upgrade to 4.3 d/s build with:
[ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_03_0270_add_foreign_key_to_image_transfers.sql
[ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed

Version-Release number of selected component (if applicable):
4.3.0-0.5.alpha1.el7

How reproducible:
100%


Steps to Reproduce:
 Upgrade flows: 

1. 4.2.8 >> 4.3 - FAILED

1. Start point rhevm 4.0.7.5(rhel 7.4)
2. Upgraded directly to 4.2.5.2(rhel 7.6)
3. Upgrade to 4.2.6-1
4. Upgrade to 4.2.8
5. Upgrade to 4.3 - FAILED


Actual results:
engine-setup fail and engine is dead. Possible rollback wasn't successful.

Comment 1 Daniel Erez 2018-12-03 16:49:56 UTC
Pushed a suggested fix to 4.3, let me know if makes sense: https://gerrit.ovirt.org/#/c/95946/

Comment 2 Lucie Leistnerova 2019-01-23 11:19:34 UTC
upgrade 4.2.6 -> 4.2.8 -> 4.3 was successful

verified in ovirt-engine-4.3.0-0.8.rc2.el7.noarch

Comment 3 Sandro Bonazzola 2019-02-13 07:45:02 UTC
This bugzilla is included in oVirt 4.3.0 release, published on February 4th 2019.

Since the problem described in this bug report should be
resolved in oVirt 4.3.0 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.