Bug 1323183 - [migration 3.6 - 4.0] org.postgresql.util.PSQLException: ERROR: relation "v3_0_latest_disks_vm_map_view" does not exist
Summary: [migration 3.6 - 4.0] org.postgresql.util.PSQLException: ERROR: relation "v3_...
Keywords:
Status: CLOSED DUPLICATE of bug 1323605
Alias: None
Product: ovirt-engine-dwh
Classification: oVirt
Component: Database
Version: 4.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ovirt-4.0.0-alpha
: ---
Assignee: Shirly Radco
QA Contact: Pavel Stehlik
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-04-01 13:04 UTC by Jiri Belka
Modified: 2016-04-25 08:22 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2016-04-06 06:55:00 UTC
oVirt Team: Integration
Embargoed:
sradco: ovirt-4.0.0?
rule-engine: planning_ack?
sradco: devel_ack+
rule-engine: testing_ack?


Attachments (Terms of Use)

Description Jiri Belka 2016-04-01 13:04:35 UTC
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:

Comment 2 Sandro Bonazzola 2016-04-06 06:49:43 UTC
Can you reproduce on migration instead of on in place upgrade?

Comment 3 Shirly Radco 2016-04-06 06:55:00 UTC

*** This bug has been marked as a duplicate of bug 1323605 ***

Comment 4 Jiri Belka 2016-04-25 08:22:27 UTC
(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.


Note You need to log in before you can comment on or make changes to this bug.