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]

Apache's JIRA Issue Tracker | Rahul Challapalli | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    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

    Apache's JIRA Issue Tracker | 2 years ago | 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]

    Root Cause Analysis

    1. java.lang.IllegalStateException

      Cleanup before finished. 0 out of 1 strams have finished

      at org.apache.drill.exec.work.batch.BaseRawBatchBuffer.cleanup()
    2. org.apache.drill
      SelfCleaningRunnable.run
      1. org.apache.drill.exec.work.batch.BaseRawBatchBuffer.cleanup(BaseRawBatchBuffer.java:116)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
      2. 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]
      3. org.apache.drill.exec.physical.impl.BaseRootExec.close(BaseRootExec.java:122)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
      4. org.apache.drill.exec.work.fragment.FragmentExecutor.closeOutResources(FragmentExecutor.java:333)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
      5. org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:278)[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
      6. org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)[drill-common-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
      6 frames
    3. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_51]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_51]
      3. java.lang.Thread.run(Thread.java:744)[na:1.7.0_51]
      3 frames