[
https://issues.apache.org/jira/browse/PHOENIX-968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13990597#comment-13990597
]
Cristian Armaselu commented on PHOENIX-968:
-------------------------------------------
True!
I found that out when I tried on a windows client and looking in the sources.
There were a number of files totaling 600MB in ${java.io.tmpdir}.
I wonder why you need that much storage to return a result set to the client...
I have tried to limit the number of records returned to 100k (from 750k) and I
got timeout (Phoenix-969)
> 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)
