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

Kali ini gw mendapatkan error pas mau ngakses coordinator id  oozie di hue. Berikut screenshot errornya :

hueerror

Nah pas gw cek lognya terdapat informasi berikut ini :

 

[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”)

nah setelah ditelusuri, ternyata tidak terdapat table hue.desktop_document2 pada database hue. Oleh karena itu untuk cara resolvenya ada 2 cara, yaitu

Pertama bisa menggunakan script bawaannya hue dan nanti akan regenerate ulang struktur table databasenya. Scriptnya yaitu :

./build/env/bin/hue syncdb
./build/env/bin/hue migrate

Kedua dengan cara manual dengan membuat table hue.desktop_document2 pada database huenya, dan untuk informasi struktur tablenya adalah sebagai berikut :

Screenshot from 2016-08-23 10-20-02

 

Setelah dibuat, lalu service huenya direstart kembali.

Advertisements

tinggalkan curcol

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s