Django + Sqlite: database is locked

Question

After a electrical failure my network database having problems

I open my login page by running the program but after, the username and password are no longer recognized

I get the error

Exception Type: DatabaseError
Value Exception: database is locked

and my function :

def main_page(request):
    state = ""
    username = password = ''
    if request.POST:
        username = request.POST.get('username')
        password = request.POST.get('password')
        user = authenticate(username=username, password=password)

The problem comes from this line : user =....

How can I fix this ?

This is not a Django problem. This is a Sqlite problem. See this question — Taylan Aydinli
– Taylan Aydinli, Commented Mar 10, 2015 at 9:06
For me the problem was NFS and found a solution here: stackoverflow.com/a/6366752/8826047 — Sona Pochybova
– Sona Pochybova, Commented Apr 9, 2021 at 11:57

geckon · Accepted Answer · 2015-09-01 11:44:32Z

9

From Django doc:

SQLite is meant to be a lightweight database, and thus can’t support a high level of concurrency. OperationalError: database is locked errors indicate that your application is experiencing more concurrency than sqlite can handle in default configuration. This error means that one thread or process has an exclusive lock on the database connection and another thread timed out waiting for the lock the be released.

Python’s SQLite wrapper has a default timeout value that determines how long the second thread is allowed to wait on the lock before it times out and raises the OperationalError: database is locked error.

If you’re getting this error, you can solve it by:

Switching to another database backend. At a certain point SQLite becomes too “lite” for real-world applications, and these sorts of concurrency errors indicate you’ve reached that point.

Rewriting your code to reduce concurrency and ensure that database transactions are short-lived.

Increase the default timeout value by setting the timeout database option

edited Sep 1, 2015 at 11:44

geckon

8,8326 gold badges39 silver badges61 bronze badges

answered Mar 10, 2015 at 9:06

Seyeong Jeong

11.1k2 gold badges32 silver badges39 bronze badges

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

2 Comments

Patrice Over a year ago

I have just a question. Could you tell me why, before this electric breakdown, It worked perfectly...with sqlite

Seyeong Jeong Over a year ago

Perhaps this question would answer your question as @vape suggested above.

Collectives™ on Stack Overflow

Django + Sqlite: database is locked

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related