Bug 1655482
| Summary: | [engine-setup] Engine schema refresh failed when upgrading from/through 4.2.5 to 4.3 | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Michael Burman <mburman> | ||||
| Component: | Database.Core | Assignee: | Eli Mesika <emesika> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Lucie Leistnerova <lleistne> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | urgent | ||||||
| Version: | 4.3.0 | CC: | bugs, derez, didi, mperina, ratamir | ||||
| Target Milestone: | ovirt-4.3.0 | Flags: | rule-engine:
ovirt-4.3+
rule-engine: blocker+ |
||||
| Target Release: | --- | ||||||
| Hardware: | x86_64 | ||||||
| OS: | Linux | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | ovirt-engine-4.3.0_rc | Doc Type: | If docs needed, set a value | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2019-02-13 07:45:02 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
Pushed a suggested fix to 4.3, let me know if makes sense: https://gerrit.ovirt.org/#/c/95946/ upgrade 4.2.6 -> 4.2.8 -> 4.3 was successful verified in ovirt-engine-4.3.0-0.8.rc2.el7.noarch 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. |
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.