Created attachment 627441 [details] duplicate Description of problem: When displaying the views in history db, I see duplicate records with the same history ID Version-Release number of selected component (if applicable): 3.1/si20 How reproducible: always Steps to Reproduce: 1.install rhevm+reports+dwh 2.create several VMs and run for couple of days 3.check the vm_hourly_history_view & v3_1_vm_daily_history_view Actual results: Duplicate rows with same values Expected results: should have unique rows per history id Additional info:
Hi Yaniv, Why is this blocker ? How does it affect Reports ?
(In reply to comment #3) > Hi Yaniv, > > Why is this blocker ? > How does it affect Reports ? displays duplicate data and causes distortion is stats.
Added bug on talend: https://jira.talendforge.org/browse/TDI-23367 And workaround patch: http://gerrit.ovirt.org/8702 Yaniv
Changed in patch upstream: http://gerrit.ovirt.org/#/c/8702/ and downstream: https://gerrit.eng.lab.tlv.redhat.com/#/c/2781/ Yaniv
Not Fixed, 3.1/si22.1 clean installation of si22 & si22.1, One entity of a kind ran for 24H v3_1_vm_hourly_history_view 16;"2012-10-25 05:00:00+02" 16;"2012-10-25 05:00:00+02" 15;"2012-10-25 04:00:00+02" 15;"2012-10-25 04:00:00+02" See pic Not Fixed, 3.1/si22.1
Needed to do another fix: upstream - http://gerrit.ovirt.org/#/c/8824/ downstream - https://gerrit.eng.lab.tlv.redhat.com/#/c/2879/ Yaniv
Fixed, 3.1/si24 (remote, Local, Clean & Upgraded) No Dupicates in history db views: v3_1_vm_hourly_history_view v3_1_vm_daily_history_view v3_1_vm_interface_hourly_history_view v3_1_vm_interface_daily_history_view v3_1_vm_disk_hourly_history_view v3_1_vm_disk_daily_history_view Fixed, 3.1/si24 (remote, Local, Clean & Upgraded) Same as bz Bug 843468 - 3.0.z - [rhevm-dwh] - History DB - Duplicate records in History Aggregation Views
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHBA-2012-1534.html