ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Velmurugan Periasamy (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (RANGER-2433) Ranger base plugin `grant-<timestamp>` (the auto-generated grant name) may not be unique enough - Failing concurrent transactions
Date Thu, 23 May 2019 18:44:00 GMT

    [ https://issues.apache.org/jira/browse/RANGER-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16846951#comment-16846951
] 

Velmurugan Periasamy commented on RANGER-2433:
----------------------------------------------

Looks similar to https://issues.apache.org/jira/browse/RANGER-2369

>  Ranger base plugin `grant-<timestamp>` (the auto-generated grant name) may not
be unique enough - Failing concurrent transactions
> ----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: RANGER-2433
>                 URL: https://issues.apache.org/jira/browse/RANGER-2433
>             Project: Ranger
>          Issue Type: Bug
>          Components: plugins
>            Reporter: Mahendra Korepu
>            Priority: Major
>
> When running concurrent grant transactions -  Ranger base plugin returns following
error:
>  
> {code:java}
> // ERROR: InternalException: HTTP 400 Error: Exception [EclipseLink-4002] (Eclipse Persistence
Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "x_policy_uk_name_service_zone"
> Detail: Key (name, service, zone_id)=(grant-1557766372626, 4, 1) 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]
> Query: InsertObjectQuery(XXPolicy [id=6438])
> Could not execute command: GRANT SELECT ON table db1.tbl1 TO GROUP usr_grp1
> Start, End, Duration: 20190513-095246/20190513-095252/6322.754
> {code}
> Recommendation : some sort of unique number or string need to be appended to policy
to avoid race conditions.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message