iOS multithreading issues

[JeroenBer]

Hi,
I discovered some multithreading bugs on iOS. The error can't be reproduced on UWP, Android, MacOS as far as I can see, sqlite on iOS is compiled threadsafe and I am using it FULL_MUTEX. So it should give no errors but still it does when using it with ReadOnly and ReadWrite connections.

I am not sure if this is a SQLite bug or a bug in the library. Setting all connections to ReadWrite seems to be a workaround.

I made a pull request with the unittest to reproduce it on iOS:
#537

I have seen another report on internet that seems very similar (but this is async and i am using the sync version):
http://stackoverflow.com/questions/40153665/xamarin-ios-sqliteexception-corrupt

Regards,
Jeroen

[praeclarum]

I have seen this too under the guise of "IO Error".

https://github.com/praeclarum/sqlite-net/blob/master/tests/ConcurrencyTest.cs#L51-L59

I'm sorry but I haven't been able to fix it.

[praeclarum]

I'm hoping #505 will fix this for Async code