[
https://issues.apache.org/jira/browse/PHOENIX-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15396507#comment-15396507
]
Jan Fernando commented on PHOENIX-3121:
---------------------------------------
[~lhofhansl] The issue we found was that when specifying a LIMIT of, say 99 or
101, a query would return in milliseconds, but when specifying a LIMIT of 100
the query would take ~50 secs on greater. In some cases, when the table has
enough data, the query would take longer and the scanner lease would time out.
The scanner lease timeout is a symptom and not a cause I believe. The issue is
why identical queries perform expect when the limit is a multiple of the
scanner cache size.
> Queries with filter and reverse scan failing when limit is a multiple of
> scanner cache size
> -------------------------------------------------------------------------------------------
>
> Key: PHOENIX-3121
> URL: https://issues.apache.org/jira/browse/PHOENIX-3121
> Project: Phoenix
> Issue Type: Bug
> Reporter: Samarth Jain
> Assignee: Samarth Jain
>
> {code}
> org.apache.hadoop.hbase.UnknownScannerException:
> org.apache.hadoop.hbase.UnknownScannerException: Unknown scanner '644116'.
> This can happen due to any of the following reasons: a) Scanner id given is
> wrong, b) Scanner lease expired because of long wait between consecutive
> client checkins, c) Server may be closing down, d) RegionServer restart
> during upgrade.
> If the issue is due to reason (b), a possible fix would be increasing the
> value of'hbase.client.scanner.timeout.period' configuration.
> at
> org.apache.hadoop.hbase.regionserver.HRegionServer.scan(HRegionServer.java:3228)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32492)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2208)
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
