[DRILL-3023] Drill ODBC Connection not working - attached logs in the details

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Not A Problem
• Affects Version/s: 0.9.0
• Component/s: Client - ODBC
• Assignee: Parth Chandra
• Reporter: Murtaza
• Created: 11/May/15 11:50
• Updated: 02/Jul/15 00:20
• Resolved: 02/Jul/15 00:20

Description

Getting below error in the sqlline log file.

Apache Drill 0.9 is installed on CentOS 64bit, embedded drillbits. Trying to access ODBC from Windows machine after installing ODBC 32bit & 64bit drivers, both have same errors.

2015-05-11 14:47:29,652 [UserServer-1] ERROR o.a.drill.exec.rpc.user.UserServer - Error 2845b981-804a-44d4-a9f1-88866f778c26 in Handling handshake request: RPC_VERSION_MISMATCH, Invalid rpc version. Expected 5, actual 3.
2015-05-11 14:47:29,653 [UserServer-1] ERROR o.a.d.exec.rpc.RpcExceptionHandler - Exception in pipeline. Closing channel between local /172.16.98.101:31010 and remote /10.16.17.114:61346
io.netty.handler.codec.DecoderException: org.apache.drill.exec.rpc.RpcException: Handshake request failed: Invalid rpc version. Expected 5, actual 3.
at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:99) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:161) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:787) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:130) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) [netty-transport-4.0.24.Final.jar:4.0.24.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116) [netty-common-4.0.24.Final.jar:4.0.24.Final]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_60]
Caused by: org.apache.drill.exec.rpc.RpcException: Handshake request failed: Invalid rpc version. Expected 5, actual 3.
at org.apache.drill.exec.rpc.user.UserServer$1.consumeHandshake(UserServer.java:181) ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
at org.apache.drill.exec.rpc.user.UserServer$1.consumeHandshake(UserServer.java:171) ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
at org.apache.drill.exec.rpc.AbstractHandshakeHandler.decode(AbstractHandshakeHandler.java:57) ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
at org.apache.drill.exec.rpc.AbstractHandshakeHandler.decode(AbstractHandshakeHandler.java:29) ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
... 19 common frames omitted
2015-05-11 14:47:29,653 [UserServer-1] INFO o.a.drill.exec.rpc.user.UserServer - Channel closed between local /172.16.98.101:31010 and remote /10.16.17.114:61346