PyCharm fails to connect to SQLite: SQLITE_BUSY, (database is locked)

Question

I'm trying to use PyCharm's database tools to connect to a SQLite db.

When I test the connection, it is successful, but when I try to sync to the db, I get:

[5] org.sqlite.SQLiteException: [SQLITE_BUSY]  The database file is locked (database is locked).

This happens when the application isn't running, so nothing is currently connected to the db.

EDIT: I've learned that the problem only exists when the db file is on the Windows Subsystem for Linux

Try to set `Single connection mode` in your data source `Options` tab. — Vasilii Chernov, May 15 '20 at 16:22
I have the same issue when a file is in WSL, but I'm using Datagrip. — qotsa42, May 05 '21 at 14:41
@qotsa42 I would expect that DataGrip would behave the same way, sorry to hear this is still an issue. — Eric Wilson, May 06 '21 at 02:30

score 4 · Answer 1 · answered Jun 03 '21 at 07:17

4

answered Jun 03 '21 at 07:17

Vasilii Chernov

1 Answers1