Bug 1384770

Summary:	Upgrade from 3.6 to 4.0 fails on 04_00_0140_convert_memory_snapshots_to_disks.sql
Product:	[oVirt] ovirt-engine	Reporter:	Michal Skrivanek <michal.skrivanek>
Component:	General	Assignee:	Marek Libra <mlibra>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Lukas Svaty <lsvaty>
Severity:	high	Docs Contact:
Priority:	high
Version:	4.0.4	CC:	ahadas, bugs, chenders, dfediuck, gklein, lleistne, lsurette, lsvaty, mavital, michal.skrivanek, oourfali, rbalakri, Rhev-m-bugs, sbonazzo, srevivo, ykaul
Target Milestone:	ovirt-4.0.5	Flags:	michal.skrivanek: ovirt-4.0.z? rule-engine: planning_ack? michal.skrivanek: devel_ack+ pnovotny: testing_ack+
Target Release:	4.0.5.2
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	1382746	Environment:
Last Closed:	2017-01-18 07:37:02 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Virt	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Bug Depends On:
Bug Blocks:	1382746

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