Created on 04-27-2015 02:14 PM - edited 09-16-2022 02:27 AM
Hi,
After upgrading from cdh 5.3.3 to cdh 5.4 using parcels, I couldn't access Hue web ui. I'm getting this error:
Hue OperationalError: no such column: search_collection.owner_id error
Traceback (most recent call last): File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1198, in communicate req.respond() File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 568, in respond self._respond() File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 580, in _respond response = self.wsgi_app(self.environ, self.start_response) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/handlers/wsgi.py", line 206, in __call__ response = self.get_response(request) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/handlers/base.py", line 194, in get_response response = self.handle_uncaught_exception(request, resolver, sys.exc_info()) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/handlers/base.py", line 236, in handle_uncaught_exception return callback(request, **param_dict) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/views.py", line 304, in serve_500_error return render("500.mako", request, {'traceback': traceback.extract_tb(exc_info[2])}) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/django_util.py", line 225, in render **kwargs) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/django_util.py", line 146, in _render_to_response return django_mako.render_to_response(template, *args, **kwargs) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/django_mako.py", line 125, in render_to_response return HttpResponse(render_to_string(template_name, data_dictionary), **kwargs) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/django_mako.py", line 114, in render_to_string_normal result = template.render(**data_dict) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/template.py", line 443, in render return runtime._render(self, self.callable_, args, data) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/runtime.py", line 786, in _render **_kwargs_for_callable(callable_, data)) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/runtime.py", line 818, in _render_context _exec_template(inherit, lclcontext, args=args, kwargs=kwargs) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/runtime.py", line 844, in _exec_template callable_(context, *args, **kwargs) File "/tmp/tmpPwq6ST/desktop/500.mako.py", line 39, in render_body __M_writer(unicode( commonheader(_('Error'), "", user) )) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/views.py", line 375, in commonheader 'is_demo': desktop.conf.DEMO_ENABLED.get() File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/lib/django_mako.py", line 114, in render_to_string_normal result = template.render(**data_dict) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/template.py", line 443, in render return runtime._render(self, self.callable_, args, data) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/runtime.py", line 786, in _render **_kwargs_for_callable(callable_, data)) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/runtime.py", line 818, in _render_context _exec_template(inherit, lclcontext, args=args, kwargs=kwargs) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Mako-0.8.1-py2.6.egg/mako/runtime.py", line 844, in _exec_template callable_(context, *args, **kwargs) File "/tmp/tmpPwq6ST/desktop/common_header.mako.py", line 610, in render_body if not collections: File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py", line 100, in __nonzero__ self._fetch_all() File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py", line 857, in _fetch_all self._result_cache = list(self.iterator()) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py", line 220, in iterator for row in compiler.results_iter(): File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/sql/compiler.py", line 713, in results_iter for rows in self.execute_sql(MULTI): File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/sql/compiler.py", line 786, in execute_sql cursor.execute(sql, params) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/backends/util.py", line 53, in execute return self.cursor.execute(sql, params) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/utils.py", line 99, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/backends/util.py", line 53, in execute return self.cursor.execute(sql, params) File "/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/backends/sqlite3/base.py", line 452, in execute return Database.Cursor.execute(self, query, params) OperationalError: no such column: search_collection.owner_id
This is not the first time I do an upgrade using parcels, all the previous upgrade were successfull, but this time I don't know what I did wrong.
Thanks
Created 04-28-2015 07:02 AM
The solution was replacing /var/lib/hue/desktop.db by /opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/desktop.db
Created 04-28-2015 07:02 AM
The solution was replacing /var/lib/hue/desktop.db by /opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/desktop.db