[ https://issues.apache.org/jira/browse/PHOENIX-3839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16012864#comment-16012864 ]
Mujtaba Chohan commented on PHOENIX-3839: ----------------------------------------- With HBASE-18000/HBase 1.3.1 {noformat} INFO [regionserver/localhost/127.0.0.1:0.leaseChecker] regionserver.RSRpcServices: Scanner 930 lease expired on region T,\x7F\xFF\xFE\xB7\x8C\xD4\x09\xCF017404812WfC ,1494955820050.44900eecad4214ee0078b490517d5c13. Failed after attempts=36, exceptions: null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=60119: Call to localhost/127.0.0.1:60579 failed on local exception: org.apache.hadoop.hbase.ipc.CallTimeoutException: Call id=2790, waitTime=60001, operationTimeout=60000 expired. row '' on table 'T' at region=T,,1494955820050.6e64409f6db8c5fce401b4216dcb35fc., hostname=localhost,60579,1494955479513, seqNum=578 at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:116) at org.apache.phoenix.iterate.TableResultIterator.next(TableResultIterator.java:146) 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:121) at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:106) 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) {noformat} While building a global index. [~samarthjain] > Prevent large aggregate queries from timing out > ----------------------------------------------- > > Key: PHOENIX-3839 > URL: https://issues.apache.org/jira/browse/PHOENIX-3839 > Project: Phoenix > Issue Type: Bug > Reporter: James Taylor > Assignee: Samarth Jain > > Large aggregate queries timeout in Phoenix, even with our renew lease code in > place. The only workaround is to increase the RPC timeout to be really high > which is not such a good idea. It's quite possible HBASE-18000 is the root > cause. Would it be possible to test that theory on master (i.e. with HBase > 1.3 plus the patch for HBASE-18000), [~samarthjain] & [~mujtabachohan]? -- This message was sent by Atlassian JIRA (v6.3.15#6346)