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.
Comment 12Red Hat Bugzilla
2023-09-14 03:37:04 UTC
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days
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.