On 6/5/17, Daniel Polski <dan...@agelektronik.se> wrote: > > > Den 2017-06-02 kl. 16:07, skrev Richard Hipp: >>> >>> and I thought that SQLITE_CHECKPOINT_TRUNCATE would force the checkpoint >>> to completion. >> Do you have a busy callback handler registered >> (https://sqlite.org/c3ref/busy_handler.html) > No busy callback is registered, but we do set the: > sqlite3_busy_timeout(db, 0) >
SQLITE_CHECKPOINT_TRUNCATE waits until either it is able to run the checkpoint to completion and truncate the WAL file, or until the timeout expires. Since you have the timeout turned off, the SQLITE_CHECKPOINT_TRUNCATE does not wait at all, and simply fails if a reader is preventing the timeout from running to completion. -- 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