Django + SQLite how to increase SQLite timeout when "database is locked" error occurs

Question

I am getting the: django.db.utils.OperationalError: database table is locked error (an oh boy are there many copies of that question) all of the answers refer to this page:

https://docs.djangoproject.com/en/dev/ref/databases/#database-is-locked-errorsoption

and although I understand what is going on I clearly don't know Python and Django well enough to understand the instruction. The instruction is to increase the timeout like:

'OPTIONS': {
    # ...
    'timeout': 20,
    # ...
}

but it's not so easy for a-bear-of-very-little-brain to understand exactly where that code goes. Can someone give me a bit more context? Where in my Django project do I specify these sort of options? It can't be a general Django setting can it? Timeout sounds lika a bit too general a name for that...

all your settings lies in your project's settings.py file

Arpit Solanki
– Arpit Solanki

2017-06-15 07:32:40 +00:00
Commented Jun 15, 2017 at 7:32 — Arpit Solanki
– Arpit Solanki, Commented Jun 15, 2017 at 7:32

Alfe · Accepted Answer · 2018-10-31 12:21:21Z

13

So, yes it goes in the settings file but not just directly in the settings file but under DATABASES (of course).

My DATABASES part now looks a bit like this:

   DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
        'OPTIONS': {
            'timeout': 20,  # in seconds
            # see also
            # https://docs.python.org/3.7/library/sqlite3.html#sqlite3.connect
        }
    }

}

Which seems to have done the trick. Maybe this was obvious for everyone else or maybe not. It's not always so easy for a-bear-of-very-little-brain.

edited Oct 31, 2018 at 12:21

Alfe

60.2k21 gold badges117 silver badges172 bronze badges

answered Jun 15, 2017 at 7:40

jonalv

6,1969 gold badges48 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Alasdair Over a year ago

That doesn't look quite right to me - I expected OPTIONS to be inside the default dictionary, rather than after it.

w-- Over a year ago

@Alasdair is correct. docs.djangoproject.com/en/1.11/ref/settings/…

Jonathan Stray Over a year ago

Fixed location of Options timeout in code above, as @alasdair noted.

Frederick Nord Over a year ago

How would a setting look like that makes use of an increased timeout during testing?

iMath Over a year ago

@VishnuYS seconds, docs.python.org/3.7/library/sqlite3.html#sqlite3.connect

|

Collectives™ on Stack Overflow

Django + SQLite how to increase SQLite timeout when "database is locked" error occurs

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related