Failed Migration After Update

Sonarr version (exact version): 2.0.0.4424
Mono version (if Sonarr is not running on Windows):
OS: Windows 10
((Debug logs)):
(Make sure debug logging is enabled in settings and post the full log to hastebin/pastebin/dropbox/google drive or something similar, do not post them directly here)
Description of issue: After recent update (not sure, last couple days?) Sonarr will not load and even after rebooting and also uninstalling/reinstalling the latest build it’s failing 100% of the time with some weird non valid DateTime string in the console with a bunch of other stuff I don’t understand.

Here’s the snip from my latest log, I’m at a loss for what to do recover. I’ve been a user for over a year and this is literally my first issue with updates or the service running…

16-12-8 17:31:35.0|Info|Bootstrap|Starting Sonarr - C:\ProgramData\NzbDrone\bin\nzbdrone.console.exe - Version 2.0.0.4424
16-12-8 17:31:35.4|Info|MigrationLogger|*** Migrating data source=C:\ProgramData\NzbDrone\nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
16-12-8 17:31:35.5|Info|MigrationLogger|*** Migrating data source=C:\ProgramData\NzbDrone\logs.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
16-12-8 17:31:35.5|Fatal|ConsoleApp|EPIC FAIL!

[v2.0.0.4424] System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.ParseExactMultiple(String s, String[] formats, DateTimeFormatInfo dtfi, DateTimeStyles style)
at System.DateTime.ParseExact(String s, String[] formats, IFormatProvider provider, DateTimeStyles style)
at System.Data.SQLite.SQLiteConvert.ToDateTime(String dateText, SQLiteDateFormats format, DateTimeKind kind, String formatString)
at System.Data.SQLite.SQLite3.GetDateTime(SQLiteStatement stmt, Int32 index)
at System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt, SQLiteConnectionFlags flags, Int32 index, SQLiteType typ)
at System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
at System.Data.SQLite.SQLiteDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Read(String template, Object[] args) in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\Processors\SQLite\SQLiteProcessor.cs:line 197
at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ReadTableData(String schemaName, String tableName) in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\Processors\SQLite\SQLiteProcessor.cs:line 98
at FluentMigrator.Runner.VersionLoader.LoadVersionInfo() in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\VersionLoader.cs:line 188
at FluentMigrator.Runner.VersionLoader…ctor(IMigrationRunner runner, IAssemblyCollection assemblies, IMigrationConventions conventions) in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\VersionLoader.cs:line 50
at FluentMigrator.Runner.MigrationRunner…ctor(IAssemblyCollection assemblies, IRunnerContext runnerContext, IMigrationProcessor processor) in c:\Community\schambers\fluentmigrator\src\FluentMigrator.Runner\MigrationRunner.cs:line 102
at NzbDrone.Core.Datastore.Migration.Framework.MigrationController.Migrate(String connectionString, MigrationContext migrationContext) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 43
at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\DbFactory.cs:line 85
at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\DbFactory.cs:line 57
at NzbDrone.Core.Datastore.DbFactory.RegisterDatabase(IContainer container) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\DbFactory.cs:line 41
at NzbDrone.Host.Bootstrap.Start(ApplicationModes applicationModes, StartupContext startupContext) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Host\Bootstrap.cs:line 73
at NzbDrone.Host.Bootstrap.Start(StartupContext startupContext, IUserAlert userAlert, Action`1 startCallback) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Host\Bootstrap.cs:line 40
at NzbDrone.Console.ConsoleApp.Main(String[] args) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Console\ConsoleApp.cs:line 20

Looks like it may be a corrupt log database so stopping Sonarr and deleting C:\ProgramData\NzbDrone\logs.db (and any other files that start with logs.db in that folder) and you should be up and running again.

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