I've worked with sqlite for other projects and it has always worked well for me. This time I trying to set up a database on a Linux server with a Samba share. I've mounted the samba share on my computer and can create / edit files using other programs without any problems so I don't think it's a permission problem.

To replicate the problem:

1. Click the "New Database" button
2. Browse to the mounted samba share, enter a name and click "Save"
3. Create a table
4. Click the "Write Changes" button

I get the error:

Error while saving the database file. This means that not all changes to the database were saved. You need to resolve the following error first.
database is locked (RELEASE "RESTOREPOINT";)

When I look at the database with the console command ls -l, it shows the database file, but it is zero bytes in size.

If I do the same on a local drive, everything works OK.

I tried creating the database on a local drive and then copying it to the shared drive. It works on the local drive, but when I access it from the shared drive, I get the same error when trying to update any data.

Anyone have an idea on what the problem is or how to fix this?

Thanks

OS: Debian Linux 12 on both server and local computer

DB Browser for SQLite Version 3.12.2

Built for x86_64-little_endian-lp64, running on x86_64
Qt Version 5.15.4
SQLite Version 3.39.2.