We’ve been running into occasional DB corruption issues, at a rate of approximately 1/500 users over the last month. This shows up in the form of database disk image is malformed (code: 11).
We didn’t run into any of these issues when using regular SQLite, and migrated to SQLCipher just last month. We’ve kept all our settings identical, but noticed that we accidentally disabled WAL when switching. (I’ve just re-enabled WAL, as of today)
Using SQLCipher 4.5.3 via SQLite.swift
Using CommonCrypto (SQLCIPHER_CRYPTO_CC)
We’ll update this thread with any updates from our experiment of going back to WAL, but we’d love any other thoughts on how we could better investigate the source of this corruption. We have some corrupted user DBs, and can run additional diagnostics if needed.