[ https://issues.apache.org/jira/browse/TRAFODION-174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atanu Mishra closed TRAFODION-174. ---------------------------------- Resolution: Fixed > LP Bug: 1274651 - Getting TM error 97 when our tables split or get moved. > ------------------------------------------------------------------------- > > Key: TRAFODION-174 > URL: https://issues.apache.org/jira/browse/TRAFODION-174 > Project: Apache Trafodion > Issue Type: Bug > Components: dtm > Reporter: Guy Groulx > Assignee: John de Roo > Priority: Blocker > Fix For: 1.1 (pre-incubation) > > > Testing with transaction enabled. > Our system is using HortonWorks and is running HBASE 0.94 across 12 nodes. > Our hbase max store size was 1GB. > We noticed during loading of large tables, that we would get error 97 > returned from the TM and that the batch of rows were not added. > Turns out that our table was being split and that the TM is not handling this > at the moment. > We also found out that after a split, the hbase balancer would move the new > region to another region server. When this happened, we got more error 97. > WORKAROUND: > - We changed the MAX STORE SIZE to 100GB. > - We changed the SPLIT POLICY to > org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy which > causes split to happen only once the max size if reached. Default for HBASE > 0.94 and up is new POWERof2 policy which causes splits more often. > - We turned off HBASE BALANCER via hbase shell. -- This message was sent by Atlassian JIRA (v6.3.4#6332)