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.

Unable to access hue error: Server Error (500) & Table 'hue.axes_accessattempt' doesn't exist"

Unable to access hue error: Server Error (500) & Table 'hue.axes_accessattempt' doesn't exist"

New Contributor

Hi all,

 

Service start:

 

root@IP:~# service hue restart
 * Restarting Hue for Hadoop hue                                                                                                                                                                 [ OK ]
root@IP:~# service hue status
 * Checking status of Hue for Hadoop hue                                                                                                                                                         [ OK ]

Website displays:

http://IP-HERE:8888/accounts/login/?next=/

 

Server Error (500)

Sorry, there's been an error. An email was sent to your administrators. Thank you for your patience.

 

 

After a cluster restart Hue isn't accessible anymore. I'm getting this message: 

Table 'hue.axes_accessattempt' doesn't exist"

This table does not exist in the database at the moment. But I don't see why it should, it was just a restart not an upgrade or some sort. Hue worked fine before the restart.

 

Full error message from runcpserver.log file: 

 

 

[19/Nov/2015 02:31:07 -0800] __init__     WARNING  Couldn't import snappy. Support for snappy compression disabled.
[19/Nov/2015 02:31:07 -0800] settings     INFO     Welcome to Hue 3.9.0
[19/Nov/2015 02:31:08 -0800] __init__     WARNING  Couldn't import snappy. Support for snappy compression disabled.
[19/Nov/2015 02:31:13 -0800] middleware   WARNING  Failed to import tidylib (for debugging). Is libtidy installed?
[19/Nov/2015 02:31:13 -0800] middleware   INFO     Unloading AuditLoggingMiddleware
[19/Nov/2015 02:31:13 -0800] middleware   INFO     Unloading SpnegoMiddleware
[19/Nov/2015 02:31:13 -0800] middleware   INFO     Unloading HueRemoteUserMiddleware
[19/Nov/2015 02:31:13 -0800] decorators   INFO     AXES: BEGIN LOG
[19/Nov/2015 02:31:13 -0800] decorators   INFO     Using django-axes 1.4.0
[19/Nov/2015 02:31:14 -0800] middleware   INFO     Redirecting to login page: /
[19/Nov/2015 02:31:14 -0800] access       INFO     195.130.156.114 -anon- - "GET / HTTP/1.1" -- login redirection
[19/Nov/2015 02:31:14 -0800] decorators   INFO     AXES: Calling decorated function: dt_login
[19/Nov/2015 02:31:14 -0800] middleware   INFO     Processing exception: (1146, "Table 'hue.axes_accessattempt' doesn't exist"): Traceback (most recent call last):
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/handlers/base.py", line 112, in get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/transaction.py", line 371, in inner
    return func(*args, **kwargs)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/django_axes-1.4.0-py2.7.egg/axes/decorators.py", line 297, in decorated_login
    if is_already_locked(request):
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/django_axes-1.4.0-py2.7.egg/axes/decorators.py", line 370, in is_already_locked
    attempts = get_user_attempts(request)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/django_axes-1.4.0-py2.7.egg/axes/decorators.py", line 252, in get_user_attempts
    attempts = _get_user_attempts(request)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/django_axes-1.4.0-py2.7.egg/axes/decorators.py", line 241, in _get_user_attempts
    if not attempts and not LOCK_OUT_BY_COMBINATION_USER_AND_IP:
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/query.py", line 100, in __nonzero__
    self._fetch_all()
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/query.py", line 857, in _fetch_all
    self._result_cache = list(self.iterator())
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/query.py", line 220, in iterator
    for row in compiler.results_iter():
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/sql/compiler.py", line 713, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/sql/compiler.py", line 786, in execute_sql
    cursor.execute(sql, params)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/utils.py", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/mysql/base.py", line 124, in execute
    return self.cursor.execute(query, args)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'hue.axes_accessattempt' doesn't exist")

 

All advice is welcome.

 

Thx!

 

,Jorn

2 REPLIES 2

Re: Unable to access hue error: Server Error (500)

Seems like you are missing some tables in the Hue DB.

Could you run from the Hue root:

./build/env/bin/hue migrate

?

Re: Unable to access hue error: Server Error (500)

New Contributor

The same problem here, solution that helped me:

apt-get install --reinstall hue hue-*

Don't have an account?
Coming from Hortonworks? Activate your account here