{"action":"created","issue":{"url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/97","repository_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw","labels_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/97/labels{/name}","comments_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/97/comments","events_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/97/events","html_url":"https://github.com/ericsink/SQLitePCL.raw/issues/97","id":176300432,"number":97,"title":"Native bundled Sqlite is unreliable","user":{"login":"Dynogic","id":3052767,"avatar_url":"https://avatars.githubusercontent.com/u/3052767?v=3","gravatar_id":"","url":"https://api.github.com/users/Dynogic","html_url":"https://github.com/Dynogic","followers_url":"https://api.github.com/users/Dynogic/followers","following_url":"https://api.github.com/users/Dynogic/following{/other_user}","gists_url":"https://api.github.com/users/Dynogic/gists{/gist_id}","starred_url":"https://api.github.com/users/Dynogic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Dynogic/subscriptions","organizations_url":"https://api.github.com/users/Dynogic/orgs","repos_url":"https://api.github.com/users/Dynogic/repos","events_url":"https://api.github.com/users/Dynogic/events{/privacy}","received_events_url":"https://api.github.com/users/Dynogic/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":15,"created_at":"2016-09-12T06:04:03Z","updated_at":"2016-09-28T22:25:01Z","closed_at":null,"body":"Hi there,\r\n\r\nI have previously updated to the latest SQLite-net-pcl (https://github.com/praeclarum/sqlite-net) that uses SQLitePCL.raw 0.9.3 from the old SQLIte-net-pcl 1.1.1. To my knowledge, 0.9.3 makes use of a custom built Android sqlite.so libraries. My users have noticed random rollbacks in their databases (such as reverting a thread unread indicator back to its default value) on the new custom built libraries compared to the old 1.1.1 that just uses the system sqlite.so. Reverting to the old 1.1.1 is a confirmed fix for these users - they've not had an issue since. I do not reference Mono.Sqlite at all either - there are also no sign of Xamarin's sqlite_xamarin.so libraries, so I can't imagine the corruptions happening because of multiple libraries loaded in.\r\n\r\nI've checked how I'm accessing these databases... every time an access is made to them, there is a proper C# lock mechanism put in place, along with the SQLiteConnection object wrapped in a using statement.\r\n\r\nAny guidance to what to do? Seems like a few weeks ago you recompiled the custom built libraries. There's not yet a nuget to incorporate these changes though. Perhaps this resolves the issue?\r\n\r\nThanks,\r\nJake."},"comment":{"url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/comments/250319556","html_url":"https://github.com/ericsink/SQLitePCL.raw/issues/97#issuecomment-250319556","issue_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/97","id":250319556,"user":{"login":"Dynogic","id":3052767,"avatar_url":"https://avatars.githubusercontent.com/u/3052767?v=3","gravatar_id":"","url":"https://api.github.com/users/Dynogic","html_url":"https://github.com/Dynogic","followers_url":"https://api.github.com/users/Dynogic/followers","following_url":"https://api.github.com/users/Dynogic/following{/other_user}","gists_url":"https://api.github.com/users/Dynogic/gists{/gist_id}","starred_url":"https://api.github.com/users/Dynogic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Dynogic/subscriptions","organizations_url":"https://api.github.com/users/Dynogic/orgs","repos_url":"https://api.github.com/users/Dynogic/repos","events_url":"https://api.github.com/users/Dynogic/events{/privacy}","received_events_url":"https://api.github.com/users/Dynogic/received_events","type":"User","site_admin":false},"created_at":"2016-09-28T22:25:01Z","updated_at":"2016-09-28T22:25:01Z","body":"Hi, issue looks resolved. No one is having issues anymore :)"}}
{"actor":{"display_login":"Dynogic"}}