[
https://issues.apache.org/jira/browse/RANGER-3750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mateen N Mansoori updated RANGER-3750:
--------------------------------------
Summary: RANGER : PatchForSolrSvcDefAndPoliciesUpdate_J10055 failing with
'duplicate key value violates unique constraint' (was: RANGER :
PatchForSolrSvcDefAndPoliciesUpdate_J10055 will fail if we have resource like -
res_name,*)
> 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
> Reporter: Mateen N Mansoori
> Priority: Major
>
> 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)
