Den 2017-06-07 kl. 15:02, skrev Richard Hipp:
On 6/7/17, Daniel Polski <[email protected]> wrote:
Does the [TRUNCATE] checkpoint call lock out new requests which might prohibit
checkpoint progress while waiting for the timeout?
It prohibits new writers. New readers are allowed to proceed.
What will happen with other connections new read/write requests during
the timeout while the checkpointing is running..?
Readers proceed normally. Writers fail with an SQLITE_BUSY errors.
Aha, can those new readers in turn block the checkpointing from proceeding?
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users