Xamarin.iOS crashes when adding AppCenter.SDK - Sqlite related?

[stefandevo]

I have a current application and wanted to add AppCenter
However my keeps crashting since I added AppCenter SDK. It seems there is an issue with Sqlite which is also already in use with the app itself.

This is the crash;

2018-03-17 01:42:36.743[7344:32574382] critical:   at <unknown> <0xffffffff>
2018-03-17 01:42:36.743[7344:32574382] critical:   at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_sqlite3/NativeMethods.sqlite3_finalize (intptr) [0x00009] in <4b13142c9add44d5a49eb902e2c4366c>:0
2018-03-17 01:42:36.744[7344:32574382] critical:   at SQLitePCL.SQLite3Provider_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_finalize (intptr) [0x00001] in <4b13142c9add44d5a49eb902e2c4366c>:0
2018-03-17 01:42:36.744[7344:32574382] critical:   at SQLitePCL.raw.sqlite3_finalize (SQLitePCL.sqlite3_stmt) [0x0000b] in <d42560990bbc44f1a185c6191eb5ff79>:0
2018-03-17 01:42:36.744[7344:32574382] critical:   at SQLite.SQLite3.Finalize (SQLitePCL.sqlite3_stmt) [0x00000] in /Users/vagrant/git/src/SQLite.cs:3561
2018-03-17 01:42:36.744[7344:32574382] critical:   at SQLite.PreparedSqlLiteInsertCommand.Dispose (bool) [0x0000d] in /Users/vagrant/git/src/SQLite.cs:2688
2018-03-17 01:42:36.744[7344:32574382] critical:   at SQLite.PreparedSqlLiteInsertCommand.Finalize () [0x00000] in /Users/vagrant/git/src/SQLite.cs:2698
2018-03-17 01:42:36.744[7344:32574382] critical:   at (wrapper runtime-invoke) object.runtime_invoke_virtual_void__this__ (object,intptr,intptr,intptr) [0x0001f] in <cf9013b38a4e4129bd64785080dd2844>:0
2018-03-17 01:42:36.744[7344:32574382] critical: 
Native stacktrace:

The current app is using/referencing:

<package id="sqlite-net-pcl" version="1.4.118" targetFramework="xamarinios10" />
  <package id="SQLitePCL.bundle_green" version="0.9.3" targetFramework="xamarinios10" />
  <package id="SQLitePCL.raw" version="0.9.3" targetFramework="xamarinios10" />
  <package id="SQLitePCLRaw.bundle_green" version="1.1.8" targetFramework="xamarinios10" />
  <package id="SQLitePCLRaw.core" version="1.1.8" targetFramework="xamarinios10" />
  <package id="SQLitePCLRaw.provider.sqlite3.ios_unified" version="1.1.8" targetFramework="xamarinios10" />

[thyeggman]

Hi there, do you mind sharing a simple project with a repro? Or lacking that, code snippet which causes the failure?

[MatkovIvan]

There was another problem with this version of SQLite. Could you please try a different version?

https://github.com/Microsoft/AppCenter-SDK-DotNet/blob/51f25a9b44596d84d353c42b865055449fd73ed6/SDK/AppCenter/Microsoft.AppCenter.Windows.Shared/Storage/Storage.cs#L69-L71

[stefandevo]

Indeed, downgrading sql-net-pcl did fix the issue

[yaliashkevich]

Does anybody know what this issue (in sqlite-net-pcl 1.4.118) is?

[achocron]

@yaliashkevich I think it was related to this issue: praeclarum/sqlite-net#627

[yaliashkevich]

@achocron , thank you, glad to know I'm not affected by the issue.

But I have another related question.
What was the reason to make sqlite-pcl-net a dependency?
It looks like this project is not actively supported/maintained. The issue above was open 7 months ago. The project itself has 217 open issues. AppCenter and sqlite-pcl-net looks to be in completely different "weight categories". Commitment for sqlite-pcl-net ORM just to manage one single table with 3 columns and 5 queries against it and "practice" in reflection, looks odd.