Bug 783787

Summary: [ovirt-etl] - Sample History - Saves data in host_samples_history_table/View for more then 48H
Product: [Retired] oVirt Reporter: David Botzer <dbotzer>
Component: ovirt-engine-dwhAssignee: Yaniv Lavi <ylavi>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: high    
Version: unspecifiedCC: acathrow, iheim, mkalinin, pstehlik, yeylon, ykaul
Target Milestone: ---   
Target Release: 3.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-08-09 07:58:40 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description David Botzer 2012-01-22 14:33:31 UTC
Description of problem:
In ovirt_history DB, at host_samples_history (Table/View) the data being accumulated is more than 48H (18-1 until 22-1)

Version-Release number of selected component (if applicable):
ovirt-engine-3.0.0_0001-1.2, dwh & reports 3.0

How reproducible:
always

Steps to Reproduce:
1.install ovirt-engine setup with ovirt-dwh (reports is on a remote server)
2.install 1 host and let it run for couple of days
3.examine the history_sample view
  
Actual results:
host_samples_history (Table/View) the data being accumulated is more than 48H (18-1 until 22-1)

Expected results:
it should up to 48H (the ETL config file defines hoursToKeepSamples=24 {+24H till next day to delete} )

Additional info:

Comment 1 Yaniv Lavi 2012-05-23 14:21:41 UTC
Fixed in patch:
http://gerrit.ovirt.org/4706


Yaniv

Comment 2 Itamar Heim 2012-08-09 07:58:40 UTC
closing ON_QA bugs as oVirt 3.1 was released:
http://www.ovirt.org/get-ovirt/