[RANGER-2639] XUserService has duplicate db query in when populateViewBean for XXUser

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.6.0, 1.0.0, 0.7.1, 1.1.0, 1.2.0
• Fix Version/s: 2.1.0
• Component/s: admin
• Labels: optimization performance ranger security
• Environment: hdp 2.2
• Assignee: zhangxiong
• Reporter: zhangxiong
• Created: 07/Nov/19 02:04
• Updated: 14/May/20 17:25
• Resolved: 04/Feb/20 05:26

Description

when request http api /service/xusers/users with GET method.ranger admin will query db and get XXUser,then transform the XXUser to VXUser. in the tranformation process,

XUserService.populateUserAttributes() method is called two times.and make extra 2 times db query.when the result users are many,this causes significant performance issue,rougly 40% performance down。so indeed we need to call populateUserAttributes() once .

we found this issue in our production environment with 1000+ users in ranger admin,and start the kafka or other component which enabled ranger authority.in the start process, setup_ranger_xxxx() is called and make http /service/xusers/users request to ranger.as it query all users in ranger,ranger admin will reponse in several ten seconds.

Issue Links

• links to: https://github.com/apache/ranger/pull/43
• links to: review request