Description of problem: after migration from 3.6 el6 -> 3.6 el7 (FYA in this step there was upgrade to postgresql 9.x and DBs were converted to newer format via `postgresql-setup upgrade') -> 4.0 el7 dwhd has psql exception in log and I can see following event in Admin Portal: ETL service sampling has encountered an error. Please consult the service log for more details. 2016-04-01 14:59:41|ETL Service Started Exception in component tJDBCInput_63 org.postgresql.util.PSQLException: ERROR: relation "v3_0_latest_disks_vm_map_view" does not exist Position: 120 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_63Process(ConfigurationSync.java:60390) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_61Process(ConfigurationSync.java:34858) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_28Process(ConfigurationSync.java:34291) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_7Process(ConfigurationSync.java:32445) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_26Process(ConfigurationSync.java:31070) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_6Process(ConfigurationSync.java:28303) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_24Process(ConfigurationSync.java:25551) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_5Process(ConfigurationSync.java:23572) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_22Process(ConfigurationSync.java:21643) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_4Process(ConfigurationSync.java:19005) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_34Process(ConfigurationSync.java:16414) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_33Process(ConfigurationSync.java:15200) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_20Process(ConfigurationSync.java:13991) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_3Process(ConfigurationSync.java:12608) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_18Process(ConfigurationSync.java:11622) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_1Process(ConfigurationSync.java:10063) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_15Process(ConfigurationSync.java:8607) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_2Process(ConfigurationSync.java:7224) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_11Process(ConfigurationSync.java:6251) at ovirt_engine_dwh.configurationsync_4_0.ConfigurationSync.tJDBCInput_9Process(ConfigurationSync.java:4439) 2016-04-01 15:02:20|y0g8GP|Cj8dZA|35VTZi|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) Version-Release number of selected component (if applicable): ovirt-engine-dwh-4.0.0-0.0.master.20160327105937.20160327105357.git7b654cf.el7.noarch How reproducible: 100% Steps to Reproduce: 1. migrate from 3.6 el7 to 4.0 2. start dwhd 3. observe ovirt-engine-dwhd.log and events in Admin Portal Actual results: dwhd does not work correctly Expected results: should work Additional info:
Can you reproduce on migration instead of on in place upgrade?
*** This bug has been marked as a duplicate of bug 1323605 ***
(In reply to Sandro Bonazzola from comment #2) > Can you reproduce on migration instead of on in place upgrade? Changes in BZ1323605 were merged and in migration way all worked smoothly.