Hi Qiao,
If you go into the hbase shell, and do the following: scan “TRAFODION._MD_.VERSIONS” What happens? If HBase is up and working correctly, and if nothing has been corrupted, this should return 3 rows. Dave *From:* 乔彦克 [mailto:qya...@gmail.com] *Sent:* Wednesday, September 21, 2016 8:13 PM *To:* user@trafodion.incubator.apache.org *Cc:* dev <d...@trafodion.incubator.apache.org> *Subject:* Re: Trafodion meta table region in hbase cannot be opened I tried to assign the region by hand in hbase shell, but still cannot open regions. Below is the log errors while do some basic query. SQL>get tables; *** ERROR[1398] Error -704 occured while accessing the hbase subsystem. Fix that error and make sure hbase is up and running. Error Details: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=21, exceptions: Thu Sep 22 10:26:02 CST 2016, null, java.net.SocketTimeoutException: callTimeout=600000, callDuration=792843: row '' on table 'TRAFODION._MD_.VERSIONS' at region=TRAFODION._MD_.VERSIONS,,1474445084590.0350ce973b1e43e17b2d14ec72b7f867., hostname=hadoop2slave7,60020,1474442934725, seqNum=2 org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.throwEnrichedException(RpcRetryingCallerWithReadReplicas.java:270) org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:203) org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:57) org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200) org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:294) org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:269) org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction(ClientScanner.java:141) org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientScanner.java:136) org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:886) org.apache.hadoop.hbase.client.transactional.TransactionalTable.getScanner(TransactionalTable.java:813) org.apache.hadoop.hbase.client.transactional.RMInterface.getScanner(RMInterface.java:428) org.trafodion.sql.HTableClient.startScan(HTableClient.java:983) . [2016-09-22 11:09:54] Best regards, Qiao 乔彦克 <qya...@gmail.com>于2016年9月22日周四 上午11:07写道： Hi, deal group, Yesterday after I restarted the HBase regionservers(cause one is down, I want to restart all the regionservers for load balance), there are 7 Trafodion table regions cannot be opened. And I cannot log in to the Trafodion shell using 'trafci'. Does anyone get stuck by this problem ever? How Can I recover my trafodion to normal state? [image: region not open.png] Any reply is appreciated. Thanks, Qiao
