Bug 1323183
| Summary: | [migration 3.6 - 4.0] org.postgresql.util.PSQLException: ERROR: relation "v3_0_latest_disks_vm_map_view" does not exist | ||
|---|---|---|---|
| Product: | [oVirt] ovirt-engine-dwh | Reporter: | Jiri Belka <jbelka> |
| Component: | Database | Assignee: | Shirly Radco <sradco> |
| Status: | CLOSED DUPLICATE | QA Contact: | Pavel Stehlik <pstehlik> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.0.0 | CC: | bugs, jbelka, sbonazzo |
| Target Milestone: | ovirt-4.0.0-alpha | Flags: | sradco:
ovirt-4.0.0?
rule-engine: planning_ack? sradco: devel_ack+ rule-engine: testing_ack? |
| 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-06 06:55:00 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Integration | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
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. |
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: