Database is locked error sqlite3 file opened from WSL

[huyphams]

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): Sqlite3

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Build 124

3. The steps to reproduce this issue:

4. Create sqlite3 db file in WSL home directory

5. Open db file to view content

6. Run Select * from table

7. Database is locked

Moved from: https://github.com/TablePlus/TablePlus/issues/1899

[agustif]

I'have experienced the same problem.

[Dragory]

Also experiencing this same issue, running Build 146.

[abdellatifLabr]

Experiencing the same issue on windows wsl 2, sqlite3, tableplus build 160

[Parrryy]

Any news on this?

[mattkenefick]

Same.

[franklin-tina]

👀 Same boat!

[meeglos]

Same issue. WSL2 / SQLite 3 Version 4.2.12 (176) - x64

[kod4krome]

Glad I found this issue. I am experiencing the same.

[meeglos]

When I do (CTRL + K) to select database it shows a messsage: This feature is not available for this driver. WSL2 / SQLite 3.36.0 Version 4.5.1 (178) - x64

[mattkenefick]

Any updates?

[huyphams]

I think this issue is the WSL issue, all other database clients hav the same error, not only TablePlus.

[Intellimatic]

I believe that this is down to file access permissions in WSL; you cannot open the SQLite file that's used by WSL using a TablePlus instance that's running in the Windows environment. My workaround is to install TablePlus in WSL itself and use that to access the SQLite database files.