[
https://issues.apache.org/jira/browse/RANGER-3750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal reassigned RANGER-3750:
---------------------------------------
Fix Version/s: 3.0.0
2.3.0
Assignee: Mateen Mansoori
Resolution: Fixed
Commit link :
[https://github.com/apache/ranger/commit/a8c4b57abd11ca2742a390e4292905e34b2543bc]
https://github.com/apache/ranger/commit/67584c17cee063a91ee5d4cba009c8f8463f7f99
> RANGER : PatchForSolrSvcDefAndPoliciesUpdate_J10055 failing with 'duplicate
> key value violates unique constraint'
> -----------------------------------------------------------------------------------------------------------------
>
> Key: RANGER-3750
> URL: https://issues.apache.org/jira/browse/RANGER-3750
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: 3.0.0, 2.3.0
> Reporter: Mateen N Mansoori
> Assignee: Mateen Mansoori
> Priority: Major
> Fix For: 3.0.0, 2.3.0
>
>
> Steps
> 1.Keep the existing default policy as it is
> 2. create a policy with resource
> collection - test, *
> 3.Perform upgrade
> 4.The upgrade fails for java patch 55
> {code:java}
> 2022-05-05 17:31:40,644 [I] java patch
> PatchForSolrSvcDefAndPoliciesUpdate_J10055 is being applied..
> javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse
> Persistence Services - 2.7.7.v20200504-69f2c2b80d):
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: duplicate key
> value violates unique constraint "x_policy_uk_service_signature"
> Detail: Key (service, resource_signature)=(11,
> 217ea0f3a46f347e055088a9418291595af70c473ad18d4d70dfe555d9243c33) already
> exists.
> Error Code: 0
> Call: INSERT INTO x_policy (id, ADDED_BY_ID, CREATE_TIME, description, guid,
> is_audit_enabled, is_enabled, name, policy_options, policy_priority,
> policy_text, policy_type, resource_signature, service, UPDATE_TIME,
> UPD_BY_ID, version, zone_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?)
> bind => [18 parameters bound] {code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
