You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Minnow Noir <mi...@gmail.com> on 2015/01/24 02:12:23 UTC
Drill 0.7 | Every query hangs
I'm trying to follow the "Drill in 10 Minutes" tutorial because Drill keeps
hanging.
I have Java 7 installed on my Fedora 20 workstation.
I downloaded 0.7 and dropped it at /opt/apache-drill-0.7.0/ .
When I run Drill per the tutorial, it starts fine:
bin/sqlline -u jdbc:drill:zk=local
Jan 23, 2015 8:01:59 PM org.glassfish.jersey.server.ApplicationHandler
initialize
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29
01:25:26...
sqlline version 1.1.6
0: jdbc:drill:zk=local>
However, if I try to do any type of query, it just hangs indefinitely. I
can't even use CTRL-C or CTRL-D to kill the sqlline session. I have to
kill the process.
SELECT * FROM cp.`employee.json`;
I see the following error in the logs:
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit
environment:.java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.io.tmpdir=/tmp
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.compiler=<NA>
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.name=Linux
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.arch=amd64
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.version=3.11.10
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.name=user
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.home=/home/user
2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.dir=/opt/apache-drill-0.7.0
2015-01-23 20:06:09,820 [WorkManager-1] ERROR
o.apache.drill.exec.work.WorkManager - Failure while running wrapper
[Foreman: 2b3d0ffe-7960-ed95-f21f-8de0052e701f]
java.lang.NullPointerException: null
at
org.apache.drill.exec.work.foreman.Foreman.cancelExecutingFragments(Foreman.java:483)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:436)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[na:1.7.0_45]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_45]
Any ideas?
Thanks!
Re: Drill 0.7 | Every query hangs
Posted by Aditya <ad...@gmail.com>.
The actual error is getting masked somewhere. Could you please enable DEBUG
logging, restart drill, re-run the query and post here any other error
message you see.
In $DRILL_HOME/conf/logback.xml, change
<logger name="org.apache.drill" additivity="false">
<level value="info" />
<appender-ref ref="FILE" />
</logger>
to
<logger name="org.apache.drill" additivity="false">
<level value="debug" />
<appender-ref ref="FILE" />
</logger>
On Fri, Jan 23, 2015 at 5:12 PM, Minnow Noir <mi...@gmail.com> wrote:
> I'm trying to follow the "Drill in 10 Minutes" tutorial because Drill keeps
> hanging.
>
> I have Java 7 installed on my Fedora 20 workstation.
>
> I downloaded 0.7 and dropped it at /opt/apache-drill-0.7.0/ .
>
> When I run Drill per the tutorial, it starts fine:
>
> bin/sqlline -u jdbc:drill:zk=local
> Jan 23, 2015 8:01:59 PM org.glassfish.jersey.server.ApplicationHandler
> initialize
> INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29
> 01:25:26...
> sqlline version 1.1.6
> 0: jdbc:drill:zk=local>
>
> However, if I try to do any type of query, it just hangs indefinitely. I
> can't even use CTRL-C or CTRL-D to kill the sqlline session. I have to
> kill the process.
>
> SELECT * FROM cp.`employee.json`;
>
>
> I see the following error in the logs:
>
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit
>
> environment:.java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.java.io.tmpdir=/tmp
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.java.compiler=<NA>
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.os.name=Linux
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.os.arch=amd64
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.os.version=3.11.10
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.user.name=user
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.user.home=/home/user
> 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit -
> Drillbit environment:.user.dir=/opt/apache-drill-0.7.0
> 2015-01-23 20:06:09,820 [WorkManager-1] ERROR
> o.apache.drill.exec.work.WorkManager - Failure while running wrapper
> [Foreman: 2b3d0ffe-7960-ed95-f21f-8de0052e701f]
> java.lang.NullPointerException: null
> at
>
> org.apache.drill.exec.work.foreman.Foreman.cancelExecutingFragments(Foreman.java:483)
> ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> at
> org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:436)
> ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
> ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> at
>
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
> ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
> [na:1.7.0_45]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> [na:1.7.0_45]
> at java.lang.Thread.run(Unknown Source) [na:1.7.0_45]
>
>
> Any ideas?
>
> Thanks!
>