org.apache.drill.common.exceptions.UserException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • git.commit.id.abbrev=d10769f Query : {code} select * from j2 where c_bigint not in ( select cast(c_integer as bigint) from j6 ) and c_varchar not in ( 'AAAA', 'BBBB', '0000', '0008 397933 38800', '0000 000000 00000') and c_boolean in ( 'true' ) and c_date not in ( select distinct c_date from j6) {code} Error from the logs : {code} org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: java.lang.IllegalStateException: Cleanup before finished. 0 out of 1 strams have finished Fragment 5:30 [Error Id: 593d62dd-f509-4c22-ba5b-8d11cf85ecc0 on atsqa6c85.qa.lab:31010] at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:522) ~[drill-common-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:315) [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:283) [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) [drill-common-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_51] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51] Caused by: java.lang.IllegalStateException: Cleanup before finished. 0 out of 1 strams have finished at org.apache.drill.exec.work.batch.BaseRawBatchBuffer.cleanup(BaseRawBatchBuffer.java:116) ~[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.unorderedreceiver.UnorderedReceiverBatch.close(UnorderedReceiverBatch.java:217) ~[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.BaseRootExec.close(BaseRootExec.java:122) ~[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.closeOutResources(FragmentExecutor.java:333) [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:278) [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] ... 4 common frames omitted {code} Attached the dataset and more information from the logs
    via by Rahul Challapalli,
    • org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: java.lang.IllegalStateException: Cleanup before finished. 0 out of 1 strams have finished Fragment 5:30 [Error Id: 593d62dd-f509-4c22-ba5b-8d11cf85ecc0 on atsqa6c85.qa.lab:31010] at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:522)[drill-common-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:315)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:283)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)[drill-common-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_51] at java.lang.Thread.run(Thread.java:744)[na:1.7.0_51] Caused by: java.lang.IllegalStateException: Cleanup before finished. 0 out of 1 strams have finished at org.apache.drill.exec.work.batch.BaseRawBatchBuffer.cleanup(BaseRawBatchBuffer.java:116)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.unorderedreceiver.UnorderedReceiverBatch.close(UnorderedReceiverBatch.java:217)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.physical.impl.BaseRootExec.close(BaseRootExec.java:122)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.closeOutResources(FragmentExecutor.java:333)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:278)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT] ... 4 more
    No Bugmate found.