On 6/7/17, Daniel Polski <dan...@agelektronik.se> wrote: > > > Den 2017-06-07 kl. 15:02, skrev Richard Hipp: >> On 6/7/17, Daniel Polski <dan...@agelektronik.se> 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?
No. Because the new readers will be referencing the most recent commit, they will not block the checkpoint. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
