Bug 1398944 - users_details_history table is being updated too much
Summary: users_details_history table is being updated too much
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine-dwh
Classification: oVirt
Component: ETL
Version: 4.0.1
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ovirt-4.0.6
: ---
Assignee: Shirly Radco
QA Contact: Lukas Svaty
URL:
Whiteboard:
Depends On:
Blocks: 1401304
TreeView+ depends on / blocked
 
Reported: 2016-11-27 13:58 UTC by Shirly Radco
Modified: 2017-01-18 07:28 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-01-18 07:28:34 UTC
oVirt Team: Metrics
Embargoed:
rule-engine: ovirt-4.0.z+
rule-engine: ovirt-4.1+
rule-engine: planning_ack+
sradco: devel_ack+
lsvaty: testing_ack+

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 67420 0 master MERGED history: update dwh_users_history_view 2016-11-29 15:14:28 UTC
oVirt gerrit 67423 0 master MERGED history: updated users collection 2016-11-29 15:37:43 UTC
oVirt gerrit 67530 0 ovirt-engine-4.0 MERGED history: update dwh_users_history_view 2016-11-29 16:42:38 UTC
oVirt gerrit 67531 0 ovirt-engine-4.0.6 MERGED history: update dwh_users_history_view 2016-11-29 16:43:07 UTC
oVirt gerrit 67780 0 ovirt-engine-dwh-4.0 MERGED history: updated users collection 2016-12-04 11:17:56 UTC

Description Shirly Radco 2016-11-27 13:58:23 UTC 
Description of problem:
All users in users_details_history table are updated each sampling.

Version-Release number of selected component (if applicable):
4.0

How reproducible:


Steps to Reproduce:
1.Should check the number of table updates and see that it update only if a record was updated /added or deleted.

Actual results:
Updates all users regardless if there was any change to the records

Expected results:
Should update only on user insert /update /delete.

Additional info:
Comment 1 Lukas Svaty 2016-12-16 13:40:06 UTC 
verified sanity only in ovirt-engine-dwh-4.0.6-1.el7ev.noarch
Note You need to log in before you can comment on or make changes to this bug.