Hive
  1. Hive
  2. HIVE-7167

Hive Metastore fails to start with SQLServerException

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 0.14.0
    • Fix Version/s: 0.14.0
    • Component/s: Metastore
    • Labels:

      Description

      In the case that hiveserver2 uses embedded metastore and hiveserver uses remote metastore, this exception comes up when hiveserver2 and hiveserver are started simultaneously.

      metastore service status is running but when I launch hive cli, I get following metastore connection error:

      C:\apps\dist\hive-0.13.0.2.1.2.0-1660\bin>hive.cmd

      14/05/09 17:40:03 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no l
      onger has any effect.  Use hive.hmshandler.retry.* instead
      
      Logging initialized using configuration in file:/C:/apps/dist/hive-0.13.0.2.1.2.
      0-1660/conf/hive-log4j.properties
      Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeExceptio
      n: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
              at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.jav
      a:347)
              at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
              at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:601)
              at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
      Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.h
      ive.metastore.HiveMetaStoreClient
              at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStore
      Utils.java:1413)
              at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(Retry
      ingMetaStoreClient.java:62)
              at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(Ret
      ryingMetaStoreClient.java:72)
              at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.ja
      va:2444)
              at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2456)
              at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.jav
      a:341)
              ... 7 more
      Caused by: java.lang.reflect.InvocationTargetException
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
      orAccessorImpl.java:57)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
      onstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
              at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStore
      Utils.java:1411)
              ... 12 more
      Caused by: MetaException(message:Could not connect to meta store using any of th
      e URIs provided. Most recent failure: org.apache.thrift.transport.TTransportExce
      ption: java.net.ConnectException: Connection refused: connect
              at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
              at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaSto
      reClient.java:336)
              at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaS
      toreClient.java:214)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
      orAccessorImpl.java:57)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
      onstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
              at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStore
      Utils.java:1411)
              at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(Retry
      ingMetaStoreClient.java:62)
              at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(Ret
      ryingMetaStoreClient.java:72)
              at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.ja
      va:2444)
              at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2456)
              at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.jav
      a:341)
              at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
              at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:601)
              at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
      Caused by: java.net.ConnectException: Connection refused: connect
              at java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)
              at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.ja
      va:339)
              at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocket
      Impl.java:200)
              at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java
      :182)
              at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
              at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
              at java.net.Socket.connect(Socket.java:579)
              at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
              ... 19 more
      )
              at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaSto
      reClient.java:382)
              at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaS
      toreClient.java:214)
              ... 17 more
      

      Because of this issue, we are seeing many failures in hive related system tests.

      1. HIVE-7167.1.patch
        3 kB
        Xiaobing Zhou
      2. HIVE-7167.2.patch
        2 kB
        Xiaobing Zhou
      3. HIVE-7167.3.patch
        3 kB
        Xiaobing Zhou

        Issue Links

          Activity

            People

            • Assignee:
              Xiaobing Zhou
              Reporter:
              Xiaobing Zhou
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development