[ https://issues.apache.org/jira/browse/SENTRY-935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14986829#comment-14986829 ]
Lenni Kuff commented on SENTRY-935: ----------------------------------- Hi [~csun]. I'm not able to reproduce this issue. How are you creating the schema (via the upgrade scripts or using autoCreate)? > duplicate key value violates unique constraint "PRIVILEGE_INDEX" > ---------------------------------------------------------------- > > Key: SENTRY-935 > URL: https://issues.apache.org/jira/browse/SENTRY-935 > Project: Sentry > Issue Type: Bug > Reporter: Chao Sun > Fix For: 1.5.1 > > > In our test jenkins job, we would drop and recreate a "test_role" every time > the job runs. In the first few runs there's no issue. However, recently this > happened: > {code} > 06:12:50 +++ set +e > 06:12:50 +++ impala-shell.sh -q 'DROP ROLE TEST_ROLE' > 06:12:51 Starting Impala Shell without Kerberos authentication > 06:12:51 Connected to localhost.localdomain:21000 > 06:12:51 Server version: impalad version 0.2.0-cdh5 DEBUG (build > 90d65dedb26fbd49bc49134ec11c440fdff3f122) > 06:12:51 Query: drop ROLE TEST_ROLE > 06:12:51 +++ set -e > 06:12:51 +++ impala-shell.sh -q 'CREATE ROLE TEST_ROLE' > 06:12:51 Starting Impala Shell without Kerberos authentication > 06:12:51 Connected to localhost.localdomain:21000 > 06:12:51 Server version: impalad version 0.2.0-cdh5 DEBUG (build > 90d65dedb26fbd49bc49134ec11c440fdff3f122) > 06:12:51 Query: create ROLE TEST_ROLE > 06:12:51 > 06:12:51 Fetched 0 row(s) in 0.13s > 06:12:51 +++ impala-shell.sh -q 'GRANT ALL ON SERVER TO ROLE TEST_ROLE' > 06:12:52 Starting Impala Shell without Kerberos authentication > 06:12:52 Connected to localhost.localdomain:21000 > 06:12:52 Server version: impalad version 0.2.0-cdh5 DEBUG (build > 90d65dedb26fbd49bc49134ec11c440fdff3f122) > 06:12:52 Query: grant ALL ON SERVER TO ROLE TEST_ROLE > 06:12:52 ERROR: > 06:12:52 RuntimeException: Unknown error for request: > TAlterSentryRoleGrantPrivilegeRequest(protocol_version:2, > requestorUserName:jenkins, roleName:TEST_ROLE, > privileges:[TSentryPrivilege(privilegeScope:SERVER, serverName:server1, > dbName:, tableName:, URI:, action:*, createTime:1445951572120, > grantOption:FALSE, columnName:)]), message: Insert of object > "org.apache.sentry.provider.db.service.model.MSentryPrivilege@3553d094" using > statement "INSERT INTO "SENTRY_DB_PRIVILEGE" > ("DB_PRIVILEGE_ID","TABLE_NAME","CREATE_TIME","PRIVILEGE_SCOPE","URI","SERVER_NAME","COLUMN_NAME","WITH_GRANT_OPTION","DB_NAME","ACTION") > VALUES (?,?,?,?,?,?,?,?,?,?)" failed : ERROR: duplicate key value violates > unique constraint "PRIVILEGE_INDEX". Server Stacktrace: > javax.jdo.JDODataStoreException: Insert of object > "org.apache.sentry.provider.db.service.model.MSentryPrivilege@3553d094" using > statement "INSERT INTO "SENTRY_DB_PRIVILEGE" > ("DB_PRIVILEGE_ID","TABLE_NAME","CREATE_TIME","PRIVILEGE_SCOPE","URI","SERVER_NAME","COLUMN_NAME","WITH_GRANT_OPTION","DB_NAME","ACTION") > VALUES (?,?,?,?,?,?,?,?,?,?)" failed : ERROR: duplicate key value violates > unique constraint "PRIVILEGE_INDEX" > 06:12:52 at > org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451) > 06:12:52 at > org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732) > 06:12:52 at > org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752) > 06:12:52 at > org.apache.sentry.provider.db.service.persistent.SentryStore.alterSentryRoleGrantPrivilegeCore(SentryStore.java:481) > 06:12:52 at > org.apache.sentry.provider.db.service.persistent.SentryStore.alterSentryRoleGrantPrivileges(SentryStore.java:418) > 06:12:52 at > org.apache.sentry.provider.db.service.thrift.SentryPolicyStoreProcessor.alter_sentry_role_grant_privilege(SentryPolicyStoreProcessor.java:273) > 06:12:52 at > org.apache.sentry.provider.db.service.thrift.SentryPolicyService$Processor$alter_sentry_role_grant_privilege.getResult(SentryPolicyService.java:933) > 06:12:52 at > org.apache.sentry.provider.db.service.thrift.SentryPolicyService$Processor$alter_sentry_role_grant_privilege.getResult(SentryPolicyService.java:918) > 06:12:52 at > org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > 06:12:52 at > org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > 06:12:52 at > org.apache.sentry.provider.db.service.thrift.SentryProcessorWrapper.process(SentryProcessorWrapper.java:35) > 06:12:52 at > org.apache.thrift.TMultiplexedProcessor.process(TMultiplexedProcessor.java:123) > 06:12:52 at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285) > 06:12:52 at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > 06:12:52 at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > 06:12:52 at java.lang.Thread.run(Thread.java:745) > 06:12:52 NestedThrowablesStackTrace: > 06:12:52 org.postgresql.util.PSQLException: ERROR: duplicate key value > violates unique constraint "PRIVILEGE_INDEX" > 06:12:52 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) > 06:12:52 at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) > 06:12:52 at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > {code} > Not sure why this happens. I do found a page that explains what this error > means: http://hcmc.uvic.ca/blogs/index.php?blog=22&p=8105&more=1&c=1&tb=1&pb=1 -- This message was sent by Atlassian JIRA (v6.3.4#6332)