We use the SQLite PCL (latest nuget version) with android application (xamarin)
We use background thread for inserting and updating data to SQLite database.
Lately we encountered an disturbing situation - after inserting about 29,000 rows the database became corrupted. and reading from it will cause this error:
E/SQLiteLog( 3252): (11) database corruption at line 53572 of [00bb9c9ce4]
The exact error is "An unexpected SQLite result was encountered: CORRUPT" at SQLiteStatement.Step()
Until now we got this error only when using the device emulator (android 4.4.2) and not with a physical device.