Arun Suresh created SENTRY-668:
----------------------------------
Summary: 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)
