DatabaseError: database is locked

rube — Tue, 21 Apr 2026 14:01:26 GMT

cdh5.0.2

hue3.5

Save Query Results In an HDFS file，when it does not complete，I can not do other hue actions，just like hue hangs.

the exception:

Traceback (most recent call last):
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/core/handlers/base.py", line 111, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File "/usr/lib/hue/desktop/core/src/desktop/views.py", line 69, in home
'json_documents': json.dumps(massaged_documents_for_json(docs, request.user)),
File "/usr/lib/hue/desktop/core/src/desktop/api.py", line 55, in massaged_documents_for_json
return [massage_doc_for_json(doc, user) for doc in documents]
File "/usr/lib/hue/desktop/core/src/desktop/api.py", line 59, in massage_doc_for_json
perms = doc.list_permissions()
File "/usr/lib/hue/desktop/core/src/desktop/models.py", line 481, in list_permissions
return DocumentPermission.objects.list(document=self)
File "/usr/lib/hue/desktop/core/src/desktop/models.py", line 536, in list
perm, created = DocumentPermission.objects.get_or_create(doc=document, perms=DocumentPermission.READ_PERM)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/models/manager.py", line 134, in get_or_create
return self.get_query_set().get_or_create(**kwargs)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/models/query.py", line 452, in get_or_create
obj.save(force_insert=True, using=self.db)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/models/base.py", line 463, in save
self.save_base(using=using, force_insert=force_insert, force_update=force_update)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/models/base.py", line 551, in save_base
result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/models/manager.py", line 203, in _insert
return insert_query(self.model, objs, fields, **kwargs)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/models/query.py", line 1593, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/models/sql/compiler.py", line 912, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/db/backends/sqlite3/base.py", line 344, in execute
return Database.Cursor.execute(self, query, params)
DatabaseError: database is locked

help,thank you very much.

Re: DatabaseError: database is locked

abe — Tue, 24 Jun 2014 14:26:08 GMT

This is a problem with Hue and SQLite in a multithreaded environment. A workaround to have this error be intermittent is to provide options='{"timeout": 30}' in the database section of your hue.ini. This should restrict locks to 30 seconds.

Re: DatabaseError: database is locked

Romainr — Tue, 24 Jun 2014 16:21:05 GMT

Or switch Hue to use MySql (recommended) for example:
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/CDH5-Installation-Guide/cdh5ig_hue_database.html

Romain

Re: DatabaseError: database is locked

rube — Wed, 25 Jun 2014 03:10:33 GMT

Many thanks.

The problem solved.

Re: DatabaseError: database is locked

kchaitanya — Mon, 18 Jul 2016 11:44:41 GMT

How did you solve the issue, i'm also facing the same. Could you plz post your solution

Re: DatabaseError: database is locked

Romainr — Mon, 18 Jul 2016 15:00:08 GMT

You will need to use an external database
http://www.cloudera.com/documentation/enterprise/latest/topics/cdh_ig_hue_database.html#concept_id1_wkj_zj

Re: DatabaseError: database is locked

kchaitanya — Mon, 18 Jul 2016 15:09:48 GMT

Thanks @Romainr for reply. Is there any other way to fix apart from changing the db..?

question Re: DatabaseError: database is locked in Archives of Support Questions (Read Only)

DatabaseError: database is locked

Re: DatabaseError: database is locked

Re: DatabaseError: database is locked

Re: DatabaseError: database is locked

Re: DatabaseError: database is locked

Re: DatabaseError: database is locked

Re: DatabaseError: database is locked