Bug 868937
Summary: | 3.0.z - [rhevm-dwh] - Duplicate rows in Views | ||||||
---|---|---|---|---|---|---|---|
Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Idith Tal-Kohen <italkohe> | ||||
Component: | ovirt-engine-dwh | Assignee: | Yaniv Lavi <ylavi> | ||||
Status: | CLOSED ERRATA | QA Contact: | David Botzer <dbotzer> | ||||
Severity: | high | Docs Contact: | |||||
Priority: | high | ||||||
Version: | 3.1.0 | CC: | bazulay, cpelland, dbotzer, dyasny, iheim, pstehlik, Rhev-m-bugs, sgordon, sgrinber, ykaul, yzaslavs | ||||
Target Milestone: | --- | Keywords: | ZStream | ||||
Target Release: | 3.0.8 | Flags: | dbotzer:
needinfo-
|
||||
Hardware: | x86_64 | ||||||
OS: | Linux | ||||||
Whiteboard: | infra | ||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: |
Previously, the virtual machine hourly history view and the virtual machine daily history view in the engine database contained duplicated records with the same history identifiers. Duplicated history identifiers distort historical data. The views were corrected so that each entry has a unique history identifier. The statistics contained in the views are no longer prone to distortion caused by duplicated history identifiers.
|
Story Points: | --- | ||||
Clone Of: | 866492 | Environment: | |||||
Last Closed: | 2012-11-27 19:57:43 UTC | Type: | Bug | ||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | --- | |||||
oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | --- | Target Upstream Version: | |||||
Embargoed: | |||||||
Bug Depends On: | 866492 | ||||||
Bug Blocks: | |||||||
Attachments: |
|
Comment 2
Yaniv Lavi
2012-10-23 13:02:11 UTC
I set a NEEDINFO on Bug # 843468 to find out what the difference between the two is. 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 Created attachment 633169 [details]
dup
this is a 3.0.z bug, testing should be done on 3.0 (though i'd wait for the fix for the 3.1 bug first) Had to add a fix for the patch: http://git2.engineering.redhat.com/?p=users/ydary/3.0/rhevm-reports/.git;a=commit;h=16d60e56e48e1acead156d1eaed4a90263c5c3a9 Yaniv which Build for 3.0 is it fixed ? Not Fixed, 3.0/ic158.1 In v3_0_vm_hourly_history_view & v3_0_vm_daily_history_view - I have triple duplicate rows, Please advise before I reopen, v3_0_vm_hourly_history_view -- 128283;"2012-11-07 06:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;60.00;13 128283;"2012-11-07 06:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;60.00;13 128283;"2012-11-07 06:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;60.00;13 v3_0_vm_daily_history_view -- 22062;"2012-11-04 00:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;1451.00;13 22062;"2012-11-04 00:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;1451.00;13 22062;"2012-11-04 00:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;1451.00;13 (In reply to comment #9) > Not Fixed, 3.0/ic158.1 > > In v3_0_vm_hourly_history_view & v3_0_vm_daily_history_view - I have triple > duplicate rows, > > Please advise before I reopen, > > v3_0_vm_hourly_history_view -- > 128283;"2012-11-07 > 06:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;60.00;13 > 128283;"2012-11-07 > 06:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;60.00;13 > 128283;"2012-11-07 > 06:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;60.00;13 > > v3_0_vm_daily_history_view -- > 22062;"2012-11-04 > 00:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;1451.00;13 > 22062;"2012-11-04 > 00:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;1451.00;13 > 22062;"2012-11-04 > 00:00:00+02";"735e4102-9c68-4633-9b97-1daa6f79c14b";1;1451.00;13 rpm version please. Why am I "Need Info" ? I tested ,3.0/ic158.1 rhevm-reports-server-3.0.8-1.noarch rhevm-reports-3.0.8-1.noarch rhevm-reports-dwh-3.0.8-1.noarch Not Fixed, 3.0/ic158.1 rhevm-reports-server-3.0.8-1.noarch rhevm-reports-3.0.8-1.noarch rhevm-reports-dwh-3.0.8-1.noarch Fixed, 3.0/ic158.2 rhevm-reports-server-3.0.8-2.noarch rhevm-reports-3.0.8-2.noarch rhevm-reports-dwh-3.0.8-2.noarch Fixed, 3.0/ic158.2 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-1497.html |