[RANGER-2149] REST search queries make Ranger incredibly slow

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Workaround
• Affects Version/s: 0.7.0
• Component/s: Ranger
• Assignee: Pradeep Agrawal
• Reporter: Alexander Posledov
• Created: 04/Jul/18 09:02
• Updated: 22/Dec/19 13:10
• Resolved: 26/Jul/18 04:15

Description

If amount of Ranger policies is relatively big (3000-4000), then REST search queries (e.g. search policy by name) make Ranger very slow. Example:

curl -u admin:admin -X GET http://host:6080/service/plugins/policies?policyName=somePolicyName

2-3 such queries (if we have ~3k policies) can cause too long delays even for simple requests, while these searches aren't completed. In some cases, when we ran several search queries simultaneously, this Ranger behavior caused 9 min delay for simple adding a new policy.