You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/05/07 09:42:17 UTC

[jira] [Commented] (PHOENIX-969) java.util.concurrent.TimeoutException while reading the result set

    [ https://issues.apache.org/jira/browse/PHOENIX-969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13991614#comment-13991614 ] 

Gabriel Reid commented on PHOENIX-969:
--------------------------------------

I believe that this is basically the same case as logged in PHOENIX-968 (and would most likely be resolved by a fix for PHOENIX-968). What is happening under the covers is that each region is being asked for a maximum of 100k records. Depending on how many regions you have, this is likely the full content of each region, and it seems that it's taking more than a minute to copy all of this data locally, so it's timing out before copying everything.

Just out of interest: how many regions do you have in your table? And is this running from a different client environment than the situation reported in PHOENIX-968?

> java.util.concurrent.TimeoutException while reading the result set
> ------------------------------------------------------------------
>
>                 Key: PHOENIX-969
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-969
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0, 4.0.0
>            Reporter: Cristian Armaselu
>
> I'm querying from a windows client a PTable 750k rows, 50 columns with a limit to 100k records.
> This is what I'm getting in the client:
> Exception in thread "main" java.lang.reflect.InvocationTargetException
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at com.intellij.rt.execution.CommandLineWrapper.main(CommandLineWrapper.java:121)
> Caused by: org.apache.phoenix.exception.PhoenixIOException
> 	at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:97)
> 	at org.apache.phoenix.iterate.ParallelIterators.getIterators(ParallelIterators.java:289)
> 	at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:44)
> 	at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:66)
> 	at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:86)
> 	at org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:40)
> 	at org.apache.phoenix.iterate.LimitingResultIterator.next(LimitingResultIterator.java:46)
> 	at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:732)
> 	at com.epsilon.cds.service.phoenix.PhoenixJdbcTest.queryData(PhoenixJdbcTest.java:728)
> 	at com.epsilon.cds.service.phoenix.PhoenixJdbcTest.main(PhoenixJdbcTest.java:751)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)
> 	... 5 more
> Caused by: java.util.concurrent.TimeoutException
> 	at java.util.concurrent.FutureTask.get(FutureTask.java:201)
> 	at org.apache.phoenix.iterate.ParallelIterators.getIterators(ParallelIterators.java:283)
> 	... 18 more



--
This message was sent by Atlassian JIRA
(v6.2#6252)