Bug 1339597 - When removing collection of data center statistics did not remove all references
Summary: When removing collection of data center statistics did not remove all references
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine-dwh
Classification: oVirt
Component: ETL
Version: 4.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ovirt-4.0.0-rc
: 4.0.0
Assignee: Shirly Radco
QA Contact: Lukas Svaty
URL:
Whiteboard:
Depends On:
Blocks: 1300328
TreeView+ depends on / blocked
 
Reported: 2016-05-25 12:14 UTC by Shirly Radco
Modified: 2016-07-05 07:58 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-07-05 07:58:17 UTC
oVirt Team: Metrics
rule-engine: ovirt-4.0.0+
rule-engine: planning_ack+
rule-engine: devel_ack+
gklein: testing_ack+


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 58042 0 master MERGED history: fixed a bug when removing dc statistics 2016-05-25 17:53:37 UTC

Description Shirly Radco 2016-05-25 12:14:31 UTC
Description of problem:
When removing collection of data center statistics did not remove all references.
There was a reference in the DeleteTimeKeepingJob

Version-Release number of selected component (if applicable):
4.0

How reproducible:
100%

Steps to Reproduce:
1.Install Engine DWH and 
2. Let the Delete process run at 3AM
3.

Actual results:
Exception in component tJDBCInput_2                                 
org.postgresql.util.PSQLException: ERROR: relation "datacenter_samples_history" does not exist                                 
  Position: 31                                 
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)                                 
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)                                 
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)                                 
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:565)                                 
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)                                 
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:286)                                 
        at ovirt_engine_dwh.deletetimekeepingjob_4_0.DeleteTimeKeepingJob.tJDBCInput_2Process(DeleteTimeKeepingJob.java:4098)                                 
        at ovirt_engine_dwh.deletetimekeepingjob_4_0.DeleteTimeKeepingJob.tJDBCCommit_1Process(DeleteTimeKeepingJob.java:3852)                                 
        at ovirt_engine_dwh.deletetimekeepingjob_4_0.DeleteTimeKeepingJob.tRunJob_2Process(DeleteTimeKeepingJob.java:3631)                                 
        at ovirt_engine_dwh.deletetimekeepingjob_4_0.DeleteTimeKeepingJob.tJDBCInput_1Process(DeleteTimeKeepingJob.java:3368)                                 
        at ovirt_engine_dwh.deletetimekeepingjob_4_0.DeleteTimeKeepingJob.tJDBCConnection_1Process(DeleteTimeKeepingJob.java:2757)                                 
        at ovirt_engine_dwh.deletetimekeepingjob_4_0.DeleteTimeKeepingJob.tJDBCConnection_2Process(DeleteTimeKeepingJob.java:2632)                                 
        at ovirt_engine_dwh.deletetimekeepingjob_4_0.DeleteTimeKeepingJob$2.run(DeleteTimeKeepingJob.java:12146)                                 
2016-05-25 03:00:00|QV2txu|uRHfVX|OQkyQe|OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java Exception|tJDBCInput_2|org.postgresql.util.PSQLException:ERROR: relation "datacenter_samples_history" does not exist   

Expected results:
Delete job should run with no errors

Additional info:

Comment 1 Pavel Novotny 2016-06-06 10:24:29 UTC
Sandro, can you please update Target Release? Thanks

Comment 2 Lukas Svaty 2016-06-15 09:41:35 UTC
verified in ovirt-engine-dwh-4.0.0-2.el7ev.noarch

removing needinfo as Shirly already fixed it

Comment 3 Sandro Bonazzola 2016-07-05 07:58:17 UTC
oVirt 4.0.0 has been released, closing current release.


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