Xamarin error System.DllNotFoundException: /system/lib/libsqlite.so on Android 7.0

Question

I get this exception whenever I try to create a SQLite.Net.SQLiteConnection in android 7.0 any idea how to fix it? I'm using these nuget pacakges:

<packages>
  <package id="ExifLib.PCL" version="1.0.1" targetFramework="monoandroid6" />
  <package id="Microsoft.Bcl" version="1.1.10" targetFramework="monoandroid43" />
  <package id="Microsoft.Bcl.Build" version="1.0.21" targetFramework="monoandroid43" />
  <package id="Newtonsoft.Json" version="7.0.1" targetFramework="monoandroid6" />
  <package id="SQLite.Net.Core-PCL" version="3.1.1" targetFramework="monoandroid6" />
  <package id="SQLite.Net-PCL" version="3.1.1" targetFramework="monoandroid6" />
  <package id="SQLiteNetExtensions" version="1.3.0" targetFramework="xamarinios1" />
  <package id="sqlite-net-pcl" version="1.2.1" targetFramework="monoandroid70" />
  <package id="SQLitePCL.bundle_green" version="0.9.3" targetFramework="monoandroid60" />
  <package id="SQLitePCL.plugin.sqlite3.android" version="0.9.3" targetFramework="monoandroid60" />
  <package id="SQLitePCL.raw" version="0.9.3" targetFramework="monoandroid60" />
  <package id="SQLitePCLRaw.bundle_green" version="1.1.1" targetFramework="monoandroid70" />
  <package id="SQLitePCLRaw.core" version="1.1.1" targetFramework="monoandroid70" />
  <package id="SQLitePCLRaw.lib.e_sqlite3.android" version="1.1.1" targetFramework="monoandroid70" />
  <package id="SQLitePCLRaw.provider.e_sqlite3.android" version="1.1.1" targetFramework="monoandroid70" />
  <package id="Xam.Plugins.Settings" version="2.5.1.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.Animated.Vector.Drawable" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.CustomTabs" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.Design" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.v4" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.v7.AppCompat" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.v7.CardView" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.v7.MediaRouter" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.v7.RecyclerView" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.Android.Support.Vector.Drawable" version="23.3.0" targetFramework="monoandroid60" />
  <package id="Xamarin.FFImageLoading" version="2.2.5" targetFramework="monoandroid70" />
  <package id="Xamarin.FFImageLoading.Forms" version="2.2.5" targetFramework="monoandroid70" />
  <package id="Xamarin.Forms" version="2.3.3.168" targetFramework="monoandroid70" />
  <package id="Xamarin.GooglePlayServices.Ads" version="29.0.0.1" targetFramework="monoandroid60" />
  <package id="Xamarin.GooglePlayServices.Analytics" version="29.0.0.1" targetFramework="monoandroid60" />
  <package id="Xamarin.GooglePlayServices.AppIndexing" version="29.0.0.1" targetFramework="monoandroid60" />
  <package id="Xamarin.GooglePlayServices.Base" version="29.0.0.1" targetFramework="monoandroid60" />
  <package id="Xamarin.GooglePlayServices.Basement" version="29.0.0.1" targetFramework="monoandroid60" />
  <package id="Xamarin.Insights" version="1.12.3" targetFramework="monoandroid60" />
</packages>

no, actually the fix for me was to compile using the older build tools for android 6 and the crash disappeared on android 7 as well — fire in the hole, Dec 06 '16 at 13:23

score 3 · Answer 1 · answered Jul 16 '18 at 09:41

3

I think you are using oystein.krog package You should try with praeclarum package

answered Jul 16 '18 at 09:41

Alessandro Caliaro

5,623
7
27
52

1

After several tries, you pointed me to the solution : the use of sqlite-net-pcl did the trick for me. Thank you ! – Jean-Daniel Gasser Jul 23 '18 at 15:52
Upgraded to 8.1 Oreo within Xamarin, got system dllnotfound /system/lib/libsqlite.so exception. removed SQLite , installed pcl package Install-Package sqlite-net-pcl -Version 1.5.231 - error resolved. Thanks – timothy Nov 10 '18 at 13:48
I've been all day reading forums about that same issue until right now!! Thank you so much Alessandro !! It solved my issue too :) – Sergi Mascaró Feb 05 '19 at 15:27

score 2 · Accepted Answer · answered Dec 09 '16 at 16:12

2

The solution for me was to update the SQLiteNetExtensions nuget package to the latest Alpha version (prerelease), it's important to first remove all references to sqlite related libs though.

answered Dec 09 '16 at 16:12

fire in the hole

1,171
15
34

1

What was the version number? – Ken Pespisa Feb 03 '17 at 14:53
installing version 2.0.0-alpha2 fixed the problem – fire in the hole Feb 06 '17 at 13:29
Installing 2.0.0-alpha2 version of SQLiteNetExtensions nuget package didn't help me. Still get the same exception when create SQLite.Net.SQLiteConnection. – kio21 Mar 14 '17 at 08:01
it's important to first remove all references to sqlite related libs in your solution, before installing the new version. you did that? – fire in the hole Mar 15 '17 at 13:47
It should be work in PCL project too? I have the same problem – Nininea Apr 21 '17 at 16:14
I guess so, since xamarin projects are pcl as well, but try the solution for yourself to make sure – fire in the hole Apr 22 '17 at 08:38
You have saved my life. – SamyCode Dec 22 '17 at 13:54

score 0 · Answer 3 · answered Feb 15 '19 at 06:46

0

i have same issue in my xamarin android. i install this package for sqlite and set targeted version to android 8(oreo) my application works again

answered Feb 15 '19 at 06:46

vebs

325
1
4
11

Xamarin error System.DllNotFoundException: /system/lib/libsqlite.so on Android 7.0

3 Answers3

Linked