sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arun Suresh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SENTRY-668) Duplicate Entry error when granting privileges
Date Tue, 10 Mar 2015 22:03:38 GMT

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

Arun Suresh commented on SENTRY-668:
------------------------------------

Closing.. since this is fixed by SENTRY-549

> Duplicate Entry error when granting privileges
> ----------------------------------------------
>
>                 Key: SENTRY-668
>                 URL: https://issues.apache.org/jira/browse/SENTRY-668
>             Project: Sentry
>          Issue Type: Bug
>            Reporter: Arun Suresh
>
> Steps to reproduce : 
> {noformat}
> drop database IF EXISTS SentryHDFSBoundaryTestDB CASCADE;
> create database SentryHDFSBoundaryTestDB;
> drop table IF EXISTS boundary_test_table;
> create table boundary_test_table (s string);
> drop role boundary_test_role;
> create role boundary_test_role;
> grant select on table boundary_test_table to role boundary_test_role;
> drop table IF EXISTS boundary_test_table;
> create table boundary_test_table (s string);
> grant select on table BOUNDARY_TEST_TABLE to role boundary_test_role;
> then an exception gets threw:
> 2015-01-23 13:31:18,601 (main) [ERROR - org.apache.sentry.tests.e2e.unmanagedclustertests.SentryJdbc2Client.logExDetails(SentryJdbc2Client.java:77)]
[Extra Message] java.sql.SQLException: Error while processing statement: FAILED: Execution
Error, return code 1 from org.apache.hadoop.hive.ql.exec.SentryGrantRevokeTask. Unknown error
for request: TAlterSentryRoleGrantPrivilegeRequest(protocol_version:1, requestorUserName:hive,
roleName:boundary_test_role, privilege:TSentryPrivilege(privilegeScope:TABLE, serverName:server1,
dbName:SentryHDFSBoundaryTestDB, tableName:boundary_test_table, URI:, action:SELECT, createTime:1422048678527,
grantOption:FALSE)), message: Insert of object "org.apache.sentry.provider.db.service.model.MSentryPrivilege@387e71a6"
using statement "INSERT INTO `SENTRY_DB_PRIVILEGE` (`DB_PRIVILEGE_ID`,`PRIVILEGE_SCOPE`,`WITH_GRANT_OPTION`,`CREATE_TIME`,`TABLE_NAME`,`URI`,`DB_NAME`,`SERVER_NAME`,`ACTION`)
VALUES (?,?,?,?,?,?,?,?,?)" failed : Duplicate entry 'server1-sentryhdfsboundarytestdb-boundary_test_table-__NULL__-se'
for key 'SENTRY_DB_PRIV_PRIV_NAME_UNIQ'. Server Stacktrace: javax.jdo.JDODataStoreException:
Insert of object "org.apache.sentry.provider.db.service.model.MSentryPrivilege@387e71a6" using
statement "INSERT INTO `SENTRY_DB_PRIVILEGE` (`DB_PRIVILEGE_ID`,`PRIVILEGE_SCOPE`,`WITH_GRANT_OPTION`,`CREATE_TIME`,`TABLE_NAME`,`URI`,`DB_NAME`,`SERVER_NAME`,`ACTION`)
VALUES (?,?,?,?,?,?,?,?,?)" failed : Duplicate entry 'server1-sentryhdfsboundarytestdb-boundary_test_table-__NULL__-se'
for key 'SENTRY_DB_PRIV_PRIV_NAME_UNIQ'
>         at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)
>         at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)
>         at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message