Bug 1382746

Summary:	Upgrade from 3.6 to 4.0 fails on 04_00_0140_convert_memory_snapshots_to_disks.sql
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Chris Henderson <chenders>
Component:	ovirt-engine	Assignee:	Arik <ahadas>
Status:	CLOSED NOTABUG	QA Contact:	sefi litmanovich <slitmano>
Severity:	high	Docs Contact:
Priority:	high
Version:	4.0.3	CC:	ahadas, amarchuk, chenders, dfediuck, gklein, lsurette, mavital, michal.skrivanek, oourfali, rbalakri, Rhev-m-bugs, sbonazzo, srevivo, ykaul
Target Milestone:	ovirt-4.1.0-alpha	Keywords:	ZStream
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1384770 1390254 (view as bug list)		Environment:
Last Closed:	2017-02-01 10:14:36 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:	1384770
Bug Blocks:	1390254

Description Chris Henderson 2016-10-07 14:57:35 UTC

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

Comment 2 Chris Henderson 2016-10-07 15:12:25 UTC

Upgrade is coming from rhevm-3.6.9.2-0.1.el6.noarch. This environment has only NFS storage domains, was initially installed at 3.0 and has gone through every minor release to get to 3.6.

Comment 3 Michal Skrivanek 2016-10-07 15:26:21 UTC

Arik, can you please check the logs?

Comment 4 Arik 2016-10-09 09:37:05 UTC

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.

Comment 5 Arik 2016-10-09 09:49:31 UTC

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 6 Oved Ourfali 2016-10-10 05:03:07 UTC

*** Bug 1382744 has been marked as a duplicate of this bug. ***

Comment 7 Chris Henderson 2016-10-10 15:07:12 UTC

Thanks Arik. The work-around worked for me.

Comment 8 Michal Skrivanek 2016-10-31 13:15:36 UTC

Why was this not moved to ON_QA? AFAIK it is in the build -4

Comment 9 Michal Skrivanek 2016-10-31 13:50:51 UTC

ah, sorry, it's the missing ack hence a missing clone. I wonder if we get the qa_ack ;-)

Comment 15 sefi litmanovich 2017-02-01 10:14:36 UTC

Ok, closing as NOTABUG as this scenario cannot in fact occur on upgrades between 4.0 -> 4.1 anyway.