search

TablePlus / TablePlus-Windows

TablePlus Windows issue tracker
https://tableplus.com
186 stars 3 forks source link

Database is locked error sqlite3 file opened from WSL #225

Open huyphams opened 4 years ago

huyphams commented 4 years ago

  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 commented 4 years ago

I'have experienced the same problem.

Dragory commented 3 years ago

Also experiencing this same issue, running Build 146.

abdellatifLabr commented 3 years ago

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

Parrryy commented 3 years ago

Any news on this?

mattkenefick commented 3 years ago

Same.

franklin-tina commented 3 years ago

👀 Same boat!

meeglos commented 3 years ago

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

kod4krome commented 3 years ago

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

meeglos commented 3 years ago

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 image

mattkenefick commented 2 years ago

Any updates?

huyphams commented 2 years ago

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

Intellimatic commented 2 years ago

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.

bvtrfly commented 3 months ago

I think this issue might be solved if we had an option to "SSH" into the WSL distro and then select the SQLite file from there. An example of software implementing this is "Tinkerwell"