SQLite database corruption at android emulator

Topics: Xamarin
Jan 28, 2015 at 9:36 AM
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.

Any help?


Shlomi Gal
Mar 19, 2015 at 4:24 PM
Do you use custom collations?