On 23 March 2018 at 08:54, Deon Brewis <de...@outlook.com> wrote: > Most of the time when the database gets corrupted, we don't crash, it > corrupts midway through valid SQL (no pattern to it - completely unrelated > SQL). I was thinking if the expression functions have bugs in them it could > cause corruption, but can't really imagine how. We use sqlite3_result_* > functions to report results, and even if we read invalid memory or pass > invalid memory to SQLITE, it should crash - not corrupt. >
Do you have an sqlite logging callback installed (sqlite3_config(SQLITE_CONFIG_LOG, ...))? The messages on that channel include more details (eg. the line number of the sqlite3 source where the corruption was first noticed) for some instances of corruption. Might help to pin down the issue. -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users