hi Jeffrey, that was the only error i saw in the regionserver logs,
after the exception i made a count on index table and the main table , both counts are equal and whenever i update some values in main table, index is getting updated describe of main table on hbase shell gives the phoenix index coprocessor details. evenafter getting the errorcode index is working, i don't understand this behavior. as the index table is getting larger and larger while indexing, it is compacting as well, any suggestions? thanks, yeshwanth On Wed, Aug 13, 2014 at 1:23 AM, Jeffrey Zhong <[email protected]> wrote: > > > 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.0158a3bd2e191361e2950ae3eb0 > a9016. is closing > at > org.apache.hadoop.hbase.regionserver.HRegion.startRegionOperation(HRegion.java:5742) > at > org.apache.hadoop.hbase.regionserver.HRegion.startRegionOperation(HRegion.java:5706) > at > org.apache.hadoop.hbase.regionserver.HRegion.getRowLock(HRegion.java:3438) > at > org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.java: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.java: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.callBlockingMethod(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(SimpleRpcScheduler.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.
