Thanks for your reply, Dave.
Scan for  "TRAFODION._MD_.VERSIONS"  doesn't work beacuse the table's
region is not online and cannot be assigned.
I have nothing to do but delete all Trafodion tables in HBase and after the
clearing work, I restart all the service, then the system gets Ok to work.
I've get stuck by such problem several times due to the region failed to
open. there maybe have some bugs when loading data to Trafodion from Hive,
I don't know quite clear.

Best Regards,
Qiao

Dave Birdsall <dave.birds...@esgyn.com>于2016年9月22日周四 下午11:52写道:

> 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:* u...@trafodion.incubator.apache.org
> *Cc:* dev <dev@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
>

Reply via email to