phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "MariaCarrie (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3828) Local Index - WrongRegionException when selecting column from base table and filtering on indexed column
Date Wed, 20 Feb 2019 06:00:00 GMT

    [ 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)

Mime
View raw message