Entry point not found for sqlite3_close_v2

[paulvanbladel]

I constructed a test project (asp.net 5 with EF 7) working correctly on windows with sqlite.
When running on linux in docker aspnet , running dnx ef migrations add test work fine
but dnx ef database update gives:

System.ObjectDisposedException: The object was used after being disposed.
  at System.Runtime.InteropServices.SafeHandle.RunRelease () [0x00000] in <filename unknown>:0
  at System.Runtime.InteropServices.SafeHandle.Dispose (Boolean disposing) [0x00000] in <filename unknown>:0
  at System.Runtime.InteropServices.SafeHandle.Dispose () [0x00000] in <filename unknown>:0
  at Microsoft.Data.Sqlite.SqliteConnection.Close () [0x00000] in <filename unknown>:0
  at Microsoft.Data.Sqlite.SqliteConnection.Dispose (Boolean disposing) [0x00000] in <filename unknown>:0
  at System.ComponentModel.Component.Dispose () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) System.ComponentModel.Component:Dispose ()
  at Microsoft.Data.Entity.Storage.RelationalConnection.Dispose () [0x00000] in <filename unknown>:0
  at Microsoft.Framework.DependencyInjection.ServiceProvider.Dispose () [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.Internal.DbContextServices.Dispose () [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.DbContext.Dispose () [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.Commands.MigrationTool.ApplyMigration (System.String migrationName, System.String contextTypeName, System.String startupAssemblyName) [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.Commands.Program+<>c__DisplayClass12_0.<ApplyMigration>b__0 () [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.Commands.Program.Execute (System.String startupProject, System.Action invoke) [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.Commands.Program.ApplyMigration (System.String migration, System.String context, System.String startupProject) [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.Commands.Program+<>c__DisplayClass9_2.<Main>b__5 () [0x00000] in <filename unknown>:0
  at Microsoft.Dnx.Runtime.Common.CommandLine.CommandLineUtilsExtensions+<>c__DisplayClass0_0.<OnExecute>b__0 () [0x00000] in <filename unknown>:0
  at Microsoft.Dnx.Runtime.Common.CommandLine.CommandLineApplication.Execute (System.String[] args) [0x00000] in <filename unknown>:0
  at Microsoft.Data.Entity.Commands.Program.Main (System.String[] args) [0x00000] in <filename unknown>:0
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in <filename unknown>:0
--- End of stack trace from previous location where exception was thrown ---
  at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x00000] in <filename unknown>:0
  at Microsoft.Dnx.Runtime.Common.EntryPointExecutor.Execute (System.Reflection.Assembly assembly, System.String[] args, IServiceProvider serviceProvider) [0x00000] in <filename unknown>:0
  at Microsoft.Dnx.ApplicationHost.Program.ExecuteMain (Microsoft.Dnx.Runtime.DefaultHost host, System.String applicationName, System.String[] args) [0x00000] in <filename unknown>:0
  at Microsoft.Dnx.ApplicationHost.Program.Main (System.String[] args) [0x00000] in <filename unknown>:0
--- End of stack trace from previous location where exception was thrown ---
  at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x00000] in <filename unknown>:0
  at Microsoft.Dnx.Runtime.Common.EntryPointExecutor.Execute (System.Reflection.Assembly assembly, System.String[] args, IServiceProvider serviceProvider) [0x00000] in <filename unknown>:0
  at Microsoft.Dnx.Host.Bootstrapper.RunAsync (System.Collections.Generic.List`1 args, IRuntimeEnvironment env, System.Runtime.Versioning.FrameworkName targetFramework) [0x00000] in <filename unknown>:0

Unhandled Exception:
System.EntryPointNotFoundException: sqlite3_close_v2
  at (wrapper managed-to-native) Microsoft.Data.Sqlite.Interop.NativeMethods:sqlite3_close_v2 (intptr)
  at Microsoft.Data.Sqlite.Interop.Sqlite3Handle.ReleaseHandle () [0x00000] in <filename unknown>:0
  at System.Runtime.InteropServices.SafeHandle.Dispose (Boolean disposing) [0x00000] in <filename unknown>:0
  at System.Runtime.InteropServices.SafeHandle.Finalize () [0x00000] in <filename unknown>:0

[natemcmaster]

@paulvanbladel Which version of Linux do you have installed? Run:

$ dpkg-query --show sqlite3

EF.Sqlite uses Microsoft.Data.Sqlite, which requires the native library to be SQLite 3.7.15 or newer.

[paulvanbladel]

Hi Nate,

Thanks for the prompt reply.

sqlite3 3.7.13-1+deb7u2

I'm running the aspnet docker image and installed in that sqlite3.
Is this sufficient info ?
thanks a lot.
paul.

[natemcmaster]

Upgrade your sqlite package to a newer version. Reopen if you still see this issue.

sudo apt-get upgrade sqlite3 libsqlite3-dev

[paulvanbladel]

exactly the same error after upgrade of sqlite3.
version is now:

root@60b31a4b2919:/repos/AspNet5-Web-Api-Sample/src/Web-Api-Sample# sqlite3
SQLite version 3.8.11.1 2015-07-29 20:00:57
Enter ".help" for usage hints.
Connected to a transient in-memory database.

[paulvanbladel]

I can't do a re-open of this issue.

[natemcmaster]

sqlite3_close_v2 was not added to SQLite until 3.7.15, so this error occurs when using an older version of the library. Depending on your Linux distro, the version of libsqlite3.so may comes from the libsqlite3-dev package.

$ dpkg-query --show libsqlite3-dev

Make sure this package is also >= 3.7.15.

[bricelam]

My two cents: Could it be an x86 vs x64 issue?

[paulvanbladel]

@natemcmaster Thanks for your continuous support.
In fact I upgrade sqlite3 not via the command you proposed but that didn't have effect.
I used following procedure and that worked, at least for sqlite3.
http://www.linuxfromscratch.org/blfs/view/svn/server/sqlite.html

So, doing sudo apt-get upgrade sqlite3 libsqlite3-dev has no effect on the version.
So, I'm stuck with upgrading libsqlite3-dev :(

[paulvanbladel]

Ok, I managed to update libsqlite3-dev and indeed : problem solved.
sqlite3 works now inside an aspnet docker image.
thanks a lot for the support !