The daily ovirt_engine_history data are not aggregated

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In