Description of problem: Update hosts and vms receive_rate_percent and transmit_rate_percent network statistics precision, based on the changes made in Bug #1459908. Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. install rhevm and hypervisor and dwh 2. check data collected to the ovirt_engine_history db for hosts and vms 3. query app
All rx/tx percent rate columns in dwh database changed to decimal(18, 4). But stored numbers in host_interface_samples_history - receive_rate_percent/transmit_rate_percent are without decimals. engine statistics: engine=# select * from vds_interface_statistics; id | vds_id | rx_rate 351735ba-d45f-4521-b75f-54afbc3e8ec6 | 0b15bc11-cff7-4e17-8e00-3acac5054c57 | 22.1555 | 0.1327 | dwh: ovirt_engine_history=# select * from host_interface_samples_history where host_interface_id='351735ba-d45f-4521-b75f-54afbc3e8ec6' order by history_datetime desc limit 10; history_id | history_datetime | host_interface_id | receive_rate_percent | transmit_rate_percent 526033 | 2018-06-07 13:39:51.604+02 | 351735ba-d45f-4521-b75f-54afbc3e8ec6 | 22.0000 | 0.0000 The same is with vm_interface_samples_history table. tested in ovirt-engine-dwh-4.2.4-1.el7ev.noarch
A fix was required also on the engine dwh views. Also missed adding tos_project files to the patch. Please test on both master and 4.2 branches because the code is different.
Requires ovirt-engine-4.2.4.4
All rx/tx percent rate columns are stored with the precision now. verified in ovirt-engine-dwh-4.3.0-0.0.master.20180607152407.el7.noarch and ovirt-engine-dwh-4.2.4.3-1.el7ev.noarch
This bugzilla is included in oVirt 4.2.4 release, published on June 26th 2018. Since the problem described in this bug report should be resolved in oVirt 4.2.4 release, it has been closed with a resolution of CURRENT RELEASE. If the solution does not work for you, please open a new bug report.