You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Rob Terpilowski <RO...@Lynden.com> on 2016/03/03 22:40:29 UTC
ConnectTimeoutException when starting drill
I am attempting to get Apache Drill running on an Ubuntu box with Java 1.8.0_51 as root.
I've downloaded and unzipped the drill tar.gz file.
When I attempt to run the ./bin/drill-embedded command. (I've attempted to run the drill-localhost command as well)
The command sits for a little less than a minute at the line:
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
The message is the followed by the following exceptions. Any idea of where I can begin looking for the issue. I changed the port number from 31010 to a number of other different ports with the same result.
Any help would be appreciated.
Thanks,
-Rob
Error: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010 (state=,code=0)
java.sql.SQLException: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
at sqlline.Commands.connect(Commands.java:1083)
at sqlline.Commands.connect(Commands.java:1015)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.initArgs(SqlLine.java:528)
at sqlline.SqlLine.begin(SqlLine.java:596)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
at io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.util.concurrent.ExecutionException: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
... 12 more
Caused by: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
... 6 more
apache drill 1.4.0
"just drill it"
0: jdbc:drill:zk=local>
java.sql.SQLException: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
at sqlline.Commands.connect(Commands.java:1083)
at sqlline.Commands.connect(Commands.java:1015)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.initArgs(SqlLine.java:528)
at sqlline.SqlLine.begin(SqlLine.java:596)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
at io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.util.concurrent.ExecutionException: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
... 12 more
Caused by: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
... 6 more
apache drill 1.4.0
"got drill?"
0: jdbc:drill:zk=local> !quit
Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit could not bind to port 31010.
Server type UserServer
[Error Id: 573940e6-9025-48a5-8054-09f9d55612a5 ] (state=,code=0)
Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit could not bind to port 31010.
Server type UserServer
[Error Id: 0980fbda-0d88-4161-8ee0-96c72f714e23 ] (state=,code=0)
Re: ConnectTimeoutException when starting drill
Posted by Rob Terpilowski <RO...@Lynden.com>.
Thank you. Using Drill 1.6 and the suggested edits to the /etc/hosts file has corrected the problem.
________________________________________
From: Aditya <ad...@gmail.com>
Sent: Wednesday, March 16, 2016 11:22 AM
To: user
Subject: Re: ConnectTimeoutException when starting drill
Could you please check your "/etc/hosts" file for a possible
mis-configuration of "localhost" and ensure that all localhost names are
set to default, i.e.
127.0.0.1 localhost localhost.localdomain localhost4
> localhost4.localdomain4
> ::1 localhost localhost.localdomain localhost6
> localhost6.localdomain6
>
On Wed, Mar 16, 2016 at 11:06 AM, Sudheesh Katkam <sk...@maprtech.com>
wrote:
> Drill 1.6 introduces support <
> http://drill.apache.org/blog/2016/03/16/drill-1.6-released/> for Java
> 1.8, which is generally available today. Download here <
> http://drill.apache.org/download/>.
>
> Thank you,
> Sudheesh
>
> > On Mar 3, 2016, at 1:40 PM, Rob Terpilowski <RO...@Lynden.com> wrote:
> >
> > I am attempting to get Apache Drill running on an Ubuntu box with Java
> 1.8.0_51 as root.
> >
> > I've downloaded and unzipped the drill tar.gz file.
> >
> > When I attempt to run the ./bin/drill-embedded command. (I've
> attempted to run the drill-localhost command as well)
> >
> > The command sits for a little less than a minute at the line:
> > INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29
> 01:25:26...
> >
> > The message is the followed by the following exceptions. Any idea of
> where I can begin looking for the issue. I changed the port number from
> 31010 to a number of other different ports with the same result.
> >
> > Any help would be appreciated.
> >
> > Thanks,
> > -Rob
> >
> >
> > Error: Failure in connecting to Drill:
> org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010 (state=,code=0)
> > java.sql.SQLException: Failure in connecting to Drill:
> org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
> > at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
> > at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> > at
> net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
> > at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> > at
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> > at sqlline.Commands.connect(Commands.java:1083)
> > at sqlline.Commands.connect(Commands.java:1015)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:497)
> > at
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> > at sqlline.SqlLine.dispatch(SqlLine.java:742)
> > at sqlline.SqlLine.initArgs(SqlLine.java:528)
> > at sqlline.SqlLine.begin(SqlLine.java:596)
> > at sqlline.SqlLine.start(SqlLine.java:375)
> > at sqlline.SqlLine.main(SqlLine.java:268)
> > Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
> > at
> io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
> > at
> io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
> > at
> io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
> > at
> io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> > at java.lang.Thread.run(Thread.java:745)
> > Caused by: java.util.concurrent.ExecutionException:
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
> > ... 12 more
> > Caused by: io.netty.channel.ConnectTimeoutException: connection timed
> out: lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
> > ... 6 more
> > apache drill 1.4.0
> > "just drill it"
> > 0: jdbc:drill:zk=local>
> >
> >
> >
> >
> >
> >
> >
> > java.sql.SQLException: Failure in connecting to Drill:
> org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
> > at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
> > at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> > at
> net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
> > at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> > at
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> > at sqlline.Commands.connect(Commands.java:1083)
> > at sqlline.Commands.connect(Commands.java:1015)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:497)
> > at
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> > at sqlline.SqlLine.dispatch(SqlLine.java:742)
> > at sqlline.SqlLine.initArgs(SqlLine.java:528)
> > at sqlline.SqlLine.begin(SqlLine.java:596)
> > at sqlline.SqlLine.start(SqlLine.java:375)
> > at sqlline.SqlLine.main(SqlLine.java:268)
> > Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
> > at
> io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
> > at
> io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
> > at
> io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
> > at
> io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> > at java.lang.Thread.run(Thread.java:745)
> > Caused by: java.util.concurrent.ExecutionException:
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
> > ... 12 more
> > Caused by: io.netty.channel.ConnectTimeoutException: connection timed
> out: lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
> > ... 6 more
> > apache drill 1.4.0
> > "got drill?"
> > 0: jdbc:drill:zk=local> !quit
> > Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit
> could not bind to port 31010.
> >
> >
> > Server type UserServer
> >
> >
> > [Error Id: 573940e6-9025-48a5-8054-09f9d55612a5 ] (state=,code=0)
> > Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit
> could not bind to port 31010.
> >
> >
> > Server type UserServer
> >
> >
> > [Error Id: 0980fbda-0d88-4161-8ee0-96c72f714e23 ] (state=,code=0)
> >
> >
> >
>
>
Re: ConnectTimeoutException when starting drill
Posted by Aditya <ad...@gmail.com>.
Could you please check your "/etc/hosts" file for a possible
mis-configuration of "localhost" and ensure that all localhost names are
set to default, i.e.
127.0.0.1 localhost localhost.localdomain localhost4
> localhost4.localdomain4
> ::1 localhost localhost.localdomain localhost6
> localhost6.localdomain6
>
On Wed, Mar 16, 2016 at 11:06 AM, Sudheesh Katkam <sk...@maprtech.com>
wrote:
> Drill 1.6 introduces support <
> http://drill.apache.org/blog/2016/03/16/drill-1.6-released/> for Java
> 1.8, which is generally available today. Download here <
> http://drill.apache.org/download/>.
>
> Thank you,
> Sudheesh
>
> > On Mar 3, 2016, at 1:40 PM, Rob Terpilowski <RO...@Lynden.com> wrote:
> >
> > I am attempting to get Apache Drill running on an Ubuntu box with Java
> 1.8.0_51 as root.
> >
> > I've downloaded and unzipped the drill tar.gz file.
> >
> > When I attempt to run the ./bin/drill-embedded command. (I've
> attempted to run the drill-localhost command as well)
> >
> > The command sits for a little less than a minute at the line:
> > INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29
> 01:25:26...
> >
> > The message is the followed by the following exceptions. Any idea of
> where I can begin looking for the issue. I changed the port number from
> 31010 to a number of other different ports with the same result.
> >
> > Any help would be appreciated.
> >
> > Thanks,
> > -Rob
> >
> >
> > Error: Failure in connecting to Drill:
> org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010 (state=,code=0)
> > java.sql.SQLException: Failure in connecting to Drill:
> org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
> > at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
> > at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> > at
> net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
> > at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> > at
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> > at sqlline.Commands.connect(Commands.java:1083)
> > at sqlline.Commands.connect(Commands.java:1015)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:497)
> > at
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> > at sqlline.SqlLine.dispatch(SqlLine.java:742)
> > at sqlline.SqlLine.initArgs(SqlLine.java:528)
> > at sqlline.SqlLine.begin(SqlLine.java:596)
> > at sqlline.SqlLine.start(SqlLine.java:375)
> > at sqlline.SqlLine.main(SqlLine.java:268)
> > Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
> > at
> io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
> > at
> io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
> > at
> io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
> > at
> io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> > at java.lang.Thread.run(Thread.java:745)
> > Caused by: java.util.concurrent.ExecutionException:
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
> > ... 12 more
> > Caused by: io.netty.channel.ConnectTimeoutException: connection timed
> out: lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
> > ... 6 more
> > apache drill 1.4.0
> > "just drill it"
> > 0: jdbc:drill:zk=local>
> >
> >
> >
> >
> >
> >
> >
> > java.sql.SQLException: Failure in connecting to Drill:
> org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
> > at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
> > at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> > at
> net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
> > at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> > at
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> > at sqlline.Commands.connect(Commands.java:1083)
> > at sqlline.Commands.connect(Commands.java:1015)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:497)
> > at
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> > at sqlline.SqlLine.dispatch(SqlLine.java:742)
> > at sqlline.SqlLine.initArgs(SqlLine.java:528)
> > at sqlline.SqlLine.begin(SqlLine.java:596)
> > at sqlline.SqlLine.start(SqlLine.java:375)
> > at sqlline.SqlLine.main(SqlLine.java:268)
> > Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION :
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
> > at
> io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
> > at
> io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
> > at
> io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
> > at
> io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
> > at
> io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
> > at
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> > at java.lang.Thread.run(Thread.java:745)
> > Caused by: java.util.concurrent.ExecutionException:
> io.netty.channel.ConnectTimeoutException: connection timed out:
> lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
> > at
> org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
> > ... 12 more
> > Caused by: io.netty.channel.ConnectTimeoutException: connection timed
> out: lisprod03.lynden.com/172.16.218.141:31010
> > at
> io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
> > ... 6 more
> > apache drill 1.4.0
> > "got drill?"
> > 0: jdbc:drill:zk=local> !quit
> > Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit
> could not bind to port 31010.
> >
> >
> > Server type UserServer
> >
> >
> > [Error Id: 573940e6-9025-48a5-8054-09f9d55612a5 ] (state=,code=0)
> > Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit
> could not bind to port 31010.
> >
> >
> > Server type UserServer
> >
> >
> > [Error Id: 0980fbda-0d88-4161-8ee0-96c72f714e23 ] (state=,code=0)
> >
> >
> >
>
>
Re: ConnectTimeoutException when starting drill
Posted by Sudheesh Katkam <sk...@maprtech.com>.
Drill 1.6 introduces support <http://drill.apache.org/blog/2016/03/16/drill-1.6-released/> for Java 1.8, which is generally available today. Download here <http://drill.apache.org/download/>.
Thank you,
Sudheesh
> On Mar 3, 2016, at 1:40 PM, Rob Terpilowski <RO...@Lynden.com> wrote:
>
> I am attempting to get Apache Drill running on an Ubuntu box with Java 1.8.0_51 as root.
>
> I've downloaded and unzipped the drill tar.gz file.
>
> When I attempt to run the ./bin/drill-embedded command. (I've attempted to run the drill-localhost command as well)
>
> The command sits for a little less than a minute at the line:
> INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
>
> The message is the followed by the following exceptions. Any idea of where I can begin looking for the issue. I changed the port number from 31010 to a number of other different ports with the same result.
>
> Any help would be appreciated.
>
> Thanks,
> -Rob
>
>
> Error: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010 (state=,code=0)
> java.sql.SQLException: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
> at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> at sqlline.Commands.connect(Commands.java:1083)
> at sqlline.Commands.connect(Commands.java:1015)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> at sqlline.SqlLine.dispatch(SqlLine.java:742)
> at sqlline.SqlLine.initArgs(SqlLine.java:528)
> at sqlline.SqlLine.begin(SqlLine.java:596)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
> Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
> at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
> at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
> at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
> at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
> at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
> at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
> at io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
> at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
> at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
> at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
> at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.util.concurrent.ExecutionException: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
> at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
> ... 12 more
> Caused by: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
> ... 6 more
> apache drill 1.4.0
> "just drill it"
> 0: jdbc:drill:zk=local>
>
>
>
>
>
>
>
> java.sql.SQLException: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:159)
> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:64)
> at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> at sqlline.Commands.connect(Commands.java:1083)
> at sqlline.Commands.connect(Commands.java:1015)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> at sqlline.SqlLine.dispatch(SqlLine.java:742)
> at sqlline.SqlLine.initArgs(SqlLine.java:528)
> at sqlline.SqlLine.begin(SqlLine.java:596)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
> Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
> at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
> at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
> at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
> at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
> at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
> at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:460)
> at io.netty.util.concurrent.PromiseTask$RunnableAdapter.call(PromiseTask.java:38)
> at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:120)
> at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
> at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:254)
> at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.util.concurrent.ExecutionException: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
> at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
> ... 12 more
> Caused by: io.netty.channel.ConnectTimeoutException: connection timed out: lisprod03.lynden.com/172.16.218.141:31010
> at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe$1.run(AbstractEpollStreamChannel.java:458)
> ... 6 more
> apache drill 1.4.0
> "got drill?"
> 0: jdbc:drill:zk=local> !quit
> Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit could not bind to port 31010.
>
>
> Server type UserServer
>
>
> [Error Id: 573940e6-9025-48a5-8054-09f9d55612a5 ] (state=,code=0)
> Error: Failure in starting embedded Drillbit: RESOURCE ERROR: Drillbit could not bind to port 31010.
>
>
> Server type UserServer
>
>
> [Error Id: 0980fbda-0d88-4161-8ee0-96c72f714e23 ] (state=,code=0)
>
>
>