Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3023

Drill ODBC Connection not working - attached logs in the details

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Not A Problem
    • Affects Version/s: 0.9.0
    • Fix Version/s: None
    • Component/s: Client - ODBC
    • Labels:
      None

      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

        Attachments

        1. screenshot-1.png
          52 kB
          Murtaza

          Activity

            People

            • Assignee:
              parthc Parth Chandra
              Reporter:
              murtaza.ghodawala Murtaza
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: