Hue give me Server Error (500) when i acces list oozie workflow id to know status

[zaenal rifai]

Hi guys, i have some problem again about Getting 500 when i  Attempting To View Successfully Completed Oozie Coordinator.

it said "Server Error (500) Sorry, there's been an error. An email was sent to your administrators. Thank you for your patience."

and there is option  More Info    View Logs 

when i click more info

​

and when i click view logs

i got error about this

[19/Jul/2016 21:26:56 -0700] conf         ERROR    failed to get spark status
Traceback (most recent call last):
  File "/usr/local/hue/apps/spark/src/spark/conf.py", line 100, in get_spark_status
    get_api(user).get_status()
  File "/usr/local/hue/apps/spark/src/spark/job_server_api.py", line 84, in get_status
    return self._root.get('sessions')
  File "/usr/local/hue/desktop/core/src/desktop/lib/rest/resource.py", line 97, in get
    return self.invoke("GET", relpath, params, headers=headers, allow_redirects=True)
  File "/usr/local/hue/desktop/core/src/desktop/lib/rest/resource.py", line 78, in invoke
    urlencode=self._urlencode)
  File "/usr/local/hue/desktop/core/src/desktop/lib/rest/http_client.py", line 161, in execute
    raise self._exc_class(ex)
RestException: ('Connection aborted.', error(111, 'Connection refused'))

[19/Jul/2016 21:39:28 -0700] middleware   INFO     Processing exception: (1146, "Table 'hue.desktop_document2' doesn't exist"): Traceback (most recent call last):
  File "/usr/local/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/local/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/local/hue/apps/oozie/src/oozie/views/dashboard.py", line 166, in decorate
    return view_func(request, *args, **kwargs)
  File "/usr/local/hue/apps/oozie/src/oozie/views/dashboard.py", line 410, in list_oozie_coordinator
    coordinator = get_history().get_coordinator_from_config(oozie_coordinator.conf_dict)
  File "/usr/local/hue/apps/oozie/src/oozie/models2.py", line 2216, in get_coordinator_from_config
    doc = Document2.objects.get(type='oozie-coordinator2', id=conf_dict.get(Coordinator.HUE_ID))
  File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/manager.py", line 151, in get
    return self.get_queryset().get(*args, **kwargs)
  File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/query.py", line 304, in get
    num = len(clone)
  File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/models/query.py", line 77, in __len__
    self._fetch_all()
  File "/usr/local/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/local/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/local/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/local/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/local/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/local/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/local/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/local/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/local/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/local/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.desktop_document2' doesn't exist")

I attach the following error logs 

--

"Selalu ada pelangi setelah hujan"

[zaenal rifai]

Sorry guys, there is a mistake on email subject, it should be "Hue give me Server Error (500) when i acces list oozie coordinator id to know status" not "Hue give me Server Error (500) when i acces list oozie workflow id to know status"

I will resend with new subject