Bug 868937 - 3.0.z - [rhevm-dwh] - Duplicate rows in Views
Summary: 3.0.z - [rhevm-dwh] - Duplicate rows in Views
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh
Version: 3.1.0
Hardware: x86_64
OS: Linux
high
high
Target Milestone: ---
: 3.0.8
Assignee: Yaniv Lavi
QA Contact: David Botzer
URL:
Whiteboard: infra
Depends On: 866492
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-10-22 13:59 UTC by Idith Tal-Kohen
Modified: 2016-02-10 19:21 UTC (History)
11 users (show)

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.
Clone Of: 866492
Environment:
Last Closed: 2012-11-27 19:57:43 UTC
oVirt Team: Infra
Target Upstream Version:
Embargoed:
dbotzer: needinfo-

Attachments (Terms of Use)
dup (53.22 KB, image/png)
2012-10-25 05:59 UTC, David Botzer 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2012:1497 0 normal SHIPPED_LIVE rhevm-dwh bug fix update 2012-11-28 00:56:43 UTC

Comment 2 Yaniv Lavi 2012-10-23 13:02:11 UTC 
Committed to 3.0 repo:
http://git2.engineering.redhat.com/?p=users/ydary/3.0/rhevm-reports/.git;a=commit;h=e8b44f35cda012af25e6eeade584368b0a6408fa


Yaniv
Comment 3 Stephen Gordon 2012-10-24 19:40:28 UTC 
I set a NEEDINFO on Bug # 843468 to find out what the difference between the two is.
Comment 4 David Botzer 2012-10-25 05:58:32 UTC 
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
Comment 5 David Botzer 2012-10-25 05:59:38 UTC 
Created attachment 633169 [details]
dup
Comment 6 Itamar Heim 2012-10-25 07:22:56 UTC 
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)
Comment 7 Yaniv Lavi 2012-10-25 14:29:40 UTC 
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
Comment 8 David Botzer 2012-11-06 12:30:36 UTC 
which Build for 3.0 is it fixed ?
Comment 9 David Botzer 2012-11-07 07:41:39 UTC 
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
Comment 10 Yaniv Lavi 2012-11-07 09:04:06 UTC 
(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.
Comment 11 David Botzer 2012-11-08 05:52:07 UTC 
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
Comment 12 David Botzer 2012-11-08 08:19:05 UTC 
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
Comment 13 David Botzer 2012-11-13 10:59:27 UTC 
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
Comment 15 errata-xmlrpc 2012-11-27 19:57:43 UTC 
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
Note You need to log in before you can comment on or make changes to this bug.