Re: [sqlite] WAL checkpoint starved?

Daniel Polski wrote: > Any ideas why I can end up with that large WAL file Sounds like checkpoint starvation. Does the checkpoint call actually succeed? Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailingl

Re: [sqlite] WAL checkpoint starved?

On 6/2/17, Daniel Polski 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(),

[sqlite] WAL checkpoint starved?

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

Re: [sqlite] [patch] configure.ac: wrong braces in appending OPT_FEATURE_FLAGS

Richard Hipp writes: > On 6/2/17, Yuriy M. Kaminskiy wrote: >> While running configure, I noticed some noise about `OPT_FEATURE_FLAGS: >> command not found`. > > I attempted to fix this problem in check-in > https://www.sqlite.org/src/timeline?c=43ce3bd3 - Did I miss something? Sorry for noise,

Re: [sqlite] documentation flaws

On 6/2/17, Rob Golsteijn wrote: > > I found 2 flaws in the online documentation: > Should be fixed now. Thanks for the report. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sq

Re: [sqlite] [patch] configure.ac: wrong braces in appending OPT_FEATURE_FLAGS

On 6/2/17, Yuriy M. Kaminskiy wrote: > While running configure, I noticed some noise about `OPT_FEATURE_FLAGS: > command not found`. I attempted to fix this problem in check-in https://www.sqlite.org/src/timeline?c=43ce3bd3 - Did I miss something? -- D. Richard Hipp d...@sqlite.org _

[sqlite] [patch] configure.ac: wrong braces in appending OPT_FEATURE_FLAGS

While running configure, I noticed some noise about `OPT_FEATURE_FLAGS: command not found`. And indeed, it uses wrong braces around OPT_FEATURE_FLAGS in code that converts --enable-{fts4,rtree,etc} into defines. In shell (configure.ac is shell code!), ${foo} expands variable foo, but $(foo) runs *c

Re: [sqlite] [Bug] Non-ASCII character is not counted in calculating column width

yum...@gmail.com (Yuriy M. Kaminskiy) writes: > Jacob Pratt writes: > >> Using .width x along with .mode columns, any non-ASCII character isn't >> counted, causing the column to shrink by one. >> >> I *think* my analysis is correct, but it also might be counted multiple >> times by taking a naïve

Re: [sqlite] Last character "]" gets corrupted in SQLITE rarely

Pavel Machala wrote: > I am struggling with this very random and rare issue where last character > of string - always “]” in multiple columns is replaced with one or more > unexpected characters. SQLite does not change the contents of strings, and treats them exactly like blobs (unless you excplic

Re: [sqlite] [Bug] Non-ASCII character is not counted in calculating column width

Jacob Pratt writes: > Using .width x along with .mode columns, any non-ASCII character isn't > counted, causing the column to shrink by one. > > I *think* my analysis is correct, but it also might be counted multiple > times by taking a naïve approach and just counting the number of bytes > (UTF-

[sqlite] documentation flaws

Hi List, I found 2 flaws in the online documentation: Documentation conflict: Section "1.3. Limitations" on http://sqlite.org/sessionintro.html states: "• Prior to SQLite version 3.17.0, the session extension only worked with rowid tables, not WITHOUT RO