Hide Forgot
Description of problem: DWH collects data from the engine database, but it dos not proceed with the aggregation. Version-Release number of selected component (if applicable): rhevm-dwh-3.5.5-1.el6ev.noarch How reproducible: 100% in specific environment Steps to Reproduce: 1. It is not determined yet Actual results: Only old data available in *_daily_history/*_hourly_history tables. # select min(history_datetime),max(history_datetime) from vm_daily_history; min | max ------------+------------ 2016-09-07 | 2016-10-30 (1 row) # select min(history_datetime),max(history_datetime) from vm_samples_history; min | max ----------------------------+---------------------------- 2017-01-03 11:30:52.854+01 | 2017-01-05 01:39:57.345+01 (1 row) # select * from history_configuration; var_name | var_value | var_datetime -------------------+-----------+------------------------ MinimalETLVersion | 3.5.0 | default_language | en_US | firstSync | false | 2016-09-07 19:13:00+02 lastDayAggr | | 2017-01-03 07:00:00+01 lastHourAggr | | 2017-01-05 02:00:00+01 HourlyAggFailed | false | (6 rows) Expected results: The tables are periodically updated.
Please rerun the query select * from history_configuration; and also state the current time when you run it. Please attach log file and ovirt_engine_history db dump.