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 history_datetime,vm_id,cpu_usage_percent,max_cpu_usage from vm_hourly_history order by history_datetime desc limit 10;
    history_datetime    |                vm_id                 | cpu_usage_percent | max_cpu_usage 
------------------------+--------------------------------------+-------------------+---------------
 2017-07-05 11:00:00-04 | a8df6b90-1a60-4e31-9bce-65f0747024ae |                 0 |             0
 2017-07-05 11:00:00-04 | 716eae37-2a3b-43a1-af1d-c1692714d573 |                 0 |             0
 2017-07-05 11:00:00-04 | 536a6c9a-9399-419d-a975-e3975359b8a8 |                 0 |             0
 2017-07-05 11:00:00-04 | 63fff762-6489-40d4-a8b6-115532e08c6a |                 0 |             0
 2017-07-05 11:00:00-04 | f304cc70-e97d-454f-8da4-ebbc8386a537 |                 2 |            15
 2017-07-05 11:00:00-04 | 20dd48b0-f1c2-4995-95c1-a2eb006a22db |                 0 |             0
 2017-07-05 11:00:00-04 | fa7f7bf3-0602-4e81-8c1d-eab8cc7471e9 |                 0 |             0
 2017-07-05 11:00:00-04 | 54e70134-f504-49a0-b26f-6a35ab5b9081 |                 0 |             0
 2017-07-05 11:00:00-04 | 38ab5c20-a6af-4cdf-aaa6-de28fdf075b6 |                 0 |             0
 2017-07-05 11:00:00-04 | 111e3517-b977-4364-b9a7-84047c945c68 |                 0 |             0
(10 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