Bug 1384770 - Upgrade from 3.6 to 4.0 fails on 04_00_0140_convert_memory_snapshots_to_disks.sql
Summary: Upgrade from 3.6 to 4.0 fails on 04_00_0140_convert_memory_snapshots_to_disks...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: General
Version: 4.0.4
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ovirt-4.0.5
: 4.0.5.2
Assignee: Marek Libra
QA Contact: Lukas Svaty
URL:
Whiteboard:
Depends On:
Blocks: 1382746
TreeView+ depends on / blocked
 
Reported: 2016-10-14 06:24 UTC by Michal Skrivanek
Modified: 2017-01-18 07:37 UTC (History)
16 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of: 1382746
Environment:
Last Closed: 2017-01-18 07:37:02 UTC
oVirt Team: Virt
Embargoed:
michal.skrivanek: ovirt-4.0.z?
rule-engine: planning_ack?
michal.skrivanek: devel_ack+
pnovotny: testing_ack+


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 65440 0 None None None 2016-10-14 06:24:09 UTC
oVirt gerrit 65453 0 None None None 2016-10-18 10:15:39 UTC
oVirt gerrit 65454 0 ovirt-engine-4.0.5 MERGED core: convert memory volumes only on active snapshots to disks properly 2016-10-18 09:44:02 UTC

Description Michal Skrivanek 2016-10-14 06:24:09 UTC
cloning to oVirt to bypass the annoying process

+++ This bug was initially created as a clone of Bug #1382746 +++

Description of problem:

Tried to upgrade from latest 3.6 release to latest 4.0 release. Database dump imports without error, but engine-setup fails.

[ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_00_0140_convert_memory_snapshots_to_disks.sql
[ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed


Version-Release number of selected component ):
ovirt-engine-setup-base-4.0.4.4-0.1.el7ev.noarch
ovirt-engine-dbscripts-4.0.4.4-0.1.el7ev.noarch

--- Additional comment from Arik on 2016-10-09 11:37:05 CEST ---

Yep, there's a bug when active snapshots contain memory during the upgrade to 4.0.

Chris, if you want to upgrade without waiting for a fix then the problematic VM is 'rhel6-test1', you can simply start and stop it and then do the upgrade.

--- Additional comment from Arik on 2016-10-09 11:49:31 CEST ---

steps to reproduce:
1. create snapshot with memory in 3.6
2. shutdown the VM
3. preview the snapshot
4. commit to the snapshot
5. remove the snapshot (optional step, that is just to better simulate the state that is reported in this bug).
6. upgrade to 4.0

Comment 1 Lukas Svaty 2016-10-27 09:55:16 UTC
verified in ovirt-engine-4.0.5.2-0.2.el7ev.noarch
used reproduction steps from Description and multiple snapshots


Note You need to log in before you can comment on or make changes to this bug.