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