Hi,
I'm getting an error when using Drill 1.5 JDBC drivers.
I have 2 hosts: Host A running Zookeeper, host B running a Drillbit.
If use a JDBC URL to connect directly to B, it works OK.
If I try to connect to A via ZK, I get, the error below.
Ports are open (2181,8047,31010 - 31012, ICMP), Hosts files contains entries
for both hosts. Telnet and ping work for both hosts to the other.
The odd thing is if I connect from B using bin/drill-conf (where drill-conf
points to ZK on A), the connection works.
It's clearly some kind of networking error, but what?????
Cheers
James
java.util.concurrent.ExecutionException: java.lang.RuntimeException:
java.sql.SQLException: Failure in connecting to Drill:
oadd.org.apache.drill.exec.rpc.RpcException: CONNECTION :
java.nio.channels.UnresolvedAddressException
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.sql.SQLException: Failure in
connecting to Drill: oadd.org.apache.drill.exec.rpc.RpcException: CONNECTION :
java.nio.channels.UnresolvedAddressException
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 5 more
Caused by: java.sql.SQLException: Failure in connecting to Drill:
oadd.org.apache.drill.exec.rpc.RpcException: CONNECTION :
java.nio.channels.UnresolvedAddressException
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
oadd.net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more
Caused by: oadd.org.apache.drill.exec.rpc.RpcException: CONNECTION :
java.nio.channels.UnresolvedAddressException
at
oadd.org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:448)
at
oadd.org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:237)
at
oadd.org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:200)
at
oadd.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
at
oadd.io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:567)
at
oadd.io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
at
oadd.io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.connect(AbstractNioChannel.java:235)
at
oadd.io.netty.channel.DefaultChannelPipeline$HeadContext.connect(DefaultChannelPipeline.java:1089)
at
oadd.io.netty.channel.AbstractChannelHandlerContext.invokeConnect(AbstractChannelHandlerContext.java:543)
at
oadd.io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:528)
at
oadd.io.netty.channel.ChannelOutboundHandlerAdapter.connect(ChannelOutboundHandlerAdapter.java:47)
at
oadd.io.netty.channel.AbstractChannelHandlerContext.invokeConnect(AbstractChannelHandlerContext.java:543)
at
oadd.io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:528)
at
oadd.io.netty.channel.ChannelDuplexHandler.connect(ChannelDuplexHandler.java:50)
at
oadd.io.netty.channel.AbstractChannelHandlerContext.invokeConnect(AbstractChannelHandlerContext.java:543)
at
oadd.io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:528)
at
oadd.io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:510)
at
oadd.io.netty.channel.DefaultChannelPipeline.connect(DefaultChannelPipeline.java:909)
at
oadd.io.netty.channel.AbstractChannel.connect(AbstractChannel.java:203)
at oadd.io.netty.bootstrap.Bootstrap$2.run(Bootstrap.java:165)
at
oadd.io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)
at
oadd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)
at
oadd.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
... 1 more
Caused by: java.util.concurrent.ExecutionException:
java.nio.channels.UnresolvedAddressException
at
oadd.io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
at
oadd.org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:213)
... 22 more
Caused by: java.nio.channels.UnresolvedAddressException
at sun.nio.ch.Net.checkAddress(Unknown Source)
at sun.nio.ch.SocketChannelImpl.connect(Unknown Source)
at
oadd.io.netty.channel.socket.nio.NioSocketChannel.doConnect(NioSocketChannel.java:209)
at
oadd.io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.connect(AbstractNioChannel.java:199)
... 17 more
In order to protect our email recipients, the Paddy Power Betfair plc group of
companies use MessageLabs to scan all Incoming and Outgoing mail for viruses.
Paddy Power Betfair may monitor the content of email sent and received for the
purpose of ensuring compliance with its policies and procedures.
