[
https://issues.apache.org/jira/browse/TRAFODION-1696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gao, Rui-Xian updated TRAFODION-1696:
-------------------------------------
Description:
>>initialize authorization,drop;
--- SQL operation complete.
>>get roles;
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).
was:
>>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).
> 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.
> >>get roles;
> 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)
