[
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)
