Bug 842119

Summary: pre upgrade scripts will not run correctly upon 3.0 DB restore
Product: [Retired] oVirt Reporter: Eli Mesika <emesika>
Component: ovirt-engine-coreAssignee: Eli Mesika <emesika>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: acathrow, dyasny, iheim, oschreib, ykaul
Target Milestone: ---   
Target Release: 3.2   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: integration
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-02-15 06:46:27 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 822145    
Attachments:
Description Flags
3.0 database file to restore from none

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