[
https://issues.apache.org/jira/browse/TRAFODION-188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696264#comment-14696264
]
Atanu Mishra commented on TRAFODION-188:
----------------------------------------
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-05-19: #1
Verified on the datalake v40646 build. This problem has been fixed:
>>create table t0 (a int not null not droppable, b int, c int, primary key (a))
>>salt using 12 partitions;
--- SQL operation complete.
>>
>>create table t1 (a int not null not droppable, b int, c int, primary key (a))
>>salt using 12 partitions;
--- SQL operation complete.
>>
>>create table t2 (a int not null not droppable, b int, c int, primary key (a))
>>salt using 12 partitions;
--- SQL operation complete.
>>
>>create table t6 (a int not null not droppable, b int, c int, primary key (a))
>>salt using 12 partitions;
--- SQL operation complete.
>>
>>create table t8 (a int not null not droppable, b int, c int, primary key (a))
>>salt using 12 partitions;
--- SQL operation complete.
>>
>>create table cube1
+>(a int not null not droppable,
+>b int not null not droppable,
+>c int not null not droppable,
+>d int, e int, f int, txt char(100),
+>primary key (a,b,c))
+>store by primary key salt using 12 partitions;
--- SQL operation complete.
>>
>>insert into t0 values
>>(0,0,0),(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),(6,6,6),(7,7,7),(8,8,8),(9,9,9);
--- 10 row(s) inserted.
>>
>>upsert using load into t1 select * from t0;
--- 10 row(s) inserted.
>>
>>upsert using load into t2 select * from t0;
--- 10 row(s) inserted.
>>
>>upsert using load into t6 select t1.a+10*t2.a,t1.a,t2.a from t1,t2;
--- 100 row(s) inserted.
>>
>>upsert using load into t8 select t6.a+100*t1.a,t6.a,t1.a from t1,t6;
--- 1000 row(s) inserted.
>>
>>insert into cube1 select t1.a, t6.a, t8.a, t1.a, t6.a, t8.a, 'some text' from
>>t1, t6, t8 where t8.a < 100;
--- 100000 row(s) inserted.
Changed in trafodion:
status: New → Fix Released
Weishiun Tsai (wei-shiun-tsai) on 2014-05-19
summary: - Insert..select returns HBASE_ACCSES_ERROR(-705) and then TMF
error 97 in
+ Insert..select returns HBASE_ACCESS_ERROR(-705) and then TMF error 97 in
org.apache.hadoop.hbase.regionserver.transactional
> LP Bug: 1286349 - Insert..select returns HBASE_ACCESS_ERROR(-705) and then
> TMF error 97 in org.apache.hadoop.hbase.regionserver.transactional
> ---------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-188
> URL: https://issues.apache.org/jira/browse/TRAFODION-188
> Project: Apache Trafodion
> Issue Type: Bug
> Components: dtm
> Reporter: Weishiun Tsai
> Priority: Critical
>
> A insert..select statement returns HBASE_ACCSES_ERROR(-705) in
> org.apache.hadoop.hbase.regionserver.transactional and then TMF error 97
> afterwards, as shown here. This problem is fairly reproducible now with the
> QA test to create and populate hcubedb through sqlci/JDBC. This may or may
> not be related to https://bugs.launchpad.net/trafodion/+bug/1274716 “Getting
> TM error 97 for INSERT SELECT <hive table>”. In this case, all tables from
> the select list are Trafodion/hbase tables, but in the other case, the select
> table is a hive table. For now, we use this case to track the problem
> separately.
> SQL>insert into cube1 select t1.a, t6.a, t8.a, t1.a, t6.a, t8.a, 'some text'
> from t1, t6, t8 where t8.a < 100;
> *** ERROR[8448] Unable to access Hbase interface. Call to
> ExpHbaseInterface::rowExists returned error HBASE_ACCESS_ERROR(-705). Cause:
> org.apache.hadoop.hbase.client.transactional.UnknownTransactionException:
> org.apache.hadoop.hbase.client.transactional.UnknownTransactionException:
> transaction: [4294996353], region:
> [TRAFODION.G_HCUBEDB.CUBE1,,1393442223602.979ac8a950b9df29d1ab4832dd9acb37.]
> at
> org.apache.hadoop.hbase.regionserver.transactional.TransactionalRegion.getTransactionState(TransactionalRegion.java:741)
> at
> org.apache.hadoop.hbase.regionserver.transactional.TransactionalRegion.checkAndPut(TransactionalRegion.java:941)
> at
> org.apache.hadoop.hbase.regionserver.transactional.TransactionalRegionServer.checkAndPut(TransactionalRegionServer.java:449)
> at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
> at
> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428)
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:90)
> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:79)
> org.apache.hadoop.hbase.client.ServerCallable.translateException(ServerCallable.java:228)
> org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:166)
> org.apache.hadoop.hbase.client.transactional.TransactionalTable.checkAndPut(TransactionalTable.java:212)
> org.apache.hadoop.hbase.client.transactional.RMInterface.checkAndPut(RMInterface.java:164)
> org.trafodion.sql.HBaseAccess.HTableClient.checkAndInsertRow(HTableClient.java:537)
> . [2014-02-26 11:36:31]
> *** ERROR[8610] Transaction subsystem TMF reported error 97 on a waited
> rollback transaction. [2014-02-26 11:36:31]
> This problem has been reproduced on rhel-cdh1 with the following TM tracing
> and hbase tracing turned on. Narendra has collected the tracing info for
> further debugging.
> 1) Change the logging threshold of the HBase Region Server from ‘INFO’ to
> ‘DEBUG’: Via the Cloudera Manager:
> i. Click on HBase
> Service->Configuration tab -> ‘View and Edit’
> 1. Click on RegionServer -> Logs -> Logging Threshold to ‘DEBUG’
> ii. Restart HBase
> 2) Trace the Trafodion TM:
> a. In sqf/etc/ms.env (then pdcp to all the nodes):
> # DTM Tracing. To enable standard tracing uncomment the following lines.
> TM_TRACE=1
> HBASE_TRACE=0xf
> TM_TRACE_DETAIL=3
> TM_TRACE_UNIQUE=1
> TM_TRACE_FILE=zzttm.
> b. Restart SQ
> 3) In the file $MY_SQROOT/logs/log4j.dtm.config (all nodes, log file:
> $MY_SQROOT/sql/scripts/trafodion.dtm.log):
> log4j.logger.org.trafodion.dtm=TRACE (change it from DEBUG to TRACE)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
