[RANGER-3750] RANGER : PatchForSolrSvcDefAndPoliciesUpdate_J10055 failing with 'duplicate key value violates unique constraint'

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0, 2.3.0
• Fix Version/s: 3.0.0, 2.3.0
• Component/s: Ranger
• Assignee: Mateen Mansoori
• Reporter: Mateen N Mansoori
• Created: 06/May/22 06:34
• Updated: 06/May/22 15:26
• Resolved: 06/May/22 15:26

Description

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

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] 

Issue Links

• links to: Review Board