Mateen N Mansoori created RANGER-3750:
-----------------------------------------
Summary: RANGER : PatchForSolrSvcDefAndPoliciesUpdate_J10055 will
fail if we have resource like - res_name,*
Key: RANGER-3750
URL: https://issues.apache.org/jira/browse/RANGER-3750
Project: Ranger
Issue Type: Bug
Components: Ranger
Reporter: Mateen N Mansoori
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)
