Search code examples
sqlite

How do I unlock a SQLite database?

When I enter this query: sqlite> DELETE FROM mails WHERE (id = 71);

SQLite returns this error:

SQL error: database is locked

How do I unlock the database so this query will work?

Solution

  • 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:

    $ fuser development.db

    This command will show what process is locking the file:

    > development.db: 5430

    Just kill the process...

    kill -9 5430

    ...And your database will be unlocked.