-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74076/
-----------------------------------------------------------
Review request for ranger.
Bugs: RANGER-3846
https://issues.apache.org/jira/browse/RANGER-3846
Repository: ranger
Description
-------
**Problem Statement:** Ranger DB patch 058 failing when multiple policies
having same resourceSignature.
**Proposed Solution:** Delete the duplicate policies during the patch execution
itself.
Diffs
-----
security-admin/src/main/java/org/apache/ranger/biz/RangerPolicyRetriever.java
238fecd48
security-admin/src/main/java/org/apache/ranger/db/XXPolicyDao.java 4677c37f3
security-admin/src/main/java/org/apache/ranger/db/XXPortalUserDao.java
8d15a324e
security-admin/src/main/java/org/apache/ranger/patch/PatchPreSql_058_ForUpdateToUniqueResoureceSignature_J10053.java
0227298aa
security-admin/src/main/resources/META-INF/jpa_named_queries.xml 7e69cc4a3
Diff: https://reviews.apache.org/r/74076/diff/1/
Testing
-------
installed ranger 0.7 and created duplicate policies with same resource
signature.
With patch build the latest master branch ranger
Used the same db config of 0.7 install and upgrade ranger.
sql patch 58 and linked java patch
PatchPreSql_058_ForUpdateToUniqueResoureceSignature_J10053.java executed
successfully and unique index was created for service and resource signature on
x_policy table.
started ranger and login to ranger-admin and duplicate policies were removed.
Thanks,
Pradeep Agrawal
