Created 02-04-2017 09:48 AM
Hi There,
I keep getting the below error when selecting Beesewax(Hive UI). "Could not connect to localhost:10000". Below are the logs. I get the same error when selecting HCatalog and for file browser selection please refer to screenshot below LOG1
LOG 1
[04/Feb/2017 15:09:10 +0000] access WARNING 192.168.35.1 hue - "GET /logs HTTP/1.0"
[04/Feb/2017 15:09:06 +0000] access INFO 192.168.35.1 hue - "GET /server_details HTTP/1.0"
[04/Feb/2017 15:09:04 +0000] resource DEBUG GET Got response: {"systemMode":"NORMAL"}
[04/Feb/2017 15:09:04 +0000] http_client DEBUG REST invocation: curl -X GET 'http://sandbox.hortonworks.com:11000/oozie/v1/admin/status?timezone=America%2FLos_Angeles&user.name=hue&doAs=hue'
[04/Feb/2017 15:09:04 +0000] http_client DEBUG REST invocation: curl -X GET 'http://sandbox.hortonworks.com:50111/templeton/v1/status?user.name=hue&doAs=hue'
[04/Feb/2017 15:09:04 +0000] thrift_util INFO Thrift saw a transport exception: Could not connect to localhost:10000
[04/Feb/2017 15:09:04 +0000] thrift_util WARNING Out of retries for thrift call: GetSchemas
[04/Feb/2017 15:09:04 +0000] thrift_util INFO Thrift exception; retrying: Could not connect to localhost:10000
[04/Feb/2017 15:09:04 +0000] thrift_util INFO Thrift exception; retrying: Could not connect to localhost:10000
[04/Feb/2017 15:09:04 +0000] hive_server2_lib DEBUG HS2 call is going to use session with id 1
[04/Feb/2017 15:09:04 +0000] dbms DEBUG Query Server: {'server_host': 'localhost', 'cache_tag': '', 'server_port': 10000, 'server_name': 'beeswax', 'transport_mode': u'binary', 'http_url': u'http://localhost:10001/cliservice', 'proprietary_session': False, 'session_id': None, 'principal': None}
[04/Feb/2017 15:09:04 +0000] views ERROR Error in config validation by liboozie: HTTPConnectionPool(host='sandbox.hortonworks.com', port=50070): Max retries exceeded with url: /webhdfs/v1/user/oozie/share/lib?doas=hue&user.name=hue&op=GETFILESTATUS (Caused by <class 'socket.error'>: [Errno 111] Connection refused) Traceback (most recent call last): File "/usr/lib/hue/desktop/core/src/desktop/views.py", line 355, in _get_config_errors error_list.extend(validator(user)) File "/usr/lib/hue/desktop/libs/liboozie/src/liboozie/conf.py", line 80, in config_validator message=_('Oozie Share Lib not installed in default location.'))) File "/usr/lib/hue/desktop/core/src/desktop/lib/conf.py", line 658, in validate_path if path is None or not fs.exists(path): File "/usr/lib/hue/desktop/libs/hadoop/src/hadoop/fs/webhdfs.py", line 217, in exists return self._stats(path) is not None File "/usr/lib/hue/desktop/libs/hadoop/src/hadoop/fs/webhdfs.py", line 205, in _stats raise ex WebHdfsException: HTTPConnectionPool(host='sandbox.hortonworks.com', port=50070): Max retries exceeded with url: /webhdfs/v1/user/oozie/share/lib?doas=hue&user.name=hue&op=GETFILESTATUS (Caused by <class 'socket.error'>: [Errno 111] Connection refused)
[04/Feb/2017 15:09:04 +0000] http_client DEBUG REST invocation: curl -X GET 'http://sandbox.hortonworks.com:50070/webhdfs/v1/user/oozie/share/lib?doas=hue&user.name=hue&op=GETFILESTATUS'
[04/Feb/2017 15:09:04 +0000] resource DEBUG GET Got response: {"systemMode":"NORMAL"}
[04/Feb/2017 15:09:04 +0000] http_client DEBUG REST invocation: curl -X GET 'http://sandbox.hortonworks.com:11000/oozie/v1/admin/status?timezone=America%2FLos_Angeles&user.name=hue&doAs=hue'
[04/Feb/2017 15:09:04 +0000] resource DEBUG GET Got response: {"apps":null}
[04/Feb/2017 15:09:04 +0000] http_client DEBUG REST invocation: curl -X GET -H Accept: application/json 'http://sandbox.hortonworks.com:8088/ws/v1/cluster/apps'
[04/Feb/2017 15:09:04 +0000] webhdfs INFO WebHdfs at http://sandbox.hortonworks.com:50070/webhdfs/v1/ -- Validation error: HTTPConnectionPool(host='sandbox.hortonworks.com', port=50070): Max retries exceeded with url: /webhdfs/v1/?doas=hdfs&user.name=hue&op=GETFILESTATUS (Caused by <class 'socket.error'>: [Errno 111] Connection refused)
[04/Feb/2017 15:09:04 +0000] http_client DEBUG REST invocation: curl -X GET 'http://sandbox.hortonworks.com:50070/webhdfs/v1/?doas=hdfs&user.name=hue&op=GETFILESTATUS'
[04/Feb/2017 15:09:04 +0000] webhdfs ERROR Failed to determine superuser of WebHdfs at http://sandbox.hortonworks.com:50070/webhdfs/v1/: HTTPConnectionPool(host='sandbox.hortonworks.com', port=50070): Max retries exceeded with url: /webhdfs/v1/?doas=hue&user.name=hue&op=GETFILESTATUS (Caused by <class 'socket.error'>: [Errno 111] Connection refused) Traceback (most recent call last): File "/usr/lib/hue/desktop/libs/hadoop/src/hadoop/fs/webhdfs.py", line 117, in superuser sb = self.stats('/') File "/usr/lib/hue/desktop/libs/hadoop/src/hadoop/fs/webhdfs.py", line 211, in stats res = self._stats(path) File "/usr/lib/hue/desktop/libs/hadoop/src/hadoop/fs/webhdfs.py", line 205, in _stats raise ex WebHdfsException: HTTPConnectionPool(host='sandbox.hortonworks.com', port=50070): Max retries exceeded with url: /webhdfs/v1/?doas=hue&user.name=hue&op=GETFILESTATUS (Caused by <class 'socket.error'>: [Errno 111] Connection refused)
[04/Feb/2017 15:09:04 +0000] http_client DEBUG REST invocation: curl -X GET 'http://sandbox.hortonworks.com:50070/webhdfs/v1/?doas=hue&user.name=hue&op=GETFILESTATUS'
[04/Feb/2017 15:09:04 +0000] webhdfs DEBUG Initializing Hadoop WebHdfs: http://sandbox.hortonworks.com:50070/webhdfs/v1/ (security: False, superuser: None)
[04/Feb/2017 15:09:04 +0000] access INFO 192.168.35.1 hue - "GET /debug/check_config HTTP/1.0"
[04/Feb/2017 15:09:04 +0000] access INFO 192.168.35.1 hue - "GET /debug/check_config HTTP/1.0"
Log 2 WebHdfsException at /filebrowser/ HTTPConnectionPool(host='sandbox.hortonworks.com', port=50070): Max retries exceeded with url: /webhdfs/v1/user/hue?doas=hue&user.name=hue&op=GETFILESTATUS (Caused by <class 'socket.error'>: [Errno 111] Connection refused)Request Method:GETRequest URL:http://192.168.35.128:8000/filebrowser/Django Version:1.2.3Exception Type:WebHdfsExceptionException Value:HTTPConnectionPool(host='sandbox.hortonworks.com', port=50070): Max retries exceeded with url: /webhdfs/v1/user/hue?doas=hue&user.name=hue&op=GETFILESTATUS (Caused by <class 'socket.error'>: [Errno 111] Connection refused)Exception Location:/usr/lib/hue/desktop/libs/hadoop/src/hadoop/fs/webhdfs.py in _stats, line 205Python Executable:/usr/bin/python2.6Python Version:2.6.6Python Path:['', '/usr/lib/hue/build/env/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/pip-1.4.1-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Babel-0.9.6-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/BabelDjango-0.2.2-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Beaker-1.4.2-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.2.3-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.7.2-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Markdown-2.0.3-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/MarkupSafe-0.9.3-py2.6-linux-x86_64.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/MySQL_python-1.2.3c1-py2.6-linux-x86_64.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Paste-1.7.2-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/PyYAML-3.09-py2.6-linux-x86_64.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Pygments-1.3.1-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/South-0.8.2-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Spawning-0.9.6-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/Twisted-8.2.0-py2.6-linux-x86_64.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/anyjson-0.3.1-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/avro-1.5.0-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/billiard-2.7.3.28-py2.6-linux-x86_64.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/celery-3.0.19-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/configobj-4.6.0-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/defusedxml-0.4.1-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/django_auth_ldap-1.2.1-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/django_celery-3.0.17-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/django_extensions-0.5-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/django_nose-0.5-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/elementtree-1.2.6_20050316-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/enum-0.4.4-py2.6.egg', '/usr/lib/hue/build/env/lib/python2.6/site-packages/eventlet-0.9
Created 02-06-2017 05:00 PM
Thanks @ Artem and @ Dileep Kumar. I have re-installed VMWare and it has fixed the issue.
Created 02-04-2017 03:06 PM
Check whether namenode is in standby, make sure all services are up.
Created 02-05-2017 04:36 PM
Thanks for reply @Artem Ervits. I have tried doing it and still facing the same issue.
Created 02-05-2017 09:00 PM
Try browsing to Ambari http://sandbox.hortonworks.com:8080
Created 02-06-2017 12:56 PM
@Pavani N Check the following params
core-site.xml
<property>
<name>hadoop.proxyuser.<loginuser>.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.<loginuser>.groups</name>
<value>*</value>
</property>
hdfs-site.xml
<property>
<name>dfs.webhdfs.enabled</name>
<value>true</value>
</property>
Created 02-06-2017 05:00 PM
Thanks @ Artem and @ Dileep Kumar. I have re-installed VMWare and it has fixed the issue.
Created 02-15-2017 05:27 PM
Hi!
I got the same error here.
I followed all the instructions here :
All the Hive Servers in Ambari : WebHCat, Hive Metastore and HiveServer2 are up.
I checked the properties in core-site.xml and hdfs-site.xml as @Dileep Kumar Chiguruvada said
When I click on Beewax in Hue I still get Error! Could not connect to http://sandbox.hortonworks.com:10000
Does anyone know how to overcome this issue?