现象
在Trafodion中执行某些SQL动作时,报以下错误,
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::getRowOpen returned error HBASE_OPEN_ERROR(-704). Cause: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after atte mpts=3, exceptions:
Mon Aug 07 13:38:46 CST 2017, RpcRetryingCaller{globalStartTime=1502084326590, pause=100, retries=3}, org.apache.hadoop.hbase.NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Regio n TRAFODION._MD_.TABLES,,1470909191463.db08347d1857af2e0bf3b46e5a54f5e8. is not online on n10.trafodion.local,60020,1502084156878
分析
上述错误,显示Region xxx不在n10.trafodion.local这个RegionServer上,所以估计是因为某种原因原本在n10上面的Region xxx被Move到其他节点了,通过HBase Master 60010页面查看,上述Region确实已经不在n10节点。
解决
通过HBase Shell,手动Move上述Region到n10节点,如下,
hbase(main):002:0> move 'db08347d1857af2e0bf3b46e5a54f5e8','n10.trafodion.local,60020,1502084156878'
0 row(s) in 2.1220 seconds
再次通过60010页面查看Region所在的位置,