Created 03-15-2018 12:18 PM
getting following error show up intermittently when try to go to Beewax on Hue. Then i get "timed out" message. After that Hue hangs.
===========
14/Mar/2018 18:16:36 +0000] thrift_util INFO Thrift saw a socket error: timed out
[14/Mar/2018 18:16:36 +0000] thrift_util WARNING Not retrying thrift call GetSchemas due to socket timeout
[14/Mar/2018 18:16:14 +0000] middleware INFO Processing exception: timed out (code THRIFTSOCKET): None: Traceback (most recent call last): File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.2.3-py2.7.egg/django/core/handlers/base.py", line 100, in get_response response = callback(request, *callback_args, **callback_kwargs) File "/usr/lib/hue/apps/beeswax/src/beeswax/views.py", line 549, in execute_query databases = _get_db_choices(request) File "/usr/lib/hue/apps/beeswax/src/beeswax/views.py", line 1874, in _get_db_choices dbs = _get_databases(request) File "/usr/lib/hue/apps/beeswax/src/beeswax/views.py", line 1869, in _get_databases dbs = db.get_databases() File "/usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 137, in get_databases return self.client.get_databases() File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 825, in get_databases return [table[col] for table in self._client.get_databases()] File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 480, in get_databases res = self.call(self._client.GetSchemas, req) File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 448, in call res = fn(req) File "/usr/lib/hue/desktop/core/src/desktop/lib/thrift_util.py", line 366, in wrapper raise StructuredException('THRIFTSOCKET', str(e), data=None, error_code=502) StructuredException: timed out (code THRIFTSOCKET): None
[14/Mar/2018 18:16:14 +0000] thrift_util INFO Thrift saw a socket error: timed out
[14/Mar/2018 18:16:14 +0000] thrift_util WARNING Not retrying thrift call GetSchemas due to socket timeout
[14/Mar/2018 18:15:26 +0000] views WARNING Autocomplete data fetching error default.None: timed out (code THRIFTSOCKET): None
[14/Mar/2018 18:15:26 +0000] thrift_util INFO Thrift saw a socket error: timed out
[14/Mar/2018 18:15:26 +0000] thrift_util WARNING Not retrying thrift call GetResultSetMetadata due to socket timeout
[14/Mar/2018 18:15:26 +0000] middleware INFO Processing exception: timed out (code THRIFTSOCKET): None: Traceback (most recent call last): File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.2.3-py2.7.egg/django/core/handlers/base.py", line 100, in get_response response = callback(request, *callback_args, **callback_kwargs) File "/usr/lib/hue/apps/beeswax/src/beeswax/views.py", line 549, in execute_query databases = _get_db_choices(request) File "/usr/lib/hue/apps/beeswax/src/beeswax/views.py", line 1874, in _get_db_choices dbs = _get_databases(request) File "/usr/lib/hue/apps/beeswax/src/beeswax/views.py", line 1869, in _get_databases dbs = db.get_databases() File "/usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 137, in get_databases return self.client.get_databases() File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 825, in get_databases return [table[col] for table in self._client.get_databases()] File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 480, in get_databases res = self.call(self._client.GetSchemas, req) File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 448, in call res = fn(req) File "/usr/lib/hue/desktop/core/src/desktop/lib/thrift_util.py", line 366, in wrapper raise StructuredException('THRIFTSOCKET', str(e), data=None, error_code=502) StructuredException: timed out (code THRIFTSOCKET): None
[14/Mar/2018 18:15:26 +0000] thrift_util INFO Thrift saw a socket error: timed out
[14/Mar/2018 18:15:26 +0000] thrift_util WARNING Not retrying thrift call GetSchemas
Created 03-16-2018 01:48 PM
We experience regular Hue hangs after upgrade to HDP 2.6 (from 2.4) without errors in the logs. Maybe time for Django debugging.
Created 05-11-2018 07:26 PM
We resolved the Beeswax timeout issue after upgrading to HDP 2.6 by setting the following parameter for Hive via Ambari:
hive.server2.parallel.ops.in.session=true
This is recommended in the HUE documentation (though it is for HUE 3.9, it also works for HUE 2.6.1):
http://gethue.com/hadoop-hue-3-on-hdp-installation-tutorial/
I hope this helps.