Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

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-engineAssignee: Arik <ahadas>
Status: CLOSED NOTABUG QA Contact: sefi litmanovich <slitmano>
Severity: high Docs Contact:
Priority: high    
Version: 4.0.3CC: ahadas, amarchuk, chenders, dfediuck, gklein, lsurette, mavital, michal.skrivanek, oourfali, rbalakri, Rhev-m-bugs, sbonazzo, srevivo, ykaul
Target Milestone: ovirt-4.1.0-alphaKeywords: 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:
: 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:
Embargoed:
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.