[jira] [Work started] (TRAFODION-1696) drop authorization doesn't drop all roles, and create role will run into internal error

["Roberta Marton (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TRAFODION-1696 started by Roberta Marton.
-------------------------------------------------
> 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
>            Assignee: Roberta Marton
>
> >>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)