Could not find `SQLitePCLRaw.provider.sqlite3` in macOS project

[praeclarum]

Testing 1.5.136-beta that references Raw 1.1.7 on a macOS app, I get:

Could not find `SQLitePCLRaw.provider.sqlite3` referenced by assembly `SQLitePCLRaw.batteries_v2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8226ea5df37bcae9`.

@ericsink I believe it should be e_sqlite3 not sqlite3 to match the references:

  <ItemGroup>
    <Reference Include="System" />
    <Reference Include="System.Core" />
    <Reference Include="Xamarin.Mac" />
    <Reference Include="SQLitePCLRaw.core">
      <HintPath>..\packages\SQLitePCLRaw.core.1.1.7\lib\Xamarin.Mac20\SQLitePCLRaw.core.dll</HintPath>
    </Reference>
    <Reference Include="SQLitePCLRaw.provider.e_sqlite3">
      <HintPath>..\packages\SQLitePCLRaw.provider.e_sqlite3.macos.1.1.7\lib\Xamarin.Mac20\SQLitePCLRaw.provider.e_sqlite3.dll</HintPath>
    </Reference>
    <Reference Include="SQLitePCLRaw.batteries_green">
      <HintPath>..\packages\SQLitePCLRaw.bundle_green.1.1.7\lib\Xamarin.Mac20\SQLitePCLRaw.batteries_green.dll</HintPath>
    </Reference>
    <Reference Include="SQLitePCLRaw.batteries_v2">
      <HintPath>..\packages\SQLitePCLRaw.bundle_green.1.1.7\lib\Xamarin.Mac20\SQLitePCLRaw.batteries_v2.dll</HintPath>
    </Reference>
    <Reference Include="SQLite-net">
      <HintPath>..\packages\sqlite-net-pcl.1.5.136-beta\lib\netstandard1.1\SQLite-net.dll</HintPath>
    </Reference>
  </ItemGroup>

Full stack trace:

