On Sun, Jun 4, 2017 at 10:54 PM, Daniel Polski <dan...@agelektronik.se>
wrote:

>
> Den 2017-06-02 kl. 16:07, skrev Clemens Ladisch:
>
>> Daniel Polski wrote:
>>
>>> Any ideas why I can end up with that large WAL file
>>>
>> Sounds like checkpoint starvation.
>> Does the checkpoint call actually succeed?
>>
>
> Unfortunately I don't know (adding a log message for that now).
>
> Any suggestions about how to recover if the call to
> sqlite3_wal_checkpoint_v2 fails? (Would prefer the checkpointing to be the
> highest priority, locking out everything else until it can succeed).
>
> I'd like to thank you for working through this.  Maybe wal checkpoint will
work someday... and actually empty the wal file.
The only way for it to work is to close the file is what I was told... so
you can't keep any of the other connections open either.

>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to