Re: [sqlite] problem with URI mode=ro

2019-12-21 Thread Keith Medcalf
On Saturday, 21 December, 2019 03:27, Thomas Kurz wrote: >I have a problem when opening a read-only database, which is a WAL-mode >database. >When trying to open it in read-only mode, i.e. using >file:test.sqlite?mode=ro, SHM and WAL file are created. That's >unpleasant, but the actual problem

Re: [sqlite] problem with URI mode=ro

2019-12-21 Thread Simon Slavin
On 21 Dec 2019, at 11:12am, Thomas Kurz wrote: >> Do the same thing again without the mode=ro >> Do the files get deleted this time ? > > No, this shows the same behavior, but in this case, it's actually what I'd > expect. Your problem would seem to be related to all WAL operations, not just r

Re: [sqlite] problem with URI mode=ro

2019-12-21 Thread Thomas Kurz
> Do the same thing again without the mode=ro > Do the files get deleted this time ? No, this shows the same behavior, but in this case, it's actually what I'd expect. > Does the program have enough privs over the database file's folder ? Yeah, sure, actually the file's on a FAT32 drive. _

Re: [sqlite] problem with URI mode=ro

2019-12-21 Thread Simon Slavin
On 21 Dec 2019, at 10:27am, Thomas Kurz wrote: > Result: SHM and WAL files are kept. Do the same thing again without the mode=ro Do the files get deleted this time ? Does the program have enough privs over the database file's folder ? ___ sqlite-user

[sqlite] problem with URI mode=ro

2019-12-21 Thread Thomas Kurz
I have a problem when opening a read-only database, which is a WAL-mode database. When trying to open it in read-only mode, i.e. using file:test.sqlite?mode=ro, SHM and WAL file are created. That's unpleasant, but the actual problem is the two files don't get deleted when closing the database.