Could not find `SQLitePCLRaw.provider.sqlite3` referenced by assembly `SQLitePCLRaw.batteries_v2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=8226ea5df37bcae9`.
Could not find `SQLitePCLRaw.provider.sqlite3` referenced by assembly `SQLite-net, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null`.
Could not find `SQLitePCLRaw.provider.sqlite3` referenced by assembly `MacTest, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null`.
2017-08-02 10:28:30.894 MacTest[80342:39082066] 
Unhandled Exception:
System.IO.FileNotFoundException: Could not load file or assembly 'SQLitePCLRaw.provider.sqlite3' or one of its dependencies
File name: 'SQLitePCLRaw.provider.sqlite3'
  at System.AppDomain.Load (System.Reflection.AssemblyName assemblyRef, System.Security.Policy.Evidence assemblySecurity) [0x001a9] in /Library/Frameworks/Xamarin.Mac.framework/Versions/3.99.0.80/src/mono/mcs/class/corlib/System/AppDomain.cs:777 
  at System.AppDomain.Load (System.Reflection.AssemblyName assemblyRef) [0x00000] in /Library/Frameworks/Xamarin.Mac.framework/Versions/3.99.0.80/src/mono/mcs/class/corlib/System/AppDomain.cs:714 
  at (wrapper remoting-invoke-with-check) System.AppDomain:Load (System.Reflection.AssemblyName)
  at System.Reflection.Assembly.Load (System.Reflection.AssemblyName assemblyRef) [0x00000] in /Library/Frameworks/Xamarin.Mac.framework/Versions/3.99.0.80/src/mono/mcs/class/corlib/System.Reflection/Assembly.cs:600 
  at ObjCRuntime.Runtime.CollectReferencedAssemblies (System.Collections.Generic.List`1[T] assemblies, System.Reflection.Assembly assembly) [0x0006d] in /Users/builder/data/lanes/5024/9ce8f256/source/xamarin-macios/src/ObjCRuntime/Runtime.cs:464 
  at ObjCRuntime.Runtime.CollectReferencedAssemblies (System.Collections.Generic.List`1[T] assemblies, System.Reflection.Assembly assembly) [0x0006d] in /Users/builder/data/lanes/5024/9ce8f256/source/xamarin-macios/src/ObjCRuntime/Runtime.cs:464 
  at ObjCRuntime.Runtime.CollectReferencedAssemblies (System.Collections.Generic.List`1[T] assemblies, System.Reflection.Assembly assembly) [0x0006d] in /Users/builder/data/lanes/5024/9ce8f256/source/xamarin-macios/src/ObjCRuntime/Runtime.cs:464 
  at ObjCRuntime.Runtime.RegisterEntryAssembly (System.Reflection.Assembly entry_assembly) [0x00035] in /Users/builder/data/lanes/5024/9ce8f256/source/xamarin-macios/src/ObjCRuntime/Runtime.cs:425 
  at ObjCRuntime.Runtime.RegisterAssemblies () [0x00006] in /Users/builder/data/lanes/5024/9ce8f256/source/xamarin-macios/src/ObjCRuntime/Runtime.cs:401 
  at AppKit.NSApplication.Init () [0x00022] in /Users/builder/data/lanes/5024/9ce8f256/source/xamarin-macios/src/AppKit/NSApplication.cs:60 
  at MacTest.MainClass.Main (System.String[] args) [0x00001] in /Users/fak/Projects/TestSql/MacTest/Main.cs:9 

[ericsink]

Yep, that looks wrong. I'm amazed that you're the first to find it.

[praeclarum]

Well I've been on 1.1.5 but that Mac support is also broke (at the package level). Glad I actually tried to run a test :-)

[ericsink]

It appears to be a simple fix. I'm building to verify that now.

[praeclarum]

@ericsink I tried with raw 1.1.8 but got System.DllNotFoundException: e_sqlite3:

System.TypeInitializationException: The type initializer for 'SQLite.SQLiteConnection' threw an exception. ---> System.DllNotFoundException: e_sqlite3
  at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_e_sqlite3+NativeMethods:sqlite3_libversion_number ()
  at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number () [0x00000] in <0bb15cfb0c30488ba94c83cf0500e031>:0 
  at SQLitePCL.raw.SetProvider (SQLitePCL.ISQLite3Provider imp) [0x00008] in <7314b275e2e94b2ca295a2cc04790fca>:0 
  at SQLitePCL.Batteries_V2.Init () [0x00005] in <b0910ecf1b2a42fea83ad5ae0f5aae10>:0 
  at SQLite.SQLiteConnection..cctor () [0x00000] in /Users/vagrant/git/src/SQLite.cs:218 
   --- End of inner exception stack trace ---
  at (wrapper managed-to-native) System.Object:__icall_wrapper_mono_generic_class_init (intptr)
  at MacTest.ViewController.ViewDidLoad () [0x00008] in /Users/fak/Projects/TestSql/MacTest/ViewController.cs:18 
  at (wrapper managed-to-native) AppKit.NSApplication:NSApplicationMain (int,string[])
  at AppKit.NSApplication.Main (System.String[] args) [0x00041] in /Users/builder/data/lanes/5143/80f17b0b/source/xamarin-macios/src/AppKit/NSApplication.cs:100 
  at MacTest.MainClass.Main (System.String[] args) [0x00007] in /Users/fak/Projects/TestSql/MacTest/Main.cs:10 

[ericsink]

Ouch. My apologies.

I wasn't able to actually test my attempted fix, but clearly I'm going to need to try again and this time be sure it works.

[mister-giga]

I still have that issue. Any fixes?

[ericsink]

If you still have this issue with SQLitePCL.raw 1.1.9, then it's probably a different issue.

[15mgm15]

I am not sure if it is related but here is my stack trace:

2017-12-14 14:06:55.243 SchedulingTool.iOS[6765:379607] critical:   at <unknown> <0xffffffff>
2017-12-14 14:06:55.243 SchedulingTool.iOS[6765:379607] critical:   at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_sqlite3/NativeMethods.sqlite3_finalize (intptr) [0x00009] in <1b9c2004d3634b2c8d9bd2ba9457c80d>:0
2017-12-14 14:06:55.243 SchedulingTool.iOS[6765:379607] critical:   at SQLitePCL.SQLite3Provider_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_finalize (intptr) [0x00001] in <1b9c2004d3634b2c8d9bd2ba9457c80d>:0
2017-12-14 14:06:55.243 SchedulingTool.iOS[6765:379607] critical:   at SQLitePCL.raw.sqlite3_finalize (SQLitePCL.sqlite3_stmt) [0x0000b] in <06a4628a96c94b1f840d86573556fb91>:0
2017-12-14 14:06:55.244 SchedulingTool.iOS[6765:379607] critical:   at SQLite.SQLite3.Finalize (SQLitePCL.sqlite3_stmt) [0x00000] in /Users/vagrant/git/src/SQLite.cs:3561
2017-12-14 14:06:55.244 SchedulingTool.iOS[6765:379607] critical:   at SQLite.PreparedSqlLiteInsertCommand.Dispose (bool) [0x0000d] in /Users/vagrant/git/src/SQLite.cs:2688
2017-12-14 14:06:55.244 SchedulingTool.iOS[6765:379607] critical:   at SQLite.PreparedSqlLiteInsertCommand.Finalize () [0x00000] in /Users/vagrant/git/src/SQLite.cs:2698
2017-12-14 14:06:55.244 SchedulingTool.iOS[6765:379607] critical:   at (wrapper runtime-invoke) object.runtime_invoke_virtual_void__this__ (object,intptr,intptr,intptr) [0x0001f] in <bdb3aaa208384edf9f1266721cf8f9c1>:0
2017-12-14 14:06:55.244 SchedulingTool.iOS[6765:379607] critical: 
Native stacktrace:

2017-12-14 14:06:55.251 SchedulingTool.iOS[6765:379607] critical: 	0   SchedulingTool.iOS                  0x0000000107e623c4 mono_handle_native_crash + 244
2017-12-14 14:06:55.251 SchedulingTool.iOS[6765:379607] critical: 	1   SchedulingTool.iOS                  0x0000000107e704d0 mono_sigsegv_signal_handler + 288
2017-12-14 14:06:55.251 SchedulingTool.iOS[6765:379607] critical: 	2   libsystem_platform.dylib            0x000000011163cb3a _sigtramp + 26
2017-12-14 14:06:55.252 SchedulingTool.iOS[6765:379607] critical: 	3   ???                                 0x000000010872e6d8 0x0 + 4436715224
2017-12-14 14:06:55.252 SchedulingTool.iOS[6765:379607] critical: 	4   libsqlite3.dylib                    0x000000010fe9adfb sqlite3_finalize + 107
2017-12-14 14:06:55.252 SchedulingTool.iOS[6765:379607] critical: 	5   ???                                 0x0000000133d7834c 0x0 + 5164729164
2017-12-14 14:06:55.252 SchedulingTool.iOS[6765:379607] critical: 	6   ???                                 0x00000001341f78d3 0x0 + 5169445075
2017-12-14 14:06:55.252 SchedulingTool.iOS[6765:379607] critical: 	7   ???                                 0x000000012ed06a6a 0x0 + 5080377962
2017-12-14 14:06:55.252 SchedulingTool.iOS[6765:379607] critical: 	8   SchedulingTool.iOS                  0x0000000107ece130 mono_gc_run_finalize + 736
2017-12-14 14:06:55.253 SchedulingTool.iOS[6765:379607] critical: 	9   SchedulingTool.iOS                  0x0000000107fb4b1c sgen_gc_invoke_finalizers + 236
2017-12-14 14:06:55.253 SchedulingTool.iOS[6765:379607] critical: 	10  SchedulingTool.iOS                  0x0000000107ecfcda finalizer_thread + 778
2017-12-14 14:06:55.253 SchedulingTool.iOS[6765:379607] critical: 	11  SchedulingTool.iOS                  0x0000000107f79163 start_wrapper + 675
2017-12-14 14:06:55.253 SchedulingTool.iOS[6765:379607] critical: 	12  libsystem_pthread.dylib             0x000000011164e93b _pthread_body + 180
2017-12-14 14:06:55.253 SchedulingTool.iOS[6765:379607] critical: 	13  libsystem_pthread.dylib             0x000000011164e887 _pthread_body + 0
2017-12-14 14:06:55.253 SchedulingTool.iOS[6765:379607] critical: 	14  libsystem_pthread.dylib             0x000000011164e08d thread_start + 13
2017-12-14 14:06:55.253 SchedulingTool.iOS[6765:379607] critical: 
=================================================================
Got a SIGSEGV while executing native code. This usually indicates
a fatal error in the mono runtime or one of the native libraries 
used by your application.
=================================================================

[kfreezen]

Edit: It seems this is not the correct place for this.
Edit 2: Not relevant. Microsoft.Data.Sqlite 2 was using bundle_green < 1.1.9.