phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Leech <jonat...@gmail.com>
Subject Re: Rebuilding phoenix index
Date Thu, 21 Apr 2016 03:15:26 GMT
Can you check to make sure that the local index regions are colocated with the base regions
of the table?



> On Apr 20, 2016, at 7:47 PM, Michal Medvecky <medvecky@pexe.so> wrote:
> 
> Hello,
> 
> 0: jdbc:phoenix> drop index idx_media_next_update_at ON media;
> Error: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.: null
>         at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>         at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>         at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>         at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>         at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException (state=08000,code=101)
> org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: _LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.:
null
>         at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>         at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>         at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>         at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>         at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException
> 
>         at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
>         at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:558)
>         at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50)
>         at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97)
>         at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117)
>         at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64)
>         at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39)
>         at org.apache.phoenix.compile.PostDDLCompiler$1.execute(PostDDLCompiler.java:228)
>         at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2132)
>         at org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:2264)
>         at org.apache.phoenix.schema.MetaDataClient.dropIndex(MetaDataClient.java:2130)
>         at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDropIndexStatement$1.execute(PhoenixStatement.java:921)
>         at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:322)
>         at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:314)
>         at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>         at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:313)
>         at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1435)
>         at sqlline.Commands.execute(Commands.java:822)
>         at sqlline.Commands.sql(Commands.java:732)
>         at sqlline.SqlLine.dispatch(SqlLine.java:808)
>         at sqlline.SqlLine.begin(SqlLine.java:681)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
> Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: _LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.:
null
>         at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>         at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>         at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>         at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>         at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException
> 
>         at java.util.concurrent.FutureTask.report(FutureTask.java:122)
>         at java.util.concurrent.FutureTask.get(FutureTask.java:206)
>         at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:554)
>         ... 21 more
> Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.: null
>         at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>         at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>         at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>         at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>         at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException
> 
>         at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
>         at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:70)
>         at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:88)
>         at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:79)
>         at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:105)
>         at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:100)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>         at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.: null
>         at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>         at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>         at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>         at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>         at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException
> 
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>         at org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
>         at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
>         at org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:322)
>         at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:380)
>         at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199)
>         at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62)
>         at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
>         at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:369)
>         at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:343)
>         at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
>         at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64)
>         ... 3 more
> Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException):
org.apache.hadoop.hbase.DoNotRetryIOException: _LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.:
null
>         at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>         at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>         at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>         at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>         at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>         at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException
> 
>         at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1196)
>         at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213)
>         at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287)
>         at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651)
>         at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372)
>         ... 10 more
> 
> Michal
> 
>> On Wed, Apr 20, 2016 at 6:24 PM, James Taylor <jamestaylor@apache.org> wrote:
>> Hi Michal,
>> As a workaround for the issue you're encountering, can dropping the index and then
issuing your create index DDL statement over again? If you have a minute to file a JIRA on
this, that'd be much appreciated.
>> Thanks,
>> James
>> 
>>> On Wed, Apr 20, 2016 at 5:45 PM, Michal Medvecky <medvecky@pexe.so> wrote:
>>> Hello,
>>> 
>>> my hbase cluster was damaged by network outages in AWS. Now I cannot select some
data from my tables:
>>> 
>>> 0: jdbc:phoenix> select id from media where id like '%fhCch_Y8la8%';
>>> +------------------------------------------+
>>> |                    ID                    |
>>> +------------------------------------------+
>>> java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.: null
>>> 	at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>>> 	at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>>> 	at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$2.nextRaw(BaseScannerRegionObserver.java:360)
>>> 	at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
>>> 	at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2420)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>>> 	at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>>> 	at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.lang.NullPointerException
>>> 
>>> 	at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
>>> 	at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
>>> 	at sqlline.SqlLine.print(SqlLine.java:1653)
>>> 	at sqlline.Commands.execute(Commands.java:833)
>>> 	at sqlline.Commands.sql(Commands.java:732)
>>> 	at sqlline.SqlLine.dispatch(SqlLine.java:808)
>>> 	at sqlline.SqlLine.begin(SqlLine.java:681)
>>> 	at sqlline.SqlLine.start(SqlLine.java:398)
>>> 	at sqlline.SqlLine.main(SqlLine.java:292)
>>> 0: jdbc:phoenix> Closing: org.apache.phoenix.jdbc.PhoenixConnection
>>> 
>>> Seems that phoenix index is broken, but when trying to recreate it, I get:
>>> 
>>> 0: jdbc:phoenix> alter index idx_media_next_update_at on MEDIA REBUILD;
>>> Error: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.: null
>>> 	at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>>> 	at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>>> 	at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>>> 	at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>>> 	at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>>> 	at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.lang.NullPointerException (state=08000,code=101)
>>> org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: _LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.:
null
>>> 	at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>>> 	at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>>> 	at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>>> 	at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>>> 	at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>>> 	at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.lang.NullPointerException
>>> 
>>> 	at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
>>> 	at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:558)
>>> 	at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50)
>>> 	at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97)
>>> 	at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117)
>>> 	at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64)
>>> 	at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39)
>>> 	at org.apache.phoenix.compile.PostDDLCompiler$1.execute(PostDDLCompiler.java:228)
>>> 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2132)
>>> 	at org.apache.phoenix.schema.MetaDataClient.alterIndex(MetaDataClient.java:3005)
>>> 	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAlterIndexStatement$1.execute(PhoenixStatement.java:962)
>>> 	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:322)
>>> 	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:314)
>>> 	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>>> 	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:313)
>>> 	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1435)
>>> 	at sqlline.Commands.execute(Commands.java:822)
>>> 	at sqlline.Commands.sql(Commands.java:732)
>>> 	at sqlline.SqlLine.dispatch(SqlLine.java:808)
>>> 	at sqlline.SqlLine.begin(SqlLine.java:681)
>>> 	at sqlline.SqlLine.start(SqlLine.java:398)
>>> 	at sqlline.SqlLine.main(SqlLine.java:292)
>>> Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: _LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.:
null
>>> 	at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>>> 	at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>>> 	at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>>> 	at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>>> 	at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>>> 	at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.lang.NullPointerException
>>> 
>>> 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
>>> 	at java.util.concurrent.FutureTask.get(FutureTask.java:206)
>>> 	at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:554)
>>> 	... 20 more
>>> Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.: null
>>> 	at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>>> 	at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>>> 	at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>>> 	at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>>> 	at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>>> 	at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.lang.NullPointerException
>>> 
>>> 	at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
>>> 	at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:70)
>>> 	at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:88)
>>> 	at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:79)
>>> 	at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:105)
>>> 	at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:100)
>>> 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> 	at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
>>> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
_LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.: null
>>> 	at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>>> 	at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>>> 	at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>>> 	at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>>> 	at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>>> 	at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.lang.NullPointerException
>>> 
>>> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>>> 	at org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
>>> 	at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
>>> 	at org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:322)
>>> 	at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:380)
>>> 	at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199)
>>> 	at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62)
>>> 	at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
>>> 	at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:369)
>>> 	at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:343)
>>> 	at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
>>> 	at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64)
>>> 	... 3 more
>>> Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException):
org.apache.hadoop.hbase.DoNotRetryIOException: _LOCAL_IDX_MEDIA,\x04VkV6,1461181689836.2ee0eac45800bb1f76ef5e28936972d8.:
null
>>> 	at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
>>> 	at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
>>> 	at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:206)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1351)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperationWithResult(RegionCoprocessorHost.java:1747)
>>> 	at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1346)
>>> 	at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2273)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32385)
>>> 	at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117)
>>> 	at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
>>> 	at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
>>> 	at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.lang.NullPointerException
>>> 
>>> 	at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1196)
>>> 	at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213)
>>> 	at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287)
>>> 	at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651)
>>> 	at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372)
>>> 	... 10 more
>>> 
>>> 
>>> Can you please help me explaining/fixing this issue?
>>> 
>>> I'm using hbase 1.1.3 and phoenix 4.6.0
>>> 
>>> Thanks
>>> 
>>> Michal
> 

Mime
View raw message