[jira] [Commented] (PHOENIX-968) java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: No space left on device

["Gabriel Reid (JIRA)" <ji...@apache.org>]

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

Gabriel Reid commented on PHOENIX-968:
--------------------------------------

Phoenix spools results of large queries to disk (see [1]) in a temporary file on the client. Could it be that the disk where your temp directory is located doesn't have too much space left?

1. https://github.com/apache/incubator-phoenix/blob/c22539d940fa0afc790cc0f25c2cdbbb255f80a3/phoenix-core/src/main/java/org/apache/phoenix/iterate/SpoolingResultIterator.java#L95

> java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: No space left on device
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-968
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-968
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Cristian Armaselu
>
> I'm querying a PTable with select * , table has 750k rows, 50 columns.
> The client querying the data is on one of the cluster nodes.
> I'm getting the error below
> Exception in thread "main" org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: No space left on device
> 	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.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:732)
> 	at com.epsilon.cds.service.phoenix.PhoenixJdbcTest.queryData(PhoenixJdbcTest.java:727)
> 	at com.epsilon.cds.service.phoenix.PhoenixJdbcTest.main(PhoenixJdbcTest.java:750)
> Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: No space left on device
> 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> 	at java.util.concurrent.FutureTask.get(FutureTask.java:202)
> 	at org.apache.phoenix.iterate.ParallelIterators.getIterators(ParallelIterators.java:283)
> 	... 6 more
> Caused by: org.apache.phoenix.exception.PhoenixIOException: No space left on device
> 	at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:97)
> 	at org.apache.phoenix.iterate.SpoolingResultIterator.<init>(SpoolingResultIterator.java:127)
> 	at org.apache.phoenix.iterate.SpoolingResultIterator.<init>(SpoolingResultIterator.java:73)
> 	at org.apache.phoenix.iterate.SpoolingResultIterator$SpoolingResultIteratorFactory.newIterator(SpoolingResultIterator.java:67)
> 	at org.apache.phoenix.iterate.ParallelIterators$2.call(ParallelIterators.java:255)
> 	at org.apache.phoenix.iterate.ParallelIterators$2.call(ParallelIterators.java:245)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	at java.lang.Thread.run(Thread.java:744)
> Caused by: java.io.IOException: No space left on device
> 	at java.io.FileOutputStream.writeBytes(Native Method)
> 	at java.io.FileOutputStream.write(FileOutputStream.java:345)
> 	at org.apache.commons.io.output.ThresholdingOutputStream.write(ThresholdingOutputStream.java:129)
> 	at java.io.DataOutputStream.write(DataOutputStream.java:107)
> 	at org.apache.phoenix.util.TupleUtil.write(TupleUtil.java:148)
> 	at org.apache.phoenix.iterate.SpoolingResultIterator.<init>(SpoolingResultIterator.java:109)
> I tried couple of times monitoring the storage on all 3 servers. There is plenty of storage.
> I was not able to see any error/exception on the region server logs.
> Where exactly there is no space left on device?



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