On 6/5/17, Daniel Polski <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
