[jira] [Commented] (PHOENIX-1113) Local Index creation often fails

["rajeshbabu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14075267#comment-14075267 ] 

rajeshbabu commented on PHOENIX-1113:
-------------------------------------

[~giacomotaylor]
To ensure region co-location we need to add following parameters to hbase-site.xml at master side and restart it.
{code}
<property>
<name>hbase.master.loadbalancer.class</name>
<value>org.apache.phoenix.hbase.index.balancer.IndexLoadBalancer</value>
</property>
<property>
<name>hbase.coprocessor.master.classes</name>
<value>org.apache.phoenix.hbase.index.master.IndexMasterObserver</value>
</property>
{code}

Sorry for the inconvenience. Today I will add this to documentation and submit it.


> Local Index creation often fails
> --------------------------------
>
>                 Key: PHOENIX-1113
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1113
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.0.0, 4.1
>            Reporter: James Taylor
>            Assignee: rajeshbabu
>
> The exception below happens on create local index about 75% of the time when I try to create local index. Table is without salting/pre-splits. There are only few thousand rows in base table. Branch 4.0. Standard index works fine.
> {code}
> CREATE TABLE IF NOT EXISTS IDX_BASE (
>     HOST CHAR(2) NOT NULL,
>     DOMAIN VARCHAR NOT NULL,
>     FEATURE VARCHAR NOT NULL,
>     DATE DATE NOT NULL,
>     USAGE.CORE BIGINT,
>     USAGE.DB BIGINT,
>     STATS.ACTIVE_VISITOR INTEGER,
>     CONSTRAINT PK PRIMARY KEY (HOST, DOMAIN, FEATURE, DATE))
> CREATE LOCAL INDEX idx1 ON IDX_BASE(DB);
> {code}
> Exception:
> {code}
> Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException: org.apache.hadoop.hbase.DoNotRetryIOException: ​IDX_BASE​,,1406330792160.61ad35ea050c1c793961d58534e564dc.: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:77)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:45)
> at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:73)
> at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1663)
> at org.apache.hadoop.hbase.regionserver.HRegionServer.scan(HRegionServer.java:3071)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29497)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2012)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:98)
> 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:619)
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.commitBatch(UngroupedAggregateRegionObserver.java:125)
> at org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:367)
> at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:71)
> ... 9 more
> at org.apache.hadoop.hbase.ipc.RpcClient.call(RpcClient.java:1452)
> at org.apache.hadoop.hbase.ipc.RpcClient.callBlockingMethod(RpcClient.java:1656)
> at org.apache.hadoop.hbase.ipc.RpcClient$BlockingRpcChannelImplementation.callBlockingMethod(RpcClient.java:1714)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:29900)
> at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:308)
> ... 17 more
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)