Bug 1382746 - 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 NOTABUG
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine
Version: 4.0.3
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ovirt-4.1.0-alpha
: ---
Assignee: Arik
QA Contact: sefi litmanovich
URL:
Whiteboard:
: 1382744 (view as bug list)
Depends On: 1384770
Blocks: 1390254
TreeView+ depends on / blocked
 
Reported: 2016-10-07 14:57 UTC by Chris Henderson
Modified: 2017-02-01 10:14 UTC (History)
14 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1384770 1390254 (view as bug list)
Environment:
Last Closed: 2017-02-01 10:14:36 UTC
oVirt Team: Virt
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHEA-2017:0997 0 normal SHIPPED_LIVE Red Hat Virtualization Manager (ovirt-engine) 4.1 GA 2017-04-18 20:11:26 UTC
oVirt gerrit 65440 0 None None None 2016-10-13 20:06:03 UTC

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.
Note You need to log in before you can comment on or make changes to this bug.