Bug 1005533 - Upgrade script missing field in vm_template
Summary: Upgrade script missing field in vm_template
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-core
Version: unspecified
Hardware: Unspecified
OS: Unspecified
urgent
high
Target Milestone: ---
: 3.3.1
Assignee: Eli Mesika
QA Contact:
URL:
Whiteboard: virt
: 1021146 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-09-08 07:17 UTC by Shahar Havivi
Modified: 2013-11-25 12:06 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-11-25 12:06:16 UTC
oVirt Team: ---
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 20348 0 None None None Never

Description Shahar Havivi 2013-09-08 07:17:42 UTC
Commit: http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=0c47b30468b855e5c52b120f476d97cc754852ee
add single_qxl_pci field to vm_static and vm_template tables but fail to add the this field for vm_template (vm_static do upgrade).

This is causing upgrade failure.

Comment 1 Itamar Heim 2013-09-09 04:04:15 UTC
please backport to 3.3 branch

Comment 2 Eli Mesika 2013-09-09 08:50:53 UTC
Upgrade from beta to nightly is not supported 
Explanation :

The upgrade scripts are re-numbered when taken from nightly and back-ported into the 3.3 beta branch 
For example , the current latest upgrade scripts in the 3.3 beta branch are:
03_03_0650_allow_single_logic_for_policy_unit.sql ...
03_03_0660_add_enabled_column_to_policy_unit.sql ...
03_03_0670_add_description_to_policy_unit.sql ...
03_03_0680_remove_migration_domain_filter.sql ...

looking in the specific script that added single_qxl_pci field , its number in nighthly is 03_03_0650 and it was not ported yet to the beta branch

Therefor, when upgrading from 3.3 beta to nightly, since the latest script in the 3.3 beta DB is 03_03_0680, upgrade will start from 03_03_0690 and the nightly 03_03_0650 will be omitted and will cause the above error.

So, either use a clean install on the beta branch and install only beta releases or use clean install nightly and use nightly releases

You can upgrade from nighthly to nightly and from beta to to beta. but upgrade from beta to nightly is not supported

Comment 3 Jason Brooks 2013-10-19 00:28:21 UTC
Is stable to beta upgrade supported? I'm hitting this same issue with 3.3.0.1 to 3.3.1 beta.

Comment 4 Shahar Havivi 2013-10-20 08:58:47 UTC
(In reply to Jason Brooks from comment #3)
> Is stable to beta upgrade supported? I'm hitting this same issue with
> 3.3.0.1 to 3.3.1 beta.
The current beta have an upgrade error
http://lists.ovirt.org/pipermail/users/2013-October/017261.html

Comment 5 Eli Mesika 2013-10-21 08:09:52 UTC
re-opening for fixing the 3.3.0.1 to 3.3.1 beta upgrade :

here are 2 updates that have wrong numbering in 3.3.1 Beta :

1) 03_03_0650_add_signle_qxl_pci_column.sql => this change will not be installed in the upgrade since the latest change was 0680
2) 03_03_0680_add_cpu_shares_to_vm.sql => this script will also be skipped

The fix to that is to add the following scripts to 3.3.1.Beta which are exact copies of 1) and 2) from above as :

03_03_0681_add_cpu_shares_to_vm.sql
03_03_0682_add_signle_qxl_pci_column.sql

Comment 6 Sandro Bonazzola 2013-10-21 14:23:30 UTC
*** Bug 1021146 has been marked as a duplicate of this bug. ***

Comment 7 Sandro Bonazzola 2013-11-25 12:06:16 UTC
oVirt 3.3.1 has been released


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