[
https://issues.apache.org/jira/browse/PHOENIX-3828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16772646#comment-16772646
]
MariaCarrie commented on PHOENIX-3828:
--------------------------------------
I had a similar problem with the local index, but rows on the index table is
not the same as rows on the original table,
^select * from dop_visit_event_info where dop_visit_referchannelcode = 'gRd4x'
limit 10^
0: jdbc:phoenix:> select * from dop_visit_event_info where
dop_visit_referchannelcode = 'gRd4xWQv' limit 10 ;
Error: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.exceptions.ScannerResetException: Scanner is closed on
the server-side
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3456)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42002)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:409)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:131)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:324)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:304)
Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException: Requested
row out of range for Get on HRegion DOP_VISIT_EVENT_INFO,2018-11-29
10:53:10|000000769457596000001816618482000001787755309,1547800190431.7771d67c58c34b8a0338fa7e831d32b8.,
startKey='2018-11-29 10:53:10|000000769457596000001816618482000001787755309',
getEndKey()='2019-01-04
07:20:17.817|000001583257312000001264648896000001787755309', row='2019-01-05
21:19:53.993|000000802429641000001710557138000000027987072'
at org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5595)
at org.apache.hadoop.hbase.regionserver.HRegion.prepareGet(HRegion.java:7194)
at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:7187)
at org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:514)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:197)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:274)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3136)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3373)
... 5 more (state=08000,code=101)
org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.exceptions.ScannerResetException: Scanner is closed on
the server-side
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3456)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42002)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:409)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:131)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:324)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:304)
Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException: Requested
row out of range for Get on HRegion DOP_VISIT_EVENT_INFO,2018-11-29
10:53:10|000000769457596000001816618482000001787755309,1547800190431.7771d67c58c34b8a0338fa7e831d32b8.,
startKey='2018-11-29 10:53:10|000000769457596000001816618482000001787755309',
getEndKey()='2019-01-04
07:20:17.817|000001583257312000001264648896000001787755309', row='2019-01-05
21:19:53.993|000000802429641000001710557138000000027987072'
at org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5595)
at org.apache.hadoop.hbase.regionserver.HRegion.prepareGet(HRegion.java:7194)
at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:7187)
at org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:514)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:197)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:274)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3136)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3373)
... 5 more
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:138)
at
org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1297)
at
org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1239)
at
org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
at
org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
at
org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44)
at
org.apache.phoenix.iterate.LimitingResultIterator.next(LimitingResultIterator.java:47)
at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:805)
at sqlline.BufferedRows.<init>(BufferedRows.java:37)
at sqlline.SqlLine.print(SqlLine.java:1660)
at sqlline.Commands.execute(Commands.java:833)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:813)
at sqlline.SqlLine.begin(SqlLine.java:686)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:291)
Caused by: java.util.concurrent.ExecutionException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.exceptions.ScannerResetException: Scanner is closed on
the server-side
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3456)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42002)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:409)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:131)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:324)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:304)
Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException: Requested
row out of range for Get on HRegion DOP_VISIT_EVENT_INFO,2018-11-29
10:53:10|000000769457596000001816618482000001787755309,1547800190431.7771d67c58c34b8a0338fa7e831d32b8.,
startKey='2018-11-29 10:53:10|000000769457596000001816618482000001787755309',
getEndKey()='2019-01-04
07:20:17.817|000001583257312000001264648896000001787755309', row='2019-01-05
21:19:53.993|000000802429641000001710557138000000027987072'
at org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5595)
at org.apache.hadoop.hbase.regionserver.HRegion.prepareGet(HRegion.java:7194)
at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:7187)
at org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:514)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:197)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:274)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3136)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3373)
... 5 more
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:1292)
... 14 more
Caused by: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.exceptions.ScannerResetException: Scanner is closed on
the server-side
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3456)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42002)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:409)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:131)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:324)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:304)
Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException: Requested
row out of range for Get on HRegion DOP_VISIT_EVENT_INFO,2018-11-29
10:53:10|000000769457596000001816618482000001787755309,1547800190431.7771d67c58c34b8a0338fa7e831d32b8.,
startKey='2018-11-29 10:53:10|000000769457596000001816618482000001787755309',
getEndKey()='2019-01-04
07:20:17.817|000001583257312000001264648896000001787755309', row='2019-01-05
21:19:53.993|000000802429641000001710557138000000027987072'
at org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5595)
at org.apache.hadoop.hbase.regionserver.HRegion.prepareGet(HRegion.java:7194)
at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:7187)
at org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:514)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:197)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:274)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3136)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3373)
... 5 more
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:138)
at
org.apache.phoenix.iterate.TableResultIterator.next(TableResultIterator.java:172)
at
org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadResultIterator.java:47)
at
org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultIterator.java:59)
at
org.apache.phoenix.iterate.LookAheadResultIterator.peek(LookAheadResultIterator.java:73)
at
org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:135)
at
org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:120)
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:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.exceptions.ScannerResetException: Scanner is closed on
the server-side
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3456)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42002)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:409)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:131)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:324)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:304)
Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException: Requested
row out of range for Get on HRegion DOP_VISIT_EVENT_INFO,2018-11-29
10:53:10|000000769457596000001816618482000001787755309,1547800190431.7771d67c58c34b8a0338fa7e831d32b8.,
startKey='2018-11-29 10:53:10|000000769457596000001816618482000001787755309',
getEndKey()='2019-01-04
07:20:17.817|000001583257312000001264648896000001787755309', row='2019-01-05
21:19:53.993|000000802429641000001710557138000000027987072'
at org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5595)
at org.apache.hadoop.hbase.regionserver.HRegion.prepareGet(HRegion.java:7194)
at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:7187)
at org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:514)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:197)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:274)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3136)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3373)
... 5 more
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:138)
at
org.apache.phoenix.iterate.ScanningResultIterator.next(ScanningResultIterator.java:153)
at
org.apache.phoenix.iterate.TableResultIterator.next(TableResultIterator.java:165)
... 10 more
Caused by: org.apache.hadoop.hbase.exceptions.ScannerResetException:
org.apache.hadoop.hbase.exceptions.ScannerResetException: Scanner is closed on
the server-side
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3456)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42002)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:409)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:131)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:324)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:304)
Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException: Requested
row out of range for Get on HRegion DOP_VISIT_EVENT_INFO,2018-11-29
10:53:10|000000769457596000001816618482000001787755309,1547800190431.7771d67c58c34b8a0338fa7e831d32b8.,
startKey='2018-11-29 10:53:10|000000769457596000001816618482000001787755309',
getEndKey()='2019-01-04
07:20:17.817|000001583257312000001264648896000001787755309', row='2019-01-05
21:19:53.993|000000802429641000001710557138000000027987072'
at org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5595)
at org.apache.hadoop.hbase.regionserver.HRegion.prepareGet(HRegion.java:7194)
at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:7187)
at org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:514)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:197)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:274)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3136)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3373)
... 5 more
at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at
org.apache.hadoop.hbase.ipc.RemoteWithExtrasException.instantiateException(RemoteWithExtrasException.java:100)
at
org.apache.hadoop.hbase.ipc.RemoteWithExtrasException.unwrapRemoteException(RemoteWithExtrasException.java:90)
at
org.apache.hadoop.hbase.shaded.protobuf.ProtobufUtil.makeIOExceptionOfException(ProtobufUtil.java:359)
at
org.apache.hadoop.hbase.shaded.protobuf.ProtobufUtil.handleRemoteException(ProtobufUtil.java:347)
at
org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:344)
at
org.apache.hadoop.hbase.client.ScannerCallable.rpcCall(ScannerCallable.java:242)
at
org.apache.hadoop.hbase.client.ScannerCallable.rpcCall(ScannerCallable.java:58)
at
org.apache.hadoop.hbase.client.RegionServerCallable.call(RegionServerCallable.java:127)
at
org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithoutRetries(RpcRetryingCallerImpl.java:192)
at
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:387)
at
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:361)
at
org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithRetries(RpcRetryingCallerImpl.java:107)
at
org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:80)
... 3 more
Caused by:
org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.exceptions.ScannerResetException):
org.apache.hadoop.hbase.exceptions.ScannerResetException: Scanner is closed on
the server-side
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3456)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42002)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:409)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:131)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:324)
at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:304)
Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException: Requested
row out of range for Get on HRegion DOP_VISIT_EVENT_INFO,2018-11-29
10:53:10|000000769457596000001816618482000001787755309,1547800190431.7771d67c58c34b8a0338fa7e831d32b8.,
startKey='2018-11-29 10:53:10|000000769457596000001816618482000001787755309',
getEndKey()='2019-01-04
07:20:17.817|000001583257312000001264648896000001787755309', row='2019-01-05
21:19:53.993|000000802429641000001710557138000000027987072'
at org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5595)
at org.apache.hadoop.hbase.regionserver.HRegion.prepareGet(HRegion.java:7194)
at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:7187)
at org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:514)
at
org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:197)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:274)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3136)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:3373)
... 5 more
at
org.apache.hadoop.hbase.ipc.AbstractRpcClient.onCallFinished(AbstractRpcClient.java:387)
at
org.apache.hadoop.hbase.ipc.AbstractRpcClient.access$100(AbstractRpcClient.java:95)
at
org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:410)
at
org.apache.hadoop.hbase.ipc.AbstractRpcClient$3.run(AbstractRpcClient.java:406)
at org.apache.hadoop.hbase.ipc.Call.callComplete(Call.java:103)
at org.apache.hadoop.hbase.ipc.Call.setException(Call.java:118)
at
org.apache.hadoop.hbase.ipc.NettyRpcDuplexHandler.readResponse(NettyRpcDuplexHandler.java:161)
at
org.apache.hadoop.hbase.ipc.NettyRpcDuplexHandler.channelRead(NettyRpcDuplexHandler.java:191)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
at
org.apache.hbase.thirdparty.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:310)
at
org.apache.hbase.thirdparty.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:284)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
at
org.apache.hbase.thirdparty.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
at
org.apache.hbase.thirdparty.io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1359)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at
org.apache.hbase.thirdparty.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at
org.apache.hbase.thirdparty.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:935)
at
org.apache.hbase.thirdparty.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:138)
at
org.apache.hbase.thirdparty.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645)
at
org.apache.hbase.thirdparty.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580)
at
org.apache.hbase.thirdparty.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497)
at
org.apache.hbase.thirdparty.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459)
at
org.apache.hbase.thirdparty.io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858)
at
org.apache.hbase.thirdparty.io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:138)
... 1 more
> Local Index - WrongRegionException when selecting column from base table and
> filtering on indexed column
> --------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-3828
> URL: https://issues.apache.org/jira/browse/PHOENIX-3828
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Reporter: Mujtaba Chohan
> Assignee: Rajeshbabu Chintaguntla
> Priority: Major
>
> {noformat}
> Caused by: org.apache.hadoop.hbase.regionserver.WrongRegionException:
> Requested row out of range for Get on HRegion
> T,00Dxx0000001gES005001xx000003DGQX\x7F\xFF\xFE\xB6\xE7(\x91\xDF017526052jdM
> ,1493854066165.f1f58ac91adc762ad3e22e7f0ae1d85e.,
> startKey='00Dxx0000001gES005001xx000003DGQX\x7F\xFF\xFE\xB6\xE7(\x91\xDF017526052jdM
> ', getEndKey()='',
> row='\x00\x02a05001xx000003DGQX\x7F\xFF\xFE\xB6\xE30\xFD\x970171318362Rz '
> at
> org.apache.hadoop.hbase.regionserver.HRegion.checkRow(HRegion.java:5246)
> at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:6990)
> at
> org.apache.phoenix.util.IndexUtil.wrapResultUsingOffset(IndexUtil.java:529)
> at
> org.apache.phoenix.coprocessor.BaseScannerRegionObserver$1.nextRaw(BaseScannerRegionObserver.java:500)
> at
> org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
> at
> org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateRegionScanner.java:77)
> at
> org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:283)
> {noformat}
> This is caused when a non-index column is part of select statement while
> filtering on an indexed column: {{SELECT STD_COL FROM T WHERE INDEXED_COL <
> 1}}.
> Schema
> {noformat}
> CREATE TABLE IF NOT EXISTS T (PKA CHAR(15) NOT NULL, PKF CHAR(3) NOT NULL,
> PKP CHAR(15) NOT NULL, CRD DATE NOT NULL, EHI CHAR(15) NOT NULL, STD_COL
> VARCHAR, INDEXED_COL INTEGER,
> CONSTRAINT PK PRIMARY KEY ( PKA, PKF, PKP, CRD DESC, EHI))
> VERSIONS=1,MULTI_TENANT=true,IMMUTABLE_ROWS=true;
> CREATE LOCAL INDEX IF NOT EXISTS TIDX ON T (INDEXED_COL);
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
