Bug 819532 - Upgrade db from 3.0 to 3.1 fails due to missing supported_engines
Summary: Upgrade db from 3.0 to 3.1 fails due to missing supported_engines
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-core
Version: unspecified
Hardware: x86_64
OS: Linux
high
high
Target Milestone: ---
: 3.1
Assignee: Eli Mesika
QA Contact:
URL:
Whiteboard: infra
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-05-07 13:52 UTC by Alex Lourie
Modified: 2012-08-09 08:01 UTC (History)
6 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2012-08-09 08:01:05 UTC
oVirt Team: ---
Embargoed:


Attachments (Terms of Use)

Description Alex Lourie 2012-05-07 13:52:43 UTC
Description of problem:
When upgrading from 3.0. the following error appears:

Creating views...
psql:create_views.sql:560: ERROR:  column vds_dynamic.supported_engines does not exist
LINE 20: ...orted_cluster_levels as supported_cluster_levels, vds_dynami...


Version-Release number of selected component (if applicable):
3.0

How reproducible:
Install RHEVM 3.0. Perform db upgrade to 3.1

Additional info:

The problem is in that the code that creates the column is currently resides in create_tables.sql, while it should be in one of the pre-upgrade functions.

WA is to add the following function call to the custom.sql in pre-upgrade folder:

select fn_db_add_column('vds_dynamic','supported_engines','varchar(40)');

Comment 1 Eli Mesika 2012-05-07 14:13:02 UTC
http://gerrit.ovirt.org/#change,4177

Comment 2 Itamar Heim 2012-08-09 08:01:05 UTC
closing ON_QA bugs as oVirt 3.1 was released:
http://www.ovirt.org/get-ovirt/


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