问题描述
- hue 3.9 hive 查询界面日志无法动态显示
-
进入hue hive查询界面，随便执行一个查询，无法动态显示日志，F12查看日志刷新请求返回：
{"status": 2, "message": "database is locked"}后台报错：
[15/Mar/2016 00:07:37 -0700] api ERROR error in
Traceback (most recent call last):
File "/usr/lib/hue/apps/beeswax/src/beeswax/api.py", line 54, in decorator
return view_fn(request, args, **kwargs)
File "/usr/lib/hue/apps/beeswax/src/beeswax/api.py", line 180, in watch_query_refresh_json
query_history.save_state(state)
File "/usr/lib/hue/apps/beeswax/src/beeswax/models.py", line 243, in save_state
self.save()
File "/usr/lib/hue/apps/beeswax/src/beeswax/models.py", line 189, in save
super(QueryHistory, self).save(*args, **kwargs)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 545, in save
force_update=force_update, update_fields=update_fields)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 573, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 635, in save_table
forced_update)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/base.py", line 679, in _do_update
return filtered._update(values) > 0
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py", line 510, in _update
return query.get_compiler(self.db).execute_sql(None)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/sql/compiler.py", line 980, in execute_sql
cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File "/usr/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 "/usr/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 "/usr/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 "/usr/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 "/usr/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: database is locked*但是在历史记录里能查看到这次查询及结果。不知道什么原因，请大神指教
解决方案
换成mysql作为hue的数据库解决了