[ https://issues.apache.org/jira/browse/DRILL-4863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15437359#comment-15437359 ]
Christopher Altman commented on DRILL-4863: ------------------------------------------- I should add, I have run the query directly on the database server and it returned results as expected. > JDBC Storage Plugin SYSTEM ERROR: NullPointerException Error > ------------------------------------------------------------ > > Key: DRILL-4863 > URL: https://issues.apache.org/jira/browse/DRILL-4863 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JDBC > Affects Versions: 1.7.0 > Environment: * Ubuntu 14.04.1 LTS (GNU/Linux 3.13.0-40-generic x86_64) > * Java(TM) SE Runtime Environment (build 1.7.0_80-b15) > * Data Source: mysql Ver 14.14 Distrib 5.7.10 > Reporter: Christopher Altman > > When running the query: > {code} > SELECT * FROM (SELECT count(*) from mysql.test.acme_sales ) T LIMIT 0 > {code} > I receive the error: > {code} > SYSTEM ERROR: NullPointerException > {code} > Here are the logs > {code} > SYSTEM ERROR: NullPointerException > (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception > during fragment initialization: null > org.apache.drill.exec.work.foreman.Foreman.run():271 > java.util.concurrent.ThreadPoolExecutor.runWorker():1145 > java.util.concurrent.ThreadPoolExecutor$Worker.run():615 > java.lang.Thread.run():745 > Caused By (java.lang.NullPointerException) null > > org.apache.drill.exec.planner.sql.handlers.FindLimit0Visitor$FindHardDistributionScans.visit():262 > org.apache.calcite.rel.core.TableScan.accept():166 > org.apache.calcite.rel.RelShuttleImpl.visitChild():53 > org.apache.calcite.rel.RelShuttleImpl.visitChildren():68 > org.apache.calcite.rel.RelShuttleImpl.visit():126 > org.apache.calcite.rel.AbstractRelNode.accept():256 > org.apache.calcite.rel.RelShuttleImpl.visitChild():53 > org.apache.calcite.rel.RelShuttleImpl.visitChildren():68 > org.apache.calcite.rel.RelShuttleImpl.visit():126 > org.apache.calcite.rel.AbstractRelNode.accept():256 > org.apache.calcite.rel.RelShuttleImpl.visitChild():53 > org.apache.calcite.rel.RelShuttleImpl.visitChildren():68 > org.apache.calcite.rel.RelShuttleImpl.visit():126 > org.apache.calcite.rel.AbstractRelNode.accept():256 > org.apache.calcite.rel.RelShuttleImpl.visitChild():53 > org.apache.calcite.rel.RelShuttleImpl.visitChildren():68 > org.apache.calcite.rel.RelShuttleImpl.visit():126 > org.apache.calcite.rel.AbstractRelNode.accept():256 > > org.apache.drill.exec.planner.sql.handlers.FindLimit0Visitor.containsLimit0():129 > > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():259 > > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():286 > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():168 > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():94 > org.apache.drill.exec.work.foreman.Foreman.runSQL():978 > org.apache.drill.exec.work.foreman.Foreman.run():257 > java.util.concurrent.ThreadPoolExecutor.runWorker():1145 > java.util.concurrent.ThreadPoolExecutor$Worker.run():615 > java.lang.Thread.run():745 > > Error Id: c9a4bc51-a18c-408a-9958-23124b9aac47 on 10.0.1.241:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > [Error Id: c9a4bc51-a18c-408a-9958-23124b9aac47 on 10.0.1.241:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:543) > ~[drill-common-1.7.0.jar:1.7.0] > at > org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:791) > [drill-java-exec-1.7.0.jar:1.7.0] > at > org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:901) > [drill-java-exec-1.7.0.jar:1.7.0] > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:271) > [drill-java-exec-1.7.0.jar:1.7.0] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_80] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_80] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80] > Caused by: org.apache.drill.exec.work.foreman.ForemanException: Unexpected > exception during fragment initialization: null > ... 4 common frames omitted > Caused by: java.lang.NullPointerException: null > at > org.apache.drill.exec.planner.sql.handlers.FindLimit0Visitor$FindHardDistributionScans.visit(FindLimit0Visitor.java:262) > ~[drill-java-exec-1.7.0.jar:1.7.0] > at org.apache.calcite.rel.core.TableScan.accept(TableScan.java:166) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:53) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:68) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:126) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:256) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:53) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:68) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:126) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:256) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:53) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:68) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:126) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:256) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:53) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:68) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:126) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:256) > ~[calcite-core-1.4.0-drill-r11.jar:1.4.0-drill-r11] > at > org.apache.drill.exec.planner.sql.handlers.FindLimit0Visitor.containsLimit0(FindLimit0Visitor.java:129) > ~[drill-java-exec-1.7.0.jar:1.7.0] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:259) > ~[drill-java-exec-1.7.0.jar:1.7.0] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:286) > ~[drill-java-exec-1.7.0.jar:1.7.0] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:168) > ~[drill-java-exec-1.7.0.jar:1.7.0] > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:94) > ~[drill-java-exec-1.7.0.jar:1.7.0] > at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:978) > [drill-java-exec-1.7.0.jar:1.7.0] > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:257) > [drill-java-exec-1.7.0.jar:1.7.0] > ... 3 common frames omitted > {code} > I am using Apache Drill 1.7 on a Ubuntu 14.04 Server Connecting to MySql 5.7. -- This message was sent by Atlassian JIRA (v6.3.4#6332)