In normal case underlying hbase client will retry(managed by configuration setting hbase.client.retries.number and its default value=31) for errors you pasted below. Therefore, the operation normally will succeed after retries unless you see RetriesExhaustedException. Is the only error you saw around that time or the index region couldn¹t be re-opened from some reason?
-Jeffrey From: yeshwanth kumar <[email protected]> Reply-To: <[email protected]> Date: Tuesday, August 12, 2014 at 4:16 AM To: <[email protected]> Subject: Error: (state=08000,code=101) while indexing hi i am running a single node hortonworks HDP2.1 i have 150Million rows in a table, while indexing the table on a column, it is giving the error 0: jdbc:phoenix:localhost:/hbase-unsecure> CREATE INDEX INDEX_MONTHS ON MONTHS_DATA (VCOUNT); Error: (state=08000,code=101) i increased the phoenix keepalive and querytimeout to 1hr anypointers how to overcome this issue? in regionserver logs i see this exception, org.apache.hadoop.hbase.NotServingRegionException: INDEX_MONTHS,\x80\x00\x80\x00\x00\x00\x00\x0F\xB1\x0D03/3,1407840676629.0158 a3bd2e191361e2950ae3eb0 a9016. is closing at org.apache.hadoop.hbase.regionserver.HRegion.startRegionOperation(HRegion.ja va:5742) at org.apache.hadoop.hbase.regionserver.HRegion.startRegionOperation(HRegion.ja va:5706) at org.apache.hadoop.hbase.regionserver.HRegion.getRowLock(HRegion.java:3438) at org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.jav a:2323) at org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2190) at org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2142) at org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2146) at org.apache.hadoop.hbase.regionserver.HRegionServer.doBatchOp(HRegionServer.j ava:4240) at org.apache.hadoop.hbase.regionserver.HRegionServer.doNonAtomicRegionMutation (HRegionServer.java:3463) at org.apache.hadoop.hbase.regionserver.HRegionServer.multi(HRegionServer.java: 3367) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.call BlockingMethod(ClientProtos.java:28867) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2008) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:92) at org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.consumerLoop(SimpleRpcSchedul er.java:160) at org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.access$000(SimpleRpcScheduler .java:38) at org.apache.hadoop.hbase.ipc.SimpleRpcScheduler$1.run(SimpleRpcScheduler.java :110) at java.lang.Thread.run(Thread.java:744) thanks, yeshwanth -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
