On 14.8.2024 16.39, Andrei Borzenkov wrote:
On Wed, Aug 14, 2024 at 4:31 PM Martti Laaksonen <martti.laaksonen@sci.fi> wrote:
On 13.8.2024 12.23, Roger Oberholtzer wro SQLite database file access seems to hinge on the fact that WSL2 mounted filesystems do not support file locking when accessed from the Windows side
OP got this problem with the Paragon ext4 driver.
Yes, I got that and just demonstrated that you can also access SQLite databases via WSL2 mount if you open it using file: URI with nolock or immutable query parameter. Without either one, you will get the same database locked errors when going through WSL2 mount. Besides, the same SQLite file: URI trick probably works with that Paragon driver too. Obviously you will want to make sure you are the only one accessing the database when using the nolock parameter. -- Martti Laaksonen