[jira] [Created] (TRAFODION-187) LP Bug: 1286342 - Drop table sees TMF error 97

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-187:
------------------------------------

             Summary: LP Bug: 1286342 - Drop table sees TMF error 97
                 Key: TRAFODION-187
                 URL: https://issues.apache.org/jira/browse/TRAFODION-187
             Project: Apache Trafodion
          Issue Type: Bug
          Components: dtm
            Reporter: Weishiun Tsai
            Assignee: John de Roo
            Priority: Critical


Phoenix tests have run into this problem occasionally.  The symptom is that dropping a table would return TMF error 97, like the following example:

test.java.com.hp.phoenix.end2end.IndexTest
...*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction. [2014-02-28 09:56:24]
E.E
Time: 50.004
There were 2 failures:
1) testImmutableTableIndexMaintanenceSalted(test.java.com.hp.phoenix.end2end.IndexTest)
java.lang.AssertionError: Failed to drop object: table t
        at org.junit.Assert.fail(Assert.java:88)
        at test.java.com.hp.phoenix.end2end.BaseTest.dropTestObjects(BaseTest.java:180)
        at test.java.com.hp.phoenix.end2end.BaseTest.doBaseTestCleanup(BaseTest.java:112)

Unfortunately, this problem can’t be easily reproduced.  We have tried to turn on both the hbase tracing and the TM tracing on the cluster rhel-cdh1 per Narendra’s request.  But the tracing has changed the timing and we have not been able to reproduce it on rhel-cdh1 since, even though the problem continues to be seen on other clusters without the tracing turned on.  This case is created to track this problem and to continue monitoring the issue.

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)