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
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
> 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.
_
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
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.
5 matches
Mail list logo