On 4 May 2015, at 6:43pm, Brandon Frye <brandon at cogent3d.com> wrote:
> Thanks so much for the response. Can you suggest the specific pragmas - > although I trust your insight that they may be more harmful than helpful - > I would like to read more about them (if for nothing else to make sure I > have not used them trying to fix this!). The ones which seem relevant are PRAGMA cache_spill PRAGMA checkpoint_fullfsync PRAGMA fullfsync PRAGMA synchronous PRAGMA wal_autocheckpoint PRAGMA wal_checkpoint By all means experiment with them and see if they help. I suspect that settings which cause more frequent updating of the database will just cause your crash to occur sooner, but since the bug you seem to have discovered in iOS is not understood, perhaps one will avoid you triggering it. Simon.