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

Reply via email to