Python SQLite: database is locked

by

I’m presuming you are actually using sqlite3 even though your code says otherwise. Here are some things to check:

  1. That you don’t have a hung process sitting on the file (unix: $ fuser cache.db should say nothing)
  2. There isn’t a cache.db-journal file in the directory with cache.db; this would indicate a crashed session that hasn’t been cleaned up properly.
  3. Ask the database shell to check itself: $ sqlite3 cache.db "pragma integrity_check;"
  4. Backup the database $ sqlite3 cache.db ".backup cache.db.bak"
  5. Remove cache.db as you probably have nothing in it (if you are just learning) and try your code again
  6. See if the backup works $ sqlite3 cache.db.bak ".schema"

Failing that, read Things That Can Go Wrong and How to Corrupt Your Database Files

More Related Contents:

  1. pysqlite: Placeholder substitution for column or table names?
  2. Variable table name in sqlite
  3. SQLite parameter substitution problem
  4. Importing a CSV file into a sqlite3 database table using Python
  5. How do you escape strings for SQLite table/column names in Python?
  6. How to retrieve inserted id after inserting row in SQLite using Python?
  7. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  8. Sqlite insert query not working with python?
  9. Inserting a table name into a query gives sqlite3.OperationalError: near “?”: syntax error
  10. Python insert numpy array into sqlite3 database
  11. Python CSV to SQLite
  12. Python sqlite3 and concurrency
  13. What if I don’t close the database connection in Python SQLite
  14. HDF5 – concurrency, compression & I/O performance [closed]
  15. Auto Increment on Composite Primary Key – Sqlite3 + Python
  16. How to get a single result from a SQL query in python?
  17. Parameter unsupported when inserting int
  18. Executing an SQL query over a pandas dataset
  19. Is this Python code vulnerable to SQL injection? (SQLite3)
  20. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  21. Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
  22. creating a database outside the application context
  23. Python SQLite3 SQL Injection Vulnerable Code
  24. How to delete a table in SQLAlchemy?
  25. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  26. How to check the existence of a row in SQLite with Python?
  27. sqlite3.OperationalError: no such column – but I’m not asking for a column?
  28. Passing SQLite variables in Python
  29. Python sqlite3 parameterized drop table
  30. Python sqlite3.OperationalError: no such table:

Leave a Comment