title: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient (Ubuntu)
body: <p>I have successfully installed Java, Hadoop MySQL. I am getting this error while running hive. I was getting the file permission error before which got fixed by making the metastore_db folder under hive folder to 777 permission mode. How can i resolve this issue. </p>
  
  <pre><code>SLF4J: Class path contains multiple SLF4J bindings.
  SLF4J: Found binding in [jar:file:/usr/lib/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  SLF4J: Found binding in [jar:file:/usr/lib/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
  
  Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-2.1.1.jar!/hive-log4j2.properties Async: true
  Exception in thread "main" java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
      at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:591)
      at org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:531)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:705)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:641)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
  Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
      at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:226)
      at org.apache.hadoop.hive.ql.metadata.Hive.&lt;init&gt;(Hive.java:366)
      at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:310)
      at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:290)
      at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:266)
      at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:558)
      ... 9 more
  Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1654)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.&lt;init&gt;(RetryingMetaStoreClient.java:80)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101)
      at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3367)
      at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3406)
      at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3386)
      at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3640)
      at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:236)
      at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:221)
      ... 14 more
  Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1652)
      ... 23 more
  Caused by: MetaException(message:Version information not found in metastore. )
      at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7753)
      at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:7731)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101)
      at com.sun.proxy.$Proxy20.verifySchema(Unknown Source)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:565)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:626)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.&lt;init&gt;(RetryingHMSHandler.java:78)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
      at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6490)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.&lt;init&gt;(HiveMetaStoreClient.java:238)
      at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.&lt;init&gt;(SessionHiveMetaStoreClient.java:70)
      ... 28 more
  </code></pre>
  
  <p>I tried even moving the db.lck and dbex.lck files It did not work. I restarted Hadoop and machine several times after the changes made nothing worked. Help !
  Thanks in advance.</p>
  
  <p>hive-site.xml</p>
  
  <pre><code>&lt;configuration&gt;     &lt;property&gt;
        &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;
        &lt;value&gt;jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true&lt;/value&gt;
        &lt;description&gt;metadata is stored in a MySQL server&lt;/description&gt;    &lt;/property&gt;
  
     &lt;property&gt;
        &lt;name&gt;javax.jdo.option.ConnectionDriverName&lt;/name&gt;
        &lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt;
        &lt;description&gt;MySQL JDBC driver class&lt;/description&gt;    &lt;/property&gt;
  
     &lt;property&gt;
        &lt;name&gt;javax.jdo.option.ConnectionUserName&lt;/name&gt;
        &lt;value&gt;root&lt;/value&gt;
        &lt;description&gt;USER NAME&lt;/description&gt;    &lt;/property&gt;
  
     &lt;property&gt;
        &lt;name&gt;javax.jdo.option.ConnectionPassword&lt;/name&gt;
        &lt;value&gt;root&lt;/value&gt;
        &lt;description&gt;PASSWORD ***&lt;/description&gt;    &lt;/property&gt;  &lt;/configuration&gt;
  </code></pre>