Using Helm-chart , we upgraded Hue from " 20220308-140101 " to " 4.7.1 " version ,
When we opened login page , it is showing some errors.
The error in Hue pod is :
**Unknown column 'axes_accessattempt.trusted' in 'field list.**
Steps we followed:
1.Installed Hue with the tag 20220308-140101
Output : Able to successfully login
- We Upgraded hue to 4.7.1 version
Output : Getting below error in login page (In browser)
Logs of the Hue pod:
[02/Feb/2023 07:44:34 -0800] decorators INFO AXES: Calling decorated function: dt_login
[02/Feb/2023 07:44:34 -0800] middleware INFO Processing exception: (1054, “Unknown column ‘axes_accessattempt.trusted’ in ‘field list’”): Traceback (most recent call last):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/utils/decorators.py”, line 185, in inner
return func(*args, **kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 267, in decorated_login
if is_already_locked(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 360, in is_already_locked
for attempt in get_user_attempts(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 218, in get_user_attempts
attempts = _get_user_attempts(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 204, in _get_user_attempts
if not attempts:
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 258, in nonzero
return type(self).bool(self)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 254, in bool
self._fetch_all()
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 53, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
OperationalError: (1054, “Unknown column ‘axes_accessattempt.trusted’ in ‘field list’”)
[02/Feb/2023 07:44:34 -0800] exception ERROR Internal Server Error: /hue/accounts/login
Traceback (most recent call last):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/exception.py”, line 41, in inner
response = get_response(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 249, in _legacy_get_response
response = self._get_response(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 187, in _get_response
response = self.process_exception_by_middleware(e, request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/utils/decorators.py”, line 185, in inner
return func(*args, **kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 267, in decorated_login
if is_already_locked(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 360, in is_already_locked
for attempt in get_user_attempts(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 218, in get_user_attempts
attempts = _get_user_attempts(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 204, in _get_user_attempts
if not attempts:
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 258, in nonzero
return type(self).bool(self)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 254, in bool
self._fetch_all()
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 53, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
OperationalError: (1054, “Unknown column ‘axes_accessattempt.trusted’ in ‘field list’”)
[02/Feb/2023 07:44:34 -0800] decorators INFO AXES: Calling decorated function: dt_login
[02/Feb/2023 07:44:34 -0800] decorators INFO args: (True,)
[02/Feb/2023 07:44:35 -0800] access INFO 10.223.204.253 -anon- - “GET /desktop/debug/is_alive HTTP/1.1” returned in 2ms 200 0
[02/Feb/2023 07:44:35 -0800] access INFO 10.223.204.253 -anon- - “GET /desktop/debug/is_alive HTTP/1.1” returned in 2ms 200 0
[02/Feb/2023 07:44:35 -0800] middleware INFO Redirecting to login page: /
[02/Feb/2023 07:44:35 -0800] access INFO 127.0.0.1 -anon- - “GET / HTTP/1.1” — login redirection
[02/Feb/2023 07:44:35 -0800] access INFO 127.0.0.1 -anon- - “GET / HTTP/1.1” — login redirection
[02/Feb/2023 07:44:35 -0800] access INFO 127.0.0.1 -anon- - “GET / HTTP/1.1” returned in 0ms 302 0
[02/Feb/2023 07:44:35 -0800] access INFO 127.0.0.1 -anon- - “GET / HTTP/1.1” returned in 0ms 302 0
[02/Feb/2023 07:44:35 -0800] decorators INFO AXES: Calling decorated function: dt_login
[02/Feb/2023 07:44:35 -0800] middleware INFO Processing exception: (1054, “Unknown column ‘axes_accessattempt.trusted’ in ‘field list’”): Traceback (most recent call last):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/utils/decorators.py”, line 185, in inner
return func(*args, **kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 267, in decorated_login
if is_already_locked(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 360, in is_already_locked
for attempt in get_user_attempts(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 218, in get_user_attempts
attempts = _get_user_attempts(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 204, in _get_user_attempts
if not attempts:
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 258, in nonzero
return type(self).bool(self)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 254, in bool
self._fetch_all()
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 53, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
OperationalError: (1054, “Unknown column ‘axes_accessattempt.trusted’ in ‘field list’”)
[02/Feb/2023 07:44:35 -0800] exception ERROR Internal Server Error: /hue/accounts/login
Traceback (most recent call last):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/exception.py”, line 41, in inner
response = get_response(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 249, in _legacy_get_response
response = self._get_response(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 187, in _get_response
response = self.process_exception_by_middleware(e, request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/base.py”, line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/utils/decorators.py”, line 185, in inner
return func(*args, **kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 267, in decorated_login
if is_already_locked(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 360, in is_already_locked
for attempt in get_user_attempts(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 218, in get_user_attempts
attempts = _get_user_attempts(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 204, in _get_user_attempts
if not attempts:
^[[I File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 258, in __nonzero__
return type(self).__bool__(self)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 254, in __bool__
self._fetch_all()
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
OperationalError: (1054, “Unknown column ‘axes_accessattempt.trusted’ in ‘field list’”)
[02/Feb/2023 07:44:35 -0800] decorators INFO AXES: Calling decorated function: dt_login
[02/Feb/2023 07:44:35 -0800] decorators INFO args: (True,)
[02/Feb/2023 07:44:37 -0800] access WARNING 127.0.0.1 -anon- - “GET /favicon.ico HTTP/1.1” — 404 not found
[02/Feb/2023 07:44:37 -0800] access WARNING 127.0.0.1 -anon- - “GET /favicon.ico HTTP/1.1” — 404 not found
[02/Feb/2023 07:44:37 -0800] views WARNING User is using Hue 3 UI
[02/Feb/2023 07:44:37 -0800] decorators INFO AXES: Calling decorated function: dt_login
[02/Feb/2023 07:44:37 -0800] decorators INFO args: (True,)
[02/Feb/2023 07:44:37 -0800] exception ERROR Internal Server Error: /favicon.ico
Traceback (most recent call last):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/core/handlers/exception.py”, line 109, in get_exception_response
response = callback(request, **dict(param_dict, exception=exception))
File “/usr/share/hue/desktop/core/src/desktop/views.py”, line 403, in serve_404_error
return render(“404.mako”, request, dict(uri=request.build_absolute_uri()), status=404)
File “/usr/share/hue/desktop/core/src/desktop/lib/django_util.py”, line 241, in render
**kwargs
File “/usr/share/hue/desktop/core/src/desktop/lib/django_util.py”, line 154, in _render_to_response
return django_mako.render_to_response(template, *args, **kwargs)
File “/usr/share/hue/desktop/core/src/desktop/lib/django_mako.py”, line 127, in render_to_response
return HttpResponse(render_to_string(template_name, data_dictionary), **kwargs)
File “/usr/share/hue/desktop/core/src/desktop/lib/django_mako.py”, line 116, in render_to_string_normal
result = template.render(**data_dict)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/template.py”, line 462, in render
return runtime.render(self, self.callable, args, data)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 838, in _render
**kwargs_for_callable(callable, data))
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 873, in _render_context
_exec_template(inherit, lclcontext, args=args, kwargs=kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 899, in exec_template
callable(context, *args, **kwargs)
File “/tmp/tmpOdUwgT/desktop/404.mako.py”, line 58, in render_body
__M_writer(unicode( commonfooter(request, messages) ))
File “/usr/share/hue/desktop/core/src/desktop/views.py”, line 558, in commonfooter
‘collect_usage’: collect_usage(),
File “/usr/share/hue/desktop/core/src/desktop/lib/django_mako.py”, line 116, in render_to_string_normal
result = template.render(**data_dict)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/template.py”, line 462, in render
return runtime.render(self, self.callable, args, data)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 838, in _render
**kwargs_for_callable(callable, data))
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 873, in _render_context
_exec_template(inherit, lclcontext, args=args, kwargs=kwargs)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 899, in exec_template
callable(context, *args, **kwargs)
File “/tmp/tmpOdUwgT/desktop/common_footer.mako.py”, line 49, in render_body
__M_writer(unicode( smart_unicode(login_modal(request).content) ))
File “/usr/share/hue/desktop/core/src/desktop/views.py”, line 533, in login_modal
return desktop.auth.views.dt_login(request, True)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 267, in decorated_login
if is_already_locked(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 360, in is_already_locked
for attempt in get_user_attempts(request):
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 218, in get_user_attempts
attempts = _get_user_attempts(request)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py”, line 204, in _get_user_attempts
if not attempts:
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 258, in nonzero
return type(self).bool(self)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 254, in bool
self._fetch_all()
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/query.py”, line 53, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File “/usr/share/hue/build/env/local/lib/python2.7/site-packages/Django-1.11.29-py2.7.egg/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
OperationalError: (1054, “Unknown column ‘axes_accessattempt.trusted’ in ‘field list’”)
[02/Feb/2023 07:44:37 -0800] views WARNING User is using Hue 3 UI
[02/Feb/2023 07:44:37 -0800] decorators INFO AXES: Calling decorated function: dt_login
[02/Feb/2023 07:44:37 -0800] decorators INFO args: (True,)
[02/Feb/2023 07:44:38 -0800] access INFO 10.223.204.253 -anon- - “GET /desktop/debug/is_alive HTTP/1.1” returned in 3ms 200 0
[02/Feb/2023 07:44:38 -0800] access INFO 10.223.204.253 -anon- - “GET /desktop/debug/is_alive HTTP/1.1” returned in 3ms 200 0