Having some issues from Sonarr after blasting and setup of Docker image

not sure of the issue here
thoughts on if it is a remnant issue, this episode is not on my server anymore
Could this be an issue with the sonarr db
Should I be deleting anything?

Error below:


 

ErrorWarningSystemArrayLogin

[Info] MigrationController: *** Migrating data source=/config/sonarr.db;cache size=-20000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3;busytimeout=100 ***
[Info] FluentMigrator.Runner.MigrationRunner: DatabaseEngineVersionCheck migrating
[Info] FluentMigrator.Runner.MigrationRunner: PerformDBOperation
[Info] NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor: Performing DB Operation
[Info] DatabaseEngineVersionCheck: SQLite 3.45.3
[Info] FluentMigrator.Runner.MigrationRunner: => 0.0428594s
[Info] FluentMigrator.Runner.MigrationRunner: DatabaseEngineVersionCheck migrated
[Info] FluentMigrator.Runner.MigrationRunner: => 0.0448082s
[Info] FluentMigrator.Runner.MigrationRunner: 161: remove_plex_hometheatre migrating
[Info] NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor: Beginning Transaction
[Info] remove_plex_hometheatre: Starting migration of Main DB to 161
[Info] FluentMigrator.Runner.MigrationRunner: FluentMigrator.Expressions.DeleteDataExpression
[Info] NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor: DELETE FROM "Notifications" WHERE "Implementation" = 'PlexHomeTheater'
[Info] FluentMigrator.Runner.MigrationRunner: => 0.0229508s
[Info] FluentMigrator.Runner.MigrationRunner: FluentMigrator.Expressions.DeleteDataExpression
[Info] NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor: DELETE FROM "Notifications" WHERE "Implementation" = 'PlexClient'
[Info] FluentMigrator.Runner.MigrationRunner: => 0.0004694s
[Info] FluentMigrator.Runner.MigrationRunner: PerformDBOperation
[Info] NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor: Performing DB Operation
[Error] FluentMigrator.Runner.MigrationRunner: Error parsing column 1 (ParsedEpisodeInfo={
"releaseTitle": "The.Real.Housewives.of.New.York.City.S15E04.1080p.WEB.h264-EDITH",
"seriesTitle": "The Real Housewives of New York City",
"seriesTitleInfo": {
"title": "The Real Housewives of New York City",
"titleWithoutYear": "The Real Housewives of New York City",
"year": 0
},
"quality": {
"quality": {
"id": 3,
"name": "WEBDL-1080p",
"source": "web",
"resolution": 1080
},
"revision": {
"version": 1,
"real": 0
}
},
"seasonNumber": 15,
"episodeNumbers": [
4
],
"absoluteEpisodeNumbers": [],
"specialAbsoluteEpisodeNumbers": [],
"language": "english",
"fullSeason": false,
"isPartialSeason": false,
"isSeasonExtra": false,
"special": false,
"releaseGroup": "EDITH",
"releaseHash": "",
"seasonPart": 0,
"isDaily": false,
"isAbsoluteNumbering": false,
"isPossibleSpecialEpisode": false,
"isPossibleSceneSeasonSpecial": false
} - String)

