RHVM DWH issue

row count.md

ovirt_engine_history=> SELECT schemaname,relname,n_live_tup 
ovirt_engine_history->   FROM pg_stat_user_tables 
ovirt_engine_history->   ORDER BY n_live_tup DESC;
 schemaname |              relname              | n_live_tup 
------------+-----------------------------------+------------
 public     | vm_interface_samples_history      |   14825449
 public     | vm_disks_usage_samples_history    |    3317022
 public     | vm_samples_history                |    2008714
 public     | vm_interface_hourly_history       |    1911237
 public     | vm_disk_hourly_history            |     659554
 public     | vm_hourly_history                 |     627554
 public     | vm_disks_usage_hourly_history     |     627356
 public     | host_interface_configuration      |     255088
 public     | calendar                          |      87673
 public     | host_interface_hourly_history     |      76000
 public     | statistics_vms_users_usage_hourly |      31398
 public     | vm_device_history                 |      20899
 public     | datacenter_configuration          |      12736
 public     | vm_interface_configuration        |       9204
 public     | vm_configuration                  |       4026
 public     | vm_disk_configuration             |       3547
 public     | vm_interface_daily_history        |       2861
 public     | host_hourly_history               |       2363
 public     | storage_domain_hourly_history     |       1799
 public     | vm_disk_daily_history             |       1013
 public     | vm_daily_history                  |        968
 public     | vm_disks_usage_daily_history      |        963
 public     | enum_translator                   |        703
 public     | host_configuration                |        394
 public     | host_interface_daily_history      |        150
 public     | storage_domain_configuration      |         94
 public     | statistics_vms_users_usage_daily  |         89
 public     | datacenter_storage_domain_map     |         70
 public     | cluster_configuration             |         44
 public     | schema_version                    |         42
 public     | host_daily_history                |         32
 public     | storage_domain_daily_history      |         28
 public     | history_configuration             |          6
 public     | users_details_history             |          1
 public     | tag_relations_history             |          0
 public     | vm_disk_samples_history           |          0
 public     | tag_details                       |          0
 public     | storage_domain_samples_history    |          0
 public     | host_samples_history              |          0
 public     | host_interface_samples_history    |          0
(40 rows)

ovirt_engine_history=> select * from host_daily_history;
 history_id | history_datetime | host_id | host_status | minutes_in_status | memory_usage_percent | max_memory_usage | cpu_usage_percent | max_cpu_usage | ksm_cpu_percent | max_ksm_cpu_percent | active_vms | max_active_vms | total_vms | m
ax_total_vms | total_vms_vcpus | max_total_vms_vcpus | cpu_load | max_cpu_load | system_cpu_usage_percent | max_system_cpu_usage_percent | user_cpu_usage_percent | max_user_cpu_usage_percent | swap_used_mb | max_swap_used_mb | host_configuration_version | ksm_shared_memory_mb | max_ksm_shared_memory_mb 
------------+------------------+---------+-------------+-------------------+----------------------+------------------+-------------------+---------------+-----------------+---------------------+------------+----------------+-----------+--
-------------+-----------------+---------------------+----------+--------------+--------------------------+------------------------------+------------------------+----------------------------+--------------+------------------+------------
----------------+----------------------+--------------------------
(0 rows)

In /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log

017-11-05 02:00:47|K7rFaa|MX40Fp|1F72Cf|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704