Bug 1339597

Summary:	When removing collection of data center statistics did not remove all references
Product:	[oVirt] ovirt-engine-dwh	Reporter:	Shirly Radco <sradco>
Component:	ETL	Assignee:	Shirly Radco <sradco>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Lukas Svaty <lsvaty>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	4.0.0	CC:	bugs, gklein, sbonazzo
Target Milestone:	ovirt-4.0.0-rc	Flags:	rule-engine: ovirt-4.0.0+ rule-engine: planning_ack+ rule-engine: devel_ack+ gklein: testing_ack+
Target Release:	4.0.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-07-05 07:58:17 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:
Embargoed:
Bug Depends On:
Bug Blocks:	1300328

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.