Bug 1322468

Summary: Upgrade from 3.5 to 4.0 fails: relation "v3_0_latest_disks_vm_map_view" does not exist
Product: [oVirt] ovirt-engine-dwh Reporter: Yedidyah Bar David <didi>
Component: DatabaseAssignee: Shirly Radco <sradco>
Status: CLOSED WONTFIX QA Contact: Pavel Stehlik <pstehlik>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.6.0CC: bugs
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-04-04 14:31:45 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Metrics RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Yedidyah Bar David 2016-03-30 14:24:42 UTC 
Description of problem:

While working on bug 1318580, I am trying to restore on 4.0 a backup taken in 3.5. engine-setup finishes (with current pending patches applied), but in get in the dwh log:

2016-03-30 17:16:16|BB5ayA|1OaDuX|7oxQAC|OVIRT_ENGINE_DWH|ConfigurationSync|Default|6|Java Exception|tJDBCInput_63|org.postgresql.util.PSQLException:ERROR: relation "v3_0_latest_disks_vm_map_view" does not exist
  Position: 120|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
        at ovirt_engine_dwh.samplerunjobs_4_0.SampleRunJobs.tRunJob_1Process(SampleRunJobs.java:1206)
        at ovirt_engine_dwh.samplerunjobs_4_0.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:1008)
        at ovirt_engine_dwh.samplerunjobs_4_0.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:775)
        at ovirt_engine_dwh.samplerunjobs_4_0.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:650)
        at ovirt_engine_dwh.samplerunjobs_4_0.SampleRunJobs$2.run(SampleRunJobs.java:2692)
2016-03-30 17:16:16|7oxQAC|1OaDuX|aHzVFA|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6028)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5773)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4400)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4275)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4144)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3544)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2923)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2236)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1580)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9721)
Comment 1 Yedidyah Bar David 2016-04-04 14:31:45 UTC 
This bug was opened because we considered direct upgrade 3.5->4.0, see bug 1302228. Now gave up on this, thus closing.