hadoop综合问题记录

1、hdfs无法启动

错误：

2018-04-25 14:36:09,293 - Retrying after 10 seconds. Reason: Execution of '/usr/hdp/current/hadoop-hdfs-namenode/bin/hdfs dfsadmin -fs hdfs://master:8020 -safemode get | grep 'Safe mode is OFF'' returned 1. safemode: Call From master/192.168.12.101 to master:8020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefusedsafemode: Call From master/192.168.12.101 to master:8020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused

解决：

# su hdfs //切换到hdfs用户，若关闭了hdfs的权限则可略过这一步

# hadoop dfsadmin -safemode leave //让namenode离开安全模式

2、oozie启动失败

错误：

"Column name pattern can not be NULL or empty"

解决：网上有两种处理方式，一种是将mysql-connector-java版本更换成5.1.38版本或者更低的版本，这种方式我处理还是失败了，我采用的是第二种方式，配置oozie的Database URL为

jdbc:mysql://master/oozie?nullNamePatternMatchesAll=true

3、hive点击Hive View 2.0 Go to View出现USER HOME CHECK 的错误

错误：

Service 'userhome' check failed:java.io.FileNotFoundException: File does not exist: /user/admin    at sun.reflect.GeneratedConstructorAccessor226.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

解决：

[root@master ~]# sudo su - hdfs[root@master ~]# hdfs dfs -mkdir /user/admin[root@master ~]# hdfs dfs -chown admin:hdfs /user/admin

4、hive的MetaStore启动了以后又自动停止了

错误：

Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient    at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:552)    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:62)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:498)    at org.apache.hadoop.util.RunJar.run(RunJar.java:233)    at org.apache.hadoop.util.RunJar.main(RunJar.java:148)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:1566)    at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.
     
      (RetryingMetaStoreClient.java:92)    at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:138)    at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:110)    at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3526)    at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3558)    at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:533)    ... 8 moreCaused by: java.lang.reflect.InvocationTargetException    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)    at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1564)    ... 14 moreCaused by: MetaException(message:Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused (Connection refused)    at org.apache.thrift.transport.TSocket.open(TSocket.java:226)    at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:487)    at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.
      
       (HiveMetaStoreClient.java:282)    at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.
       
        (SessionHiveMetaStoreClient.java:76)    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)    at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1564)    at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.
        
         (RetryingMetaStoreClient.java:92)    at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:138)    at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:110)    at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3526)    at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3558)    at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:533)    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:62)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:498)    at org.apache.hadoop.util.RunJar.run(RunJar.java:233)    at org.apache.hadoop.util.RunJar.main(RunJar.java:148)

解决：hive.metastore.uris尝试连接9083端口，netstat查看该端口确实没有被监听，第一反应是hiveserver没有正常启动。查看hiveserver进程却存在，只是监听10000端口。查看hive-site.xml配置，hive客户端连接9083端口，而hiveserver默认监听10000，找到问题根源了，但是我修改成10000还是不行，查看配置，还有一个参数是hive.server2.thrift.http.port，值是10001，我配置成了10001端口，然后就成功了。后面不能成功的查询，问题出现在了hive的源配置mysql，后面重新安装了新的mysql，就成功了。

5、centos7安装PyGreSQL

错误：

sh: pg_config: command not found    Traceback (most recent call last):      File "
     
      ", line 1, in 
      
             File "/tmp/pip-build-MZLWmC/PyGreSQL/setup.py", line 88, in 
       
                pg_version = pg_version()      File "/tmp/pip-build-MZLWmC/PyGreSQL/setup.py", line 82, in pg_version        match = re.search(r'(\d+)\.(\d+)', pg_config('version'))      File "/tmp/pip-build-MZLWmC/PyGreSQL/setup.py", line 74, in pg_config        raise Exception("pg_config tool is not available.")    Exception: pg_config tool is not available.

　　解决：安装 postgresql-devel 命令：yum -y install postgresql-devel

转载于:https://www.cnblogs.com/zhang-ke/p/8944408.html

你可能感兴趣的文章