Gao, Rui-Xian created TRAFODION-1696:
----------------------------------------
Summary: drop authorization doesn't drop all roles, and create
role will run into internal error
Key: TRAFODION-1696
URL: https://issues.apache.org/jira/browse/TRAFODION-1696
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Affects Versions: 2.0-incubating
Environment: os: suse11
esgynDB version: esgynDB-20151119_0900-bin
Reporter: Gao, Rui-Xian
>>initialize authorization,drop;
--- SQL operation complete.
Roles
=====
A19ROLE1
DB__HBASEROLE
DB__HIVEROLE
DB__ROOTROLE
GROBJ_A37ROLE1
GROBJ_A37ROLE2
GROBJ_A42ROLE1
GROBJ_A47ROLE1
GROBJ_A47ROLE2
QAUSER_1012345678201234567830123456784012345678501234567860123456787012345678801234567890123456710012345671101234567120123456129
RER_A18ROLE2
RER_A19ROLE1
RER_A20ROLE1
RER_A20ROLE2
RER_A24ROLE2
>>create role auth_role1;
*** ERROR[8448] Unable to access Hbase interface. Call to
ExpHbaseInterface::checkAndInsertRow returned error HBASE_ACCESS_ERROR(-706).
Cause:
org.apache.hadoop.hbase.TableNotFoundException:
TRAFODION._PRIVMGR_MD_.ROLE_USAGE
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1298)
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1126)
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1110)
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1067)
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:902)
org.apache.hadoop.hbase.client.HTable.getRegionLocation(HTable.java:558)
org.apache.hadoop.hbase.client.transactional.TransactionalTable.getRegionLocation(TransactionalTable.java:907)
org.apache.hadoop.hbase.client.transactional.RMInterface.registerTransaction(RMInterface.java:368)
org.apache.hadoop.hbase.client.transactional.RMInterface.registerTransaction(RMInterface.java:410)
org.apache.hadoop.hbase.client.transactional.RMInterface.checkAndPut(RMInterface.java:727)
org.trafodion.sql.HTableClient.putRow(HTableClient.java:1204)
org.trafodion.sql.HBaseClient.insertRow(HBaseClient.java:1505)
.
*** ERROR[1001] An internal error occurred in module
../sqlcomp/CmpSeabaseDDLauth.cpp on line 1385. DETAILS(Unable to grant role to
role administrator).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
