On 27 Sep 2017, at 7:35am, bensonbear <benson.b...@gmail.com> wrote:
> I could not think of anything very useful to try, but in any case I > found pretty quickly that the problem was the fact that activity > elsewhere had nearly filled up my root partition. I don't know > exactly how this would explain the observed behavior > but I would speculate that uncommitted changes were > lost because of some temporary file cache, but committed > changes made it to the actual database file on another partition? That sounds plausible. SQLite would have run out of space while fiddling with a journal file. Were you checking the result codes returned for each sqlite_ function call ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users