OperationalError: database is locked

by

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

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

More Related Contents:

  1. sqlite3.OperationalError: unable to open database file
  2. Variable table name in sqlite
  3. Importing a CSV file into a sqlite3 database table using Python
  4. Django: Deploying an application on Heroku with sqlite3 as the database
  5. multiple databases and multiple models in django
  6. Django persistent database connection
  7. How do you join two tables on a foreign key field using django ORM?
  8. How to make/use a custom database function in Django
  9. How to see the raw SQL queries Django is running?
  10. Is there a way to get a list of column names in sqlite?
  11. A QuerySet by aggregate field value
  12. How to move a model between two Django apps (Django 1.7)
  13. “no such table” exception
  14. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  15. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  16. Race conditions in django
  17. What is your favorite solution for managing database migrations in django? [closed]
  18. How to upgrade sqlite 3.8.2 to >= 3.8.3
  19. How to open and convert sqlite database to pandas dataframe
  20. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  21. Django: Increment blog entry view count by one. Is this efficient?
  22. django makemigrations and migrate on heroku server don’t create tables
  23. Django: sudden DB reset after Heroku sleep
  24. Python sqlite3.OperationalError: no such table:
  25. Does Django scale? [closed]
  26. URL-parameters and logic in Django class-based views (TemplateView)
  27. Django REST: Uploading and serializing multiple images
  28. Proper way to consume data from RESTFUL API in django
  29. How to add custom field in ModelSerializer?
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment