Bug 703283

Summary:	Job statistics overview under Grid User is not filtered for that user
Product:	Red Hat Enterprise MRG	Reporter:	Trevor McKay <tmckay>
Component:	cumin	Assignee:	Chad Roberts <croberts>
Status:	CLOSED ERRATA	QA Contact:	Jan Sarenik <jsarenik>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	2.0	CC:	croberts, jsarenik
Target Milestone:	2.0.1
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
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 16:42:45 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	723887

Description Trevor McKay 2011-05-09 20:21:13 UTC

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 19:10:39 UTC

Fix available in revision 4791.

Comment 2 Chad Roberts 2011-05-26 19:10:39 UTC

    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 08:02:06 UTC

Verified with cumin-0.1.4878-1.el5.

Comment 5 errata-xmlrpc 2011-09-07 16:42:45 UTC

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