On 6/2/17, Daniel Polski <dan...@agelektronik.se> wrote:
> I've found something weird in a log from a client.
> Normally our WAL files are < 100kB, but in this log I noticed the file
> was >40MB. This was totally unexpected since we run this call every minute:
>
> int val = sqlite3_wal_checkpoint_v2(myDB->getDbPointer(), NULL,
> SQLITE_CHECKPOINT_TRUNCATE, &wal_size, &wal_checkpointed);
>
> and I thought that SQLITE_CHECKPOINT_TRUNCATE would force the checkpoint
> to completion. We haven't turned off automatic checkpoints, just added
> the above to make them happen more often than default, and be called
> from a specific thread.

Do you have a busy callback handler registered
(https://sqlite.org/c3ref/busy_handler.html) and are you checking the
return code from sqlite3_wal_callback_v2()?
-- 
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

Reply via email to