Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HUE renders extremely slow

Highlighted

HUE renders extremely slow

Contributor

I recently migrated the HUE database to MySQL as well as the hive metastore database 

and then upgraded Cloudera manager to 5.12 but using a 5.11 components  (so HUE 3.9.0+cdh5.11.1+5073) 
My users have noticed that HUE takes a tremendous amount of time to render its pages
Note cross post on google group hue users
 
I extended the timeout settings and under an incognito window (to ensure nothing is cached) 
I was able to get this message
 
Lock wait timeout exceeded
 
Traceback:
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/handlers/base.py" in get_response
  112.                     response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/transaction.py" in inner
  371.                 return func(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/django_axes-1.5.0-py2.7.egg/axes/decorators.py" in decorated_login
  304.         response = func(request, *args, **kwargs)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/desktop/core/src/desktop/auth/views.py" in dt_login
  121.         login(request, user)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/contrib/auth/__init__.py" in login
  89.     user_logged_in.send(sender=user.__class__, request=request, user=user)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/dispatch/dispatcher.py" in send
  185.             response = receiver(signal=self, sender=sender, **named)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/contrib/auth/models.py" in update_last_login
  30.     user.save(update_fields=['last_login'])
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/base.py" in save
  545.                        force_update=force_update, update_fields=update_fields)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/base.py" in save_base
  573.             updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/base.py" in _save_table
  635.                                       forced_update)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/base.py" in _do_update
  679.         return filtered._update(values) > 0
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/query.py" in _update
  510.         return query.get_compiler(self.db).execute_sql(None)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/sql/compiler.py" in execute_sql
  980.         cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/sql/compiler.py" in execute_sql
  786.         cursor.execute(sql, params)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/util.py" in execute
  53.                 return self.cursor.execute(sql, params)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/utils.py" in __exit__
  99.                 six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/util.py" in execute
  53.                 return self.cursor.execute(sql, params)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/mysql/base.py" in execute
  124.             return self.cursor.execute(query, args)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/cursors.py" in execute
  205.             self.errorhandler(self, exc, value)
File "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/connections.py" in defaulterrorhandler
  36.     raise errorclass, errorvalue
Exception Type: OperationalError at /accounts/login/
Exception Value: (1205, 'Lock wait timeout exceeded; try restarting transaction')
 
 
On the runscpserver log I get 
 
[04/Aug/2017 07:53:13 -0700] wsgiserver   ERROR    WSGI (<WorkerThread(CP WSGIServer Thread-33, started 140223207950080)>) error: [('SSL routines', 'SSL23_WRITE', 'ssl handshake failure')]
Traceback (most recent call last):
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1304, in run
    conn.communicate()
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1214, in communicate
    req.simple_response("408 Request Timeout")
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 618, in simple_response
    self.wfile.sendall("".join(buf))
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1139, in sendall
    return self._safe_call(False, super(SSL_fileobject, self).sendall, *args, **kwargs)
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1091, in _safe_call
    return call(*args, **kwargs)
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 753, in sendall
    bytes_sent = self.send(data)
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1142, in send
    return self._safe_call(False, super(SSL_fileobject, self).send, *args, **kwargs)
  File "/opt/cloudera/parcels/CDH-5.4.11-1.cdh5.4.11.p0.5/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1121, in _safe_call
    raise FatalSSLAlert(*e.args) 
 
but I am using self signed certs
 
 
Any thoughts or help would be appreciated
2 REPLIES 2

Re: HUE renders extremely slow

Explorer

Hello All.

Please help me for same issue.

 

 

 

 

 

Thanks

HadoopHelp

Re: HUE renders extremely slow

Explorer

Hi.

I was criying like anything for this solution so finally i found this :-

Not enough RAM memory to run the job in your/my current cluster.

 

 

 

 

 

Thanks

HadoopHelp