[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15053604#comment-15053604 ] Victoria Markman commented on DRILL-4109: - Verified again with 1.4.0 with the fix for DRILL-4165 {code} #Tue Dec 08 03:32:09 UTC 2015 git.commit.id.abbrev=b906811 git.commit.user.email=amit.ha...@gmail.com git.commit.message.full=DRILL-4165 Add a precondition for size of merge join record batch.\n git.commit.id=b9068117177c3b47025f52c00f67938e0c3e4732 git.commit.message.short=DRILL-4165 Add a precondition for size of merge join record batch. git.commit.user.name=Amit Hadke {code} > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Relational Operators >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15041931#comment-15041931 ] Victoria Markman commented on DRILL-4109: - Verified that this bug is fixed. Version bug was verified with: {code} #Fri Dec 04 07:02:50 UTC 2015 git.commit.id.abbrev=d855906 git.commit.user.email=s...@apache.org git.commit.message.full=DRILL-4159\: Remove trailing space\n {code} I'm not resolving this as verified until I have automated test suite running. > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15036757#comment-15036757 ] amit hadke commented on DRILL-4109: --- [~vicky] I pushed in my changes for DRILL-4125, Could you run query15.sql on latest change? Repo: https://github.com/amithadke/drill Branch: DRILL-4109 > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15036959#comment-15036959 ] ASF GitHub Bot commented on DRILL-4109: --- Github user StevenMPhillips commented on the pull request: https://github.com/apache/drill/pull/282#issuecomment-161478598 +1 > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15036994#comment-15036994 ] ASF GitHub Bot commented on DRILL-4109: --- Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/282 > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15036883#comment-15036883 ] Venki Korukanti commented on DRILL-4109: I just got to know that Vicky is OOF today. I will check if anybody else has the same configuration to verify. > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15034431#comment-15034431 ] amit hadke commented on DRILL-4109: --- Thanks Victoria. I found the issue thats causing queries to fail ( DRILL-4125 ). I'll update the PR. > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15032386#comment-15032386 ] amit hadke commented on DRILL-4109: --- [~vicky] Could you please try to reproduce DRILL-4109 and DRILL-4125 with my change above? Repo: https://github.com/amithadke/drill Branch: DRILL-4109 > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15032705#comment-15032705 ] Victoria Markman commented on DRILL-4109: - [~aah] sure, I will give it a try. Stay tuned. > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_71] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > java.lang.NullPointerException: null > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15033173#comment-15033173 ] Victoria Markman commented on DRILL-4109: - [~aah] NPE is not there anymore, however, now bunch of queries fail with error below. {code} 0: jdbc:drill:drillbit=localhost> SELECT ca_zip, . . . . . . . . . . . . . . . . >Sum(cs_sales_price) . . . . . . . . . . . . . . . . > FROM catalog_sales, . . . . . . . . . . . . . . . . >customer, . . . . . . . . . . . . . . . . >customer_address, . . . . . . . . . . . . . . . . >date_dim . . . . . . . . . . . . . . . . > WHERE cs_bill_customer_sk = c_customer_sk . . . . . . . . . . . . . . . . >AND c_current_addr_sk = ca_address_sk . . . . . . . . . . . . . . . . >AND ( Substr(ca_zip, 1, 5) IN ( '85669', '86197', '88274', '83405', . . . . . . . . . . . . . . . . > '86475', '85392', '85460', '80348', . . . . . . . . . . . . . . . . > '81792' ) . . . . . . . . . . . . . . . . > OR ca_state IN ( 'CA', 'WA', 'GA' ) . . . . . . . . . . . . . . . . > OR cs_sales_price > 500 ) . . . . . . . . . . . . . . . . >AND cs_sold_date_sk = d_date_sk . . . . . . . . . . . . . . . . >AND d_qoy = 1 . . . . . . . . . . . . . . . . >AND d_year = 1998 . . . . . . . . . . . . . . . . > GROUP BY ca_zip . . . . . . . . . . . . . . . . > ORDER BY ca_zip . . . . . . . . . . . . . . . . > LIMIT 100; Error: SYSTEM ERROR: IllegalArgumentException: innerPosition:2184, outerPosition:63336, innerRecordCount:2184, totalRecordCount:65520 Fragment 3:1 [Error Id: 687f2bee-f8f7-4a80-b211-fd50c4216342 on atsqa4-133.qa.lab:31010] (state=,code=0) {code} This is query15.sql, I'm attaching debug log > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on
[jira] [Commented] (DRILL-4109) NPE in RecordIterator
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15025757#comment-15025757 ] ASF GitHub Bot commented on DRILL-4109: --- GitHub user amithadke opened a pull request: https://github.com/apache/drill/pull/282 DRILL-4109 Fix NPE in RecordIterator. You can merge this pull request into a Git repository by running: $ git pull https://github.com/amithadke/drill DRILL-4109 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/drill/pull/282.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #282 commit 7adc9243c17ed7a11f2d791e120731f99c219d75 Author: Amit HadkeDate: 2015-11-25T00:00:16Z DRILL-4109 Fix NPE in RecordIterator. > NPE in RecordIterator > - > > Key: DRILL-4109 > URL: https://issues.apache.org/jira/browse/DRILL-4109 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.4.0 >Reporter: Victoria Markman >Assignee: amit hadke >Priority: Blocker > Fix For: 1.4.0 > > Attachments: 29ac6c1b-9b33-3457-8bc8-9e2dff6ad438.sys.drill, > 29b41f37-4803-d7ce-e05f-912d1f65da79.sys.drill, drillbit.log, > drillbit.log.debug > > > 4 node cluster > 36GB of direct memory > 4GB heap memory > planner.memory.max_query_memory_per_node=2GB (default) > planner.enable_hashjoin = false > Spill directory has 6.4T of memory available: > {noformat} > [Tue Nov 17 18:23:18 /tmp/drill ] # df -H . > Filesystem Size Used Avail Use% Mounted on > localhost:/mapr 7.7T 1.4T 6.4T 18% /mapr > {noformat} > Run query below: > framework/resources/Advanced/tpcds/tpcds_sf100/original/query15.sql > drillbit.log > {code} > 2015-11-18 02:22:12,639 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:9] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_9/operator_17/7 > 2015-11-18 02:22:12,770 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:5] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Merging and spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_5/operator_17/7 > 2015-11-18 02:22:13,345 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:17] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_17/operator_17/7 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.p.i.xsort.ExternalSortBatch - Completed spilling to > /tmp/drill/spill/29b41f37-4803-d7ce-e05f-912d1f65da79/major_fragment_3/minor_fragment_13/operator_16/1 > 2015-11-18 02:22:13,346 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] WARN > o.a.d.e.p.i.xsort.ExternalSortBatch - Starting to merge. 34 batch groups. > Current allocated memory: 2252186 > 2015-11-18 02:22:13,363 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested RUNNING --> > FAILED > 2015-11-18 02:22:13,370 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 29b41f37-4803-d7ce-e05f-912d1f65da79:3:13: State change requested FAILED --> > FINISHED > 2015-11-18 02:22:13,371 [29b41f37-4803-d7ce-e05f-912d1f65da79:frag:3:13] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > Fragment 3:13 > [Error Id: c5d67dcb-16aa-4951-89f5-599b4b4eb54d on atsqa4-133.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:321) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:184) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:290) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_71] > at >