On 2 Mar 2015, at 10:32pm, Doug Nebeker <admin at poweradmin.com> wrote:
>> Are you using any PRAGMAs apart from "PRAGMA synchronous" ? > > PRAGMA temp_store=1 (file) > PRAGMA cache_size=2000 > PRAGMA page_size=4096 > sqlite3_soft_heap_limit( 1GB ) > > Those are the only non-default settings. I see nothing in there (or the rest of your posts) that looks dangerous. So I still don't know why you're seeing corruption. I hope one of the other posts here will help you. >> Are you testing the result codes of /all/ your sqlite3_ calls > > Yes. But I usually don't see the full log to see if something has happened > earlier. I'll have to track down a log and see if the corruption error is > the first one that happens. Might be helpful. Also to perhaps make it clear to your users that something is wrong the first time you get a result that isn't SQLITE_OK. Simon.
