Bug 703283 – Job statistics overview under Grid User is not filtered for that user

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 703283 - Job statistics overview under Grid User is not filtered for that user

Summary:	Job statistics overview under Grid User is not filtered for that user

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Enterprise MRG
Classification:	Red Hat
Component:	cumin (Show other bugs)
Sub Component:
Version:	2.0
Hardware:	Unspecified Unspecified

Priority	medium Severity medium
Target Milestone:	2.0.1
Target Release:	---
Assigned To:	Chad Roberts
QA Contact:	Jan Sarenik
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:	723887
	Show dependency tree / graph

Reported:	2011-05-09 16:21 EDT by Trevor McKay
Modified:	2011-09-07 12:42 EDT (History)
CC List:	2 users (show)

See Also:
Fixed In Version:	cumin-0.1.4840-1
Doc Type:	Bug Fix
Doc Text:	Cause: There was no clause on the sql that totals the idle/running/completed stats to limit the totals to the current grid user. Consequence: The totals displayed on the page were for all users of the grid combined rather than just the current user. Fix: Added a where clause to the sql to choose the currently logged-in cumin user and limit the stats to that user. Result: The page now displays proper totals for the current cumin grid user.
Story Points:	---
Clone Of:
Environment:
Last Closed:	2011-09-07 12:42:45 EDT
Type:	---
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Red Hat Product Errata	RHSA-2011:1249	normal	SHIPPED_LIVE	Moderate: Red Hat Enterprise MRG Grid 2.0 security, bug fix and enhancement update	2011-09-07 12:40:45 EDT

Groups: None (edit)

Description Trevor McKay 2011-05-09 16:21:13 EDT

Description of problem:

The Job Statistics table under "Grid User" shows statistics for all users, not just the logged in user.  Data here is intended to be user specific.

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

(not sure, may be in 1.3.2)

How reproducible:

100%

Steps to Reproduce:
1.  Submit jobs as multiple different users
2.  Log into cumin as each user and check the Job Statistics table  
  
Actual results:

Values shown will be aggregated across all users

Expected results:

Values should be contrained to the particular user

Additional info:

Comment 1 Chad Roberts 2011-05-26 15:10:39 EDT

Fix available in revision 4791.

Comment 2 Chad Roberts 2011-05-26 15:10:39 EDT

    Technical note added. If any revisions are required, please edit the "Technical Notes" field
    accordingly. All revisions will be proofread by the Engineering Content Services team.
    
    New Contents:
Cause:  There was no clause on the sql that totals the idle/running/completed stats to limit the totals to the current grid user.

Consequence:  The totals displayed on the page were for all users of the grid combined rather than just the current user.

Fix:  Added a where clause to the sql to choose the currently logged-in cumin user and limit the stats to that user.

Result:  The page now displays proper totals for the current cumin grid user.

Comment 4 Jan Sarenik 2011-07-22 04:02:06 EDT

Verified with cumin-0.1.4878-1.el5.

Comment 5 errata-xmlrpc 2011-09-07 12:42:45 EDT

An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHSA-2011-1249.html

Note You need to log in before you can comment on or make changes to this bug.