The daily ovirt_engine_history data are not aggregated
Issue
The ovirt_engine_history database keeps only data from 48h ago and the older data are deleted.
psql -W -U ovirt_engine_history -h localhost -p 5432 -c "SELECT history_id,history_datetime,host_id FROM v4_0_statistics_hosts_resources_usage_daily;" -d ovirt_engine_history
history_id | history_datetime | host_id
------------+------------------+--------------------------------------
117 | 2017-10-14 | 1715dc31-4eb4-3bbe-9224-3f75b3a22202
118 | 2017-10-14 | 1e491d0e-43b1-4622-8209-d74029175d62
(2 rows)
As from the documentation the hourly data more than two days old should be aggregated into daily data and stored for five years.
The /usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.conf
is set correctly
# Table Sizes Control in Hours
DWH_TABLES_KEEP_SAMPLES=24
DWH_TABLES_KEEP_HOURLY=1440
DWH_TABLES_KEEP_DAILY=43800
Environment
- Red Hat Virtualization 4.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.