Hue to Beewax -Time out on HDP 2.6 and Hue 2.6

manish_shukla · ‎03-15-2018

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

rzuidhof · ‎03-16-2018

We experience regular Hue hangs after upgrade to HDP 2.6 (from 2.4) without errors in the logs. Maybe time for Django debugging.

mark_boyd · ‎05-11-2018

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.