Bug 842119 - pre upgrade scripts will not run correctly upon 3.0 DB restore
Summary: pre upgrade scripts will not run correctly upon 3.0 DB restore
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-core
Version: unspecified
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: 3.2
Assignee: Eli Mesika
QA Contact:
URL:
Whiteboard: integration
Depends On:
Blocks: 822145
TreeView+ depends on / blocked
 
Reported: 2012-07-22 10:03 UTC by Eli Mesika
Modified: 2013-02-15 06:46 UTC (History)
5 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2013-02-15 06:46:27 UTC
oVirt Team: ---
Embargoed:

Attachments (Terms of Use)
3.0 database file to restore from (662.55 KB, text/x-sql)
2012-07-22 10:03 UTC, Eli Mesika 		no flags Details
View All

Description Eli Mesika 2012-07-22 10:03:33 UTC 
Created attachment 599578 [details]
3.0 database file to restore from

Description of problem:
Restore a 3.0 database and runnig the 3.1 upgrade scripts on it is not working.

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


How reproducible:
Always

Steps to Reproduce:
1.dropdb -U postgres engine
2.createdb -U postgres engine
3.psql -U postgres -d engine -w < engine.sql
4.upgrade.sh -u postgres -d engine
  
Actual results:
psql:/tmp/tmp.mXz8U4xpWr:3: ERROR:  column "comment" of relation "schema_version" does not exist
LINE 1: ...ksum,installed_by,started_at,ended_at,state,current,comment)

Expected results:
Upgrade should complete successfully

Additional info:
engine.sql (attached)
Comment 1 Eli Mesika 2012-07-22 10:21:14 UTC 
http://gerrit.ovirt.org/#/c/6504/
Comment 2 Eli Mesika 2012-07-23 15:54:38 UTC 
fixed in commit : 5845c73
Comment 3 Ofer Schreiber 2012-07-25 15:34:24 UTC 
Should be cherry-picked into engine_3.1

Eli- can you do that pleasE?
Comment 4 Eli Mesika 2012-07-25 20:17:57 UTC 
(In reply to comment #3)
> Should be cherry-picked into engine_3.1
> 
> Eli- can you do that pleasE?

sure, will let you know when done
Comment 5 Itamar Heim 2013-01-16 16:08:38 UTC 
3.2 beta built, moving to ON_QA status to allow testing
Note You need to log in before you can comment on or make changes to this bug.