[ https://issues.apache.org/jira/browse/DRILL-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra resolved DRILL-3023. ---------------------------------- Resolution: Not A Problem Closing as this appears to be a version mismatch issue. > Drill ODBC Connection not working - attached logs in the details > ---------------------------------------------------------------- > > Key: DRILL-3023 > URL: https://issues.apache.org/jira/browse/DRILL-3023 > Project: Apache Drill > Issue Type: Bug > Components: Client - ODBC > Affects Versions: 0.9.0 > Reporter: Murtaza > Assignee: Parth Chandra > Priority: Critical > Attachments: screenshot-1.png > > > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)