Sqlite problems after latest update on El Capitan

Getting this error after the latest update:

    [Fatal] ConsoleApp: EPIC FAIL! 

System.EntryPointNotFoundException: sqlite3_column_database_name
  at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_column_database_name (intptr,int)
  at System.Data.SQLite.SQLite3.ColumnDatabaseName (System.Data.SQLite.SQLiteStatement stmt, Int32 index) [0x00000] in <filename unknown>:0 
  at System.Data.SQLite.SQLiteDataReader.GetStatementColumnParents (System.Data.SQLite.SQLiteBase sql, System.Data.SQLite.SQLiteStatement stmt, Int32 fieldCount, System.Collections.Generic.Dictionary`2& parentToColumns, System.Collections.Generic.Dictionary`2& columnToParent) [0x00000] in <filename unknown>:0 
  at System.Data.SQLite.SQLiteDataReader.GetSchemaTable (Boolean wantUniqueInfo, Boolean wantDefaultValue) [0x00000] in <filename unknown>:0 
  at System.Data.SQLite.SQLiteDataReader.GetSchemaTable () [0x00000] in <filename unknown>:0 
  at System.Data.Common.DataAdapter.BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType, MissingSchemaAction missingSchAction, MissingMappingAction missingMapAction, System.Data.Common.DataTableMappingCollection dtMapping) [0x0003b] in /private/tmp/mono20150717-46061-1r9ir61/mono-4.0.2/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:249 
  at System.Data.Common.DataAdapter.BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType) [0x00000] in /private/tmp/mono20150717-46061-1r9ir61/mono-4.0.2/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:222 
  at System.Data.Common.DataAdapter.FillTable (System.Data.DataTable dataTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, System.Int32& counter) [0x00011] in /private/tmp/mono20150717-46061-1r9ir61/mono-4.0.2/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:393 
  at System.Data.Common.DataAdapter.FillInternal (System.Data.DataSet dataSet, System.String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) [0x0009b] in /private/tmp/mono20150717-46061-1r9ir61/mono-4.0.2/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:496 
  at System.Data.Common.DataAdapter.Fill (System.Data.DataSet dataSet, System.String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) [0x00000] in /private/tmp/mono20150717-46061-1r9ir61/mono-4.0.2/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:551 
  at System.Data.Common.DbDataAdapter.Fill (System.Data.DataSet dataSet, Int32 startRecord, Int32 maxRecords, System.String srcTable, IDbCommand command, CommandBehavior behavior) [0x0004e] in /private/tmp/mono20150717-46061-1r9ir61/mono-4.0.2/mcs/class/System.Data/System.Data.Common/DbDataAdapter.cs:293 
  at System.Data.Common.DbDataAdapter.Fill (System.Data.DataSet dataSet) [0x00000] in /private/tmp/mono20150717-46061-1r9ir61/mono-4.0.2/mcs/class/System.Data/System.Data.Common/DbDataAdapter.cs:234 
  at FluentMigrator.Runner.Processors.SQLite.SqliteProcessor.Read (System.String template, System.Object[] args) [0x00032] in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\Processors\SQLite\SqliteProcessor.cs:197 
  at FluentMigrator.Runner.Processors.SQLite.SqliteProcessor.ColumnExists (System.String schemaName, System.String tableName, System.String columnName) [0x00000] in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\Processors\SQLite\SqliteProcessor.cs:52 
  at FluentMigrator.Runner.VersionLoader.get_AlreadyMadeVersionUnique () [0x00000] in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\VersionLoader.cs:119 
  at FluentMigrator.Runner.VersionLoader.LoadVersionInfo () [0x00050] in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\VersionLoader.cs:154 
  at FluentMigrator.Runner.VersionLoader..ctor (IMigrationRunner runner, System.Reflection.Assembly assembly, IMigrationConventions conventions) [0x00077] in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\VersionLoader.cs:43 
  at FluentMigrator.Runner.MigrationRunner..ctor (System.Reflection.Assembly assembly, IRunnerContext runnerContext, IMigrationProcessor processor) [0x000d6] in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\MigrationRunner.cs:87 
  at NzbDrone.Core.Datastore.Migration.Framework.MigrationController.MigrateToLatest (System.String connectionString, MigrationType migrationType, System.Action`1 beforeMigration) [0x0007f] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:40 
  at NzbDrone.Core.Datastore.DbFactory.Create (MigrationType migrationType, System.Action`1 beforeMigration) [0x00049] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\DbFactory.cs:69 
  at NzbDrone.Core.Datastore.DbFactory.RegisterDatabase (IContainer container) [0x00000] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\DbFactory.cs:31 
  at NzbDrone.Host.Bootstrap.Start (ApplicationModes applicationModes, NzbDrone.Common.EnvironmentInfo.StartupContext startupContext) [0x0002e] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Host\Bootstrap.cs:69 
  at NzbDrone.Host.Bootstrap.Start (NzbDrone.Common.EnvironmentInfo.StartupContext startupContext, IUserAlert userAlert, System.Action`1 startCallback) [0x00070] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Host\Bootstrap.cs:38 
  at NzbDrone.Console.ConsoleApp.Main (System.String[] args) [0x0000f] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Console\ConsoleApp.cs:20 

Did some searching and found that it may be a sqlite3 error. my sqlite3 version is: 3.8.10.2

any idea what is going on?

Never mind. Solved my own problem.

I downloaded a new sqlite3 from hombrew and copied the file over to the sonarr app directory and replaced the old one.

1 Like

Again the newest update broke sonar and I had to do the same thing…

If you’re copying a file into the Sonarr.app its going to get removed every time Sonarr updates.

We include libsqlite3.0.dylib and libsqlite3.dylib in the package already, which should work without further changes. Which file are you copying in?

I am copying in libsqlite3.0.dylib and libsqlite3.dylib. Both of them need to be copied in for it to work correctly. I’m copying in version 3.9.1

Both of those files are included with out package and should work, are you not seeing those files before you copy them in?

Have you tried re-installing Sonarr?

Yeah they are in there. But I had to replace them with the newer ones. I’m not sure why it wasn’t working but I tried that and it worked. I can try and reinstall and see if that works or if it’s a separate issue.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.