sqlite> DELETE FROM mails WHERE (`id` = 71);
SQL error: database is locked
How do I unlock the database so this will work?
Sqlite – How to unlock a SQLite database
sqlite
Related Topic
- SQLite – UPSERT *not* INSERT or REPLACE
- Sqlite – How to rename a column in a SQLite database table
- Sqlite – How to check in SQLite whether a table exists
- Sql – Is it possible to insert multiple rows at a time in an SQLite database
- Sqlite – Improve INSERT-per-second performance of SQLite
- Android – How to avoid concurrency problems when using SQLite on Android
- Sqlite – How to delete or add column in SQLITE
Best Answer
In windows you can try this program http://www.nirsoft.net/utils/opened_files_view.html to find out the process is handling db file. Try closed that program for unlock database
In Linux and macOS you can do something similar, for example, if your locked file is development.db:
This command will show what process is locking the file:
Just kill the process...
...And your database will be unlocked.