phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeffrey Zhong <jzh...@hortonworks.com>
Subject Re: Error: (state=08000,code=101) while indexing
Date Tue, 12 Aug 2014 19:53:31 GMT


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 <yeshwanth43@gmail.com>
Reply-To:  <user@phoenix.apache.org>
Date:  Tuesday, August 12, 2014 at 4:16 AM
To:  <user@phoenix.apache.org>
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.

Mime
View raw message