Okay let's restart... maybe I misunderstood that Richard was able to
reproduce this.
I have figured out a simple script that with 3.8.11.1 windows (using
binary download sqlite3.exe) causes the problem.
running just 'sqlite3.exe'
--- script ---
.open test.db
pragma journal_mode=wal;
.open
On Sat, Aug 15, 2015 at 1:59 PM, Richard Hipp wrote:
> On 8/15/15, Ashwin Hirschi wrote:
>>
>>> But I also see that behavior dates back to 3.7.6 and maybe earlier. It
>>> isn't something new.
>>> (Testing on Ubuntu).
>>
>> Also, are you sure you testing things right? I thought URI support was
>>
> With this new test case, I see that the -shm and -wal files are
> retained upon exit in read-only mode.
Great. Good to see other people are able to reproduce (some? of) the issue.
> But I also see that behavior dates back to 3.7.6 and maybe earlier. It
> isn't something new.
> (Testing on
> Also, make sure that folder is not a shared resource or inside a shared
> resource that is visible from any other network node or machine.
>
> This piece, describing the same symptom for Internet Explorer temporary
> files, may help:
> https://support.microsoft.com/en-us/kb/814782
The
>> I've recently found SQLite doesn't always remove its journal files
>> anymore.
>>
>> The issue seems to occur when opening WAL databases in read-only mode
>> (i.e. using SQLITE_OPEN_READONLY).
>>
>> A scenario to reproduce this (using version 3.8.11.1) looks like:
>>
>> 1. open a WAL
Also, make sure that folder is not a shared resource or inside a shared
resource that is visible from any other network node or machine.
This piece, describing the same symptom for Internet Explorer temporary
files, may help:
https://support.microsoft.com/en-us/kb/814782
What happens when you
Checked this on WIndows 7 & 8, works as expected.
This means either Windows 10 has some glitch or the access level to the
folder is not correct, files may not be deleted by that process or some
antivirus is checking the file while SQLite is trying to delete it, or
you are not closing the DB
Hello,
I've recently found SQLite doesn't always remove its journal files anymore.
The issue seems to occur when opening WAL databases in read-only mode
(i.e. using SQLITE_OPEN_READONLY).
A scenario to reproduce this (using version 3.8.11.1) looks like:
1. open a WAL database in read-only
On 8/15/15, Ashwin Hirschi wrote:
>
>> But I also see that behavior dates back to 3.7.6 and maybe earlier. It
>> isn't something new.
>> (Testing on Ubuntu).
>
> Also, are you sure you testing things right? I thought URI support was
> only added in 3.7.7... If that's true, your little script
On 8/15/15, Keith Medcalf wrote:
>
> Quite Fascinating! Here is the transcript (it is running the Windows
> SQLITE.EXE which I have in a different location in the path, so slightly
> modified the script):
>
Ugh. There is a bug in my script. The final "ls -l" should have a
"*" at the end
On 8/15/15, Keith Medcalf wrote:
>
> This is something changed in SQLITE itself. These tests are on Windows 10
> using the current MinGW compiler with the same configuration and windows
> headers.
>
Do you also have MSYS installed? If so can you run the following
shell script and see if it
On 8/15/15, Ashwin Hirschi wrote:
>
> Hello,
>
> I've recently found SQLite doesn't always remove its journal files anymore.
>
> The issue seems to occur when opening WAL databases in read-only mode
> (i.e. using SQLITE_OPEN_READONLY).
>
> A scenario to reproduce this (using version 3.8.11.1)
980,798,976 bytes free
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
> bounces at mailinglists.sqlite.org] On Behalf Of Richard Hipp
> Sent: Saturday, 15 August, 2015 12:41
> To: General Discussion of SQLite Database
>
t; To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] journal files not always removed
>
> Also, make sure that folder is not a shared resource or inside a shared
> resource that is visible from any other network node or machine.
>
> This piece,
14 matches
Mail list logo