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
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise MRG
Classification: Red Hat
Component: cumin
Version: 2.0
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: 2.0.1
: ---
Assignee: Chad Roberts
QA Contact: Jan Sarenik
URL:
Whiteboard:
Depends On:
Blocks: 723887
TreeView+ depends on / blocked
 
Reported: 2011-05-09 20:21 UTC by Trevor McKay
Modified: 2011-09-07 16:42 UTC (History)
2 users (show)

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.
Clone Of:
Environment:
Last Closed: 2011-09-07 16:42:45 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2011:1249 0 normal SHIPPED_LIVE Moderate: Red Hat Enterprise MRG Grid 2.0 security, bug fix and enhancement update 2011-09-07 16:40:45 UTC

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


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