Yingyi Bu created ASTERIXDB-1796:
------------------------------------
Summary: Job hanging after "no space on device"
Key: ASTERIXDB-1796
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1796
Project: Apache AsterixDB
Issue Type: Bug
Components: Hyracks Core
Reporter: Yingyi Bu
Assignee: Yingyi Bu
Setting:
2 NCs
1GB RAM per NC
one partition per NC
TPC-H data: 2GB
Query:
{noformat}
USE tpch;
SET `compiler.joinmemory` "8MB"
SET `compiler.groupmemory` "8MB"
SET `compiler.sortmemory` "8MB"
WITH tmp AS
(
SELECT l_orderkey, SUM(l_quantity) t_sum_quantity
FROM LineItem
GROUP BY l_orderkey
)
SELECT c.c_name, c.c_custkey, o.o_orderkey, o.o_orderdate, o.o_totalprice,
SUM(l.l_quantity) sum_quantity
FROM LineItem l
JOIN tmp t ON t.l_orderkey = l.l_orderkey
JOIN Orders o ON o.o_orderkey = t.l_orderkey
JOIN Customer c ON c.c_custkey = o.o_custkey
WHERE t.t_sum_quantity > 30
GROUP BY c.c_name, c.c_custkey, o.o_orderkey, o.o_orderdate, o.o_totalprice
ORDER BY o.o_totalprice DESC, o.o_orderdate
LIMIT 100
;
{noformat}
{noformat}
org.apache.hyracks.api.exceptions.HyracksDataException: No space left on device
at org.apache.hyracks.control.nc.Task.pushFrames(Task.java:376)
at org.apache.hyracks.control.nc.Task.run(Task.java:308)
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)
Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: No space
left on device
at org.apache.hyracks.control.nc.io.IOManager.syncWrite(IOManager.java:143)
at
org.apache.hyracks.dataflow.common.io.RunFileWriter.nextFrame(RunFileWriter.java:60)
at
org.apache.hyracks.dataflow.std.buffermanager.VPartitionTupleBufferManager.flushPartition(VPartitionTupleBufferManager.java:285)
at
org.apache.hyracks.dataflow.std.join.OptimizedHybridHashJoin.probe(OptimizedHybridHashJoin.java:514)
at
org.apache.hyracks.dataflow.std.join.OptimizedHybridHashJoinOperatorDescriptor$ProbeAndJoinActivityNode$1.nextFrame(OptimizedHybridHashJoinOperatorDescriptor.java:405)
at org.apache.hyracks.control.nc.Task.pushFrames(Task.java:360)
... 4 more
Caused by: java.io.IOException: No space left on device
at sun.nio.ch.FileDispatcherImpl.pwrite0(Native Method)
at sun.nio.ch.FileDispatcherImpl.pwrite(FileDispatcherImpl.java:66)
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:89)
at sun.nio.ch.IOUtil.write(IOUtil.java:65)
at sun.nio.ch.FileChannelImpl.writeInternal(FileChannelImpl.java:778)
at sun.nio.ch.FileChannelImpl.write(FileChannelImpl.java:764)
at org.apache.hyracks.control.nc.io.IOManager.syncWrite(IOManager.java:130)
... 9 more
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)