[v4.0.10.2544] System.Data.DataException: Error parsing column 1 (ParsedEpisodeInfo={
"releaseTitle": "The.Real.Housewives.of.New.York.City.S15E04.1080p.WEB.h264-EDITH",
"seriesTitle": "The Real Housewives of New York City",
"seriesTitleInfo": {
"title": "The Real Housewives of New York City",
"titleWithoutYear": "The Real Housewives of New York City",
"year": 0
},
"quality": {
"quality": {
"id": 3,
"name": "WEBDL-1080p",
"source": "web",
"resolution": 1080
},
"revision": {
"version": 1,
"real": 0
}
},
"seasonNumber": 15,
"episodeNumbers": [
4
],
"absoluteEpisodeNumbers": [],
"specialAbsoluteEpisodeNumbers": [],
"language": "english",
"fullSeason": false,
"isPartialSeason": false,
"isSeasonExtra": false,
"special": false,
"releaseGroup": "EDITH",
"releaseHash": "",
"seasonPart": 0,
"isDaily": false,
"isAbsoluteNumbering": false,
"isPossibleSpecialEpisode": false,
"isPossibleSceneSeasonSpecial": false
} - String)
---> System.Text.Json.JsonException: The JSON value could not be converted to NzbDrone.Core.Datastore.Migration.remove_plex_hometheatre+Language161. Path: $.language | LineNumber: 26 | BytePositionInLine: 23.
at System.Text.Json.ThrowHelper.ThrowJsonException_DeserializeUnableToConvertValue(Type propertyType)
at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.Metadata.JsonPropertyInfo`1.ReadJsonAndSetMember(Object obj, ReadStack& state, Utf8JsonReader& reader)
at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.ReadCore(Utf8JsonReader& reader, JsonSerializerOptions options, ReadStack& state)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan`1 utf8Json, JsonTypeInfo jsonTypeInfo, Nullable`1 actualByteCount)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan`1 json, JsonTypeInfo jsonTypeInfo)
at System.Text.Json.JsonSerializer.Deserialize[TValue](String json, JsonSerializerOptions options)
at NzbDrone.Core.Datastore.Converters.EmbeddedDocumentConverter`1.Parse(Object value) in ./Sonarr.Core/Datastore/Converters/EmbeddedDocumentConverter.cs:line 50
at Dapper.SqlMapper.TypeHandler`1.Dapper.SqlMapper.ITypeHandler.Parse(Type destinationType, Object value) in /_/Dapper/SqlMapper.TypeHandler.cs:line 42
at Dapper.SqlMapper.TypeHandlerCache`1.Parse(Object value) in /_/Dapper/SqlMapper.TypeHandlerCache.cs:line 23
at Deserializebd586107-9a97-499a-ae2c-68982a27ecb9(IDataReader )
--- End of inner exception stack trace ---
at Dapper.SqlMapper.ThrowDataException(Exception ex, Int32 index, IDataReader reader, Object value) in /_/Dapper/SqlMapper.cs:line 3706
at Deserializebd586107-9a97-499a-ae2c-68982a27ecb9(IDataReader )
at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at NzbDrone.Core.Datastore.Migration.remove_plex_hometheatre.FixPendingReleases(IDbConnection conn, IDbTransaction tran)
at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(PerformDBOperationExpression expression)
at FluentMigrator.Expressions.PerformDBOperationExpression.ExecuteWith(IMigrationProcessor processor)
at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass80_0.<ExecuteExpressions>b__1()
at FluentMigrator.Runner.StopWatch.Time(Action action)
at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions)

[Info] NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor: Rolling back transaction
[Fatal] Microsoft.AspNetCore.Hosting.Diagnostics: Application startup exception

[v4.0.10.2544] NzbDrone.Common.Exceptions.SonarrStartupException: Sonarr failed to start: Error creating main database
---> System.Data.DataException: Error parsing column 1 (ParsedEpisodeInfo={
"releaseTitle": "The.Real.Housewives.of.New.York.City.S15E04.1080p.WEB.h264-EDITH",
"seriesTitle": "The Real Housewives of New York City",
"seriesTitleInfo": {
"title": "The Real Housewives of New York City",
"titleWithoutYear": "The Real Housewives of New York City",
"year": 0
},
"quality": {
"quality": {
"id": 3,
"name": "WEBDL-1080p",
"source": "web",
"resolution": 1080
},
"revision": {
"version": 1,
"real": 0
}
},
"seasonNumber": 15,
"episodeNumbers": [
4
],
"absoluteEpisodeNumbers": [],
"specialAbsoluteEpisodeNumbers": [],
"language": "english",
"fullSeason": false,
"isPartialSeason": false,
"isSeasonExtra": false,
"special": false,
"releaseGroup": "EDITH",
"releaseHash": "",
"seasonPart": 0,
"isDaily": false,
"isAbsoluteNumbering": false,
"isPossibleSpecialEpisode": false,
"isPossibleSceneSeasonSpecial": false
} - String)
---> System.Text.Json.JsonException: The JSON value could not be converted to NzbDrone.Core.Datastore.Migration.remove_plex_hometheatre+Language161. Path: $.language | LineNumber: 26 | BytePositionInLine: 23.
at System.Text.Json.ThrowHelper.ThrowJsonException_DeserializeUnableToConvertValue(Type propertyType)
at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.Metadata.JsonPropertyInfo`1.ReadJsonAndSetMember(Object obj, ReadStack& state, Utf8JsonReader& reader)
at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.ReadCore(Utf8JsonReader& reader, JsonSerializerOptions options, ReadStack& state)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan`1 utf8Json, JsonTypeInfo jsonTypeInfo, Nullable`1 actualByteCount)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan`1 json, JsonTypeInfo jsonTypeInfo)
at System.Text.Json.JsonSerializer.Deserialize[TValue](String json, JsonSerializerOptions options)
at NzbDrone.Core.Datastore.Converters.EmbeddedDocumentConverter`1.Parse(Object value) in ./Sonarr.Core/Datastore/Converters/EmbeddedDocumentConverter.cs:line 50
at Dapper.SqlMapper.TypeHandler`1.Dapper.SqlMapper.ITypeHandler.Parse(Type destinationType, Object value) in /_/Dapper/SqlMapper.TypeHandler.cs:line 42
at Dapper.SqlMapper.TypeHandlerCache`1.Parse(Object value) in /_/Dapper/SqlMapper.TypeHandlerCache.cs:line 23
at Deserializebd586107-9a97-499a-ae2c-68982a27ecb9(IDataReader )
--- End of inner exception stack trace ---
at Dapper.SqlMapper.ThrowDataException(Exception ex, Int32 index, IDataReader reader, Object value) in /_/Dapper/SqlMapper.cs:line 3706
at Deserializebd586107-9a97-499a-ae2c-68982a27ecb9(IDataReader )
at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at NzbDrone.Core.Datastore.Migration.remove_plex_hometheatre.FixPendingReleases(IDbConnection conn, IDbTransaction tran)
at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(PerformDBOperationExpression expression)
at FluentMigrator.Expressions.PerformDBOperationExpression.ExecuteWith(IMigrationProcessor processor)
at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass80_0.<ExecuteExpressions>b__1()
at FluentMigrator.Runner.StopWatch.Time(Action action)
at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions)
at FluentMigrator.Runner.MigrationRunner.ExecuteMigration(IMigration migration, Action`2 getExpressions)
at FluentMigrator.Runner.MigrationRunner.ApplyMigrationUp(IMigrationInfo migrationInfo, Boolean useTransaction)
at FluentMigrator.Runner.MigrationRunner.MigrateUp(Int64 targetVersion, Boolean useAutomaticTransactionManagement)
at FluentMigrator.Runner.MigrationRunner.MigrateUp(Boolean useAutomaticTransactionManagement)
at FluentMigrator.Runner.MigrationRunner.MigrateUp()
at NzbDrone.Core.Datastore.Migration.Framework.MigrationController.Migrate(String connectionString, MigrationContext migrationContext, DatabaseType databaseType)
at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext, DatabaseType databaseType)
--- End of inner exception stack trace ---
at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext, DatabaseType databaseType) in ./Sonarr.Core/Datastore/DbFactory.cs:line 164
at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in ./Sonarr.Core/Datastore/DbFactory.cs:line 71
at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in ./Sonarr.Core/Datastore/DbFactory.cs:line 59
at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in ./Sonarr.Core/Datastore/Extensions/CompositionExtensions.cs:line 10
at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 8067
at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3727
at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3525
at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3176
at DryIoc.Interpreter.TryInterpretSingletonAndUnwrapContainerException(IResolverContext r, Expression expr, ImMapEntry`1 itemRef, Object& result) in /_/src/DryIoc/Container.cs:line 3105
at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 11136
at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 11055
at DryIoc.Container.ResolveAndCacheKeyed(Int32 serviceTypeHash, Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Object scopeName, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 541
at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 469
at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3661
at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3188
at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3471
at DryIoc.Interpreter.<>c__DisplayClass5_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3370
at DryIoc.Interpreter.<>c__DisplayClass9_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3481
at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
at System.Lazy`1.CreateValue()
at System.Lazy`1.get_Value()
at NzbDrone.Host.Startup.Configure(IApplicationBuilder app, IContainer container, IStartupContext startupContext, Lazy`1 mainDatabaseFactory, Lazy`1 logDatabaseFactory, DatabaseTarget dbTarget, ISingleInstancePolicy singleInstancePolicy, InitializeLogger initializeLogger, ReconfigureLogging reconfigureLogging, IAppFolderFactory appFolderFactory, IProvidePidFile pidFileProvider, IConfigFileProvider configFileProvider, IRuntimeInfo runtimeInfo, IFirewallAdapter firewallAdapter, IEventAggregator eventAggregator, SonarrErrorPipeline errorHandler) in ./Sonarr.Host/Startup.cs:line 225
at System.RuntimeMethodHandle.InvokeMethod(Object target, Span`1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.ConfigureBuilder.<>c__DisplayClass4_0.<Build>b__0(IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass15_0.<UseStartup>b__1(IApplicationBuilder app)
at Microsoft.AspNetCore.Mvc.Filters.MiddlewareFilterBuilderStartupFilter.<>c__DisplayClass0_0.<Configure>g__MiddlewareFilterBuilder|0(IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)



[Fatal] ConsoleApp: EPIC FAIL!

[v4.0.10.2544] NzbDrone.Common.Exceptions.SonarrStartupException: Sonarr failed to start: Error creating main database
---> System.Data.DataException: Error parsing column 1 (ParsedEpisodeInfo={
"releaseTitle": "The.Real.Housewives.of.New.York.City.S15E04.1080p.WEB.h264-EDITH",
"seriesTitle": "The Real Housewives of New York City",
"seriesTitleInfo": {
"title": "The Real Housewives of New York City",
"titleWithoutYear": "The Real Housewives of New York City",
"year": 0
},
"quality": {
"quality": {
"id": 3,
"name": "WEBDL-1080p",
"source": "web",
"resolution": 1080
},
"revision": {
"version": 1,
"real": 0
}
},
"seasonNumber": 15,
"episodeNumbers": [
4
],
"absoluteEpisodeNumbers": [],
"specialAbsoluteEpisodeNumbers": [],
"language": "english",
"fullSeason": false,
"isPartialSeason": false,
"isSeasonExtra": false,
"special": false,
"releaseGroup": "EDITH",
"releaseHash": "",
"seasonPart": 0,
"isDaily": false,
"isAbsoluteNumbering": false,
"isPossibleSpecialEpisode": false,
"isPossibleSceneSeasonSpecial": false
} - String)
---> System.Text.Json.JsonException: The JSON value could not be converted to NzbDrone.Core.Datastore.Migration.remove_plex_hometheatre+Language161. Path: $.language | LineNumber: 26 | BytePositionInLine: 23.
at System.Text.Json.ThrowHelper.ThrowJsonException_DeserializeUnableToConvertValue(Type propertyType)
at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.Metadata.JsonPropertyInfo`1.ReadJsonAndSetMember(Object obj, ReadStack& state, Utf8JsonReader& reader)
at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.TryRead(Utf8JsonReader& reader, Type typeToConvert, JsonSerializerOptions options, ReadStack& state, T& value)
at System.Text.Json.Serialization.JsonConverter`1.ReadCore(Utf8JsonReader& reader, JsonSerializerOptions options, ReadStack& state)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan`1 utf8Json, JsonTypeInfo jsonTypeInfo, Nullable`1 actualByteCount)
at System.Text.Json.JsonSerializer.ReadFromSpan[TValue](ReadOnlySpan`1 json, JsonTypeInfo jsonTypeInfo)
at System.Text.Json.JsonSerializer.Deserialize[TValue](String json, JsonSerializerOptions options)
at NzbDrone.Core.Datastore.Converters.EmbeddedDocumentConverter`1.Parse(Object value) in ./Sonarr.Core/Datastore/Converters/EmbeddedDocumentConverter.cs:line 50
at Dapper.SqlMapper.TypeHandler`1.Dapper.SqlMapper.ITypeHandler.Parse(Type destinationType, Object value) in /_/Dapper/SqlMapper.TypeHandler.cs:line 42
at Dapper.SqlMapper.TypeHandlerCache`1.Parse(Object value) in /_/Dapper/SqlMapper.TypeHandlerCache.cs:line 23
at Deserializebd586107-9a97-499a-ae2c-68982a27ecb9(IDataReader )
--- End of inner exception stack trace ---
at Dapper.SqlMapper.ThrowDataException(Exception ex, Int32 index, IDataReader reader, Object value) in /_/Dapper/SqlMapper.cs:line 3706
at Deserializebd586107-9a97-499a-ae2c-68982a27ecb9(IDataReader )
at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at NzbDrone.Core.Datastore.Migration.remove_plex_hometheatre.FixPendingReleases(IDbConnection conn, IDbTransaction tran)
at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(PerformDBOperationExpression expression)
at FluentMigrator.Expressions.PerformDBOperationExpression.ExecuteWith(IMigrationProcessor processor)
at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass80_0.<ExecuteExpressions>b__1()
at FluentMigrator.Runner.StopWatch.Time(Action action)
at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions)
at FluentMigrator.Runner.MigrationRunner.ExecuteMigration(IMigration migration, Action`2 getExpressions)
at FluentMigrator.Runner.MigrationRunner.ApplyMigrationUp(IMigrationInfo migrationInfo, Boolean useTransaction)
at FluentMigrator.Runner.MigrationRunner.MigrateUp(Int64 targetVersion, Boolean useAutomaticTransactionManagement)
at FluentMigrator.Runner.MigrationRunner.MigrateUp(Boolean useAutomaticTransactionManagement)
at FluentMigrator.Runner.MigrationRunner.MigrateUp()
at NzbDrone.Core.Datastore.Migration.Framework.MigrationController.Migrate(String connectionString, MigrationContext migrationContext, DatabaseType databaseType)
at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext, DatabaseType databaseType)
--- End of inner exception stack trace ---
at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext, DatabaseType databaseType) in ./Sonarr.Core/Datastore/DbFactory.cs:line 164
at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in ./Sonarr.Core/Datastore/DbFactory.cs:line 71
at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in ./Sonarr.Core/Datastore/DbFactory.cs:line 59
at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in ./Sonarr.Core/Datastore/Extensions/CompositionExtensions.cs:line 10
at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 8067
at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3727
at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3525
at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3176
at DryIoc.Interpreter.TryInterpretSingletonAndUnwrapContainerException(IResolverContext r, Expression expr, ImMapEntry`1 itemRef, Object& result) in /_/src/DryIoc/Container.cs:line 3105
at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 11136
at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 11055
at DryIoc.Container.ResolveAndCacheKeyed(Int32 serviceTypeHash, Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Object scopeName, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 541
at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 469
at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3661
at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3188
at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3471
at DryIoc.Interpreter.<>c__DisplayClass5_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3370
at DryIoc.Interpreter.<>c__DisplayClass9_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3481
at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
at System.Lazy`1.CreateValue()
at System.Lazy`1.get_Value()
at NzbDrone.Host.Startup.Configure(IApplicationBuilder app, IContainer container, IStartupContext startupContext, Lazy`1 mainDatabaseFactory, Lazy`1 logDatabaseFactory, DatabaseTarget dbTarget, ISingleInstancePolicy singleInstancePolicy, InitializeLogger initializeLogger, ReconfigureLogging reconfigureLogging, IAppFolderFactory appFolderFactory, IProvidePidFile pidFileProvider, IConfigFileProvider configFileProvider, IRuntimeInfo runtimeInfo, IFirewallAdapter firewallAdapter, IEventAggregator eventAggregator, SonarrErrorPipeline errorHandler) in ./Sonarr.Host/Startup.cs:line 225
at System.RuntimeMethodHandle.InvokeMethod(Object target, Span`1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.ConfigureBuilder.<>c__DisplayClass4_0.<Build>b__0(IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass15_0.<UseStartup>b__1(IApplicationBuilder app)
at Microsoft.AspNetCore.Mvc.Filters.MiddlewareFilterBuilderStartupFilter.<>c__DisplayClass0_0.<Configure>g__MiddlewareFilterBuilder|0(IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)
at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host)
at NzbDrone.Host.Bootstrap.Start(String[] args, Action`1 trayCallback) in ./Sonarr.Host/Bootstrap.cs:line 80
at NzbDrone.Console.ConsoleApp.Main(String[] args) in ./Sonarr.Console/ConsoleApp.cs:line 45

Press enter to exit...
Non-recoverable failure, waiting for user intervention...

Experiencing the error NzbDrone.Common.Exceptions.SonarrStartupException: Sonarr failed to start: Error creating main database in your Sonarr Docker container indicates an issue with the application's database, which is crucial for its operation. Here's a structured approach to diagnose and resolve this problem:

 

1. Identify the Database Issue:

Corruption: The database file (nzbdrone.db) might be corrupted, preventing Sonarr from accessing or creating necessary tables.

Permissions: Sonarr may lack the required permissions to read or write to the database file or its directory.

 

2. Verify File Permissions:

Access the Appdata Directory:

Navigate to your Sonarr configuration directory, typically located at /mnt/user/appdata/sonarr/.

 

Check Permissions:

Ensure that the nzbdrone.db file and its parent directory have appropriate read and write permissions for the user under which the Docker container operates.

Adjust Permissions if Necessary:Use the chmod command to modify permissions:

chmod 755 /mnt/user/appdata/sonarr/
chmod 644 /mnt/user/appdata/sonarr/nzbdrone.db

 

Alternatively, you can reset permissions using Unraid's built-in tools or community plugins designed for this purpose.

WebUI > Tool > Docker Safe PErm
 

Restore from a Backup if you have one...

Locate Backups:

If you have previously configured Sonarr to create backups, they are usually stored in the Backups folder within the Sonarr configuration directory.

Restore Process:

Stop the Sonarr Docker container to prevent any conflicts.

Replace the corrupted nzbdrone.db file with a recent backup.

Restart the Sonarr container and verify if the application starts without errors.

 

4. Rebuild the Database:

Backup Existing Database:

Before making changes, create a backup of the current nzbdrone.db file.

Recreate the Database:

Stop the Sonarr container.

Delete or rename the existing nzbdrone.db file.

Start the Sonarr container; it should generate a new, clean database file.

Reconfigure Sonarr:

With a new database, you'll need to reconfigure your settings and re-add your series.

 

5. Monitor for Recurrence:

Regular Backups:

Set up automated backups within Sonarr to safeguard against future database issues.

System Stability:

Ensure your Unraid server is stable, and consider using an Uninterruptible Power Supply (UPS) to protect against power-related disruptions that could corrupt the database.

For further assistance, consider consulting the Unraid community forums or the Sonarr support channels, where similar issues have been discussed and resolved

 

 

 

By following these steps, you should be able to address the database error and restore Sonarr's functionality.

It was the database having an issue.
I deleted the db and it recreated and started up.

Thanks for the help