Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2022-11-21 07:59:07.1|Info|InstallUpdateService|Downloading update 1.1.2.2815
- 2022-11-21 07:59:42.4|Info|InstallUpdateService|Verifying update package
- 2022-11-21 07:59:42.6|Info|InstallUpdateService|Update package verified successfully
- 2022-11-21 07:59:42.6|Info|InstallUpdateService|Extracting Update package
- 2022-11-21 07:59:49.0|Info|InstallUpdateService|Update package extracted successfully
- 2022-11-21 07:59:49.0|Info|BackupService|Starting Backup
- 2022-11-21 08:00:36.2|Info|InstallUpdateService|Preparing client
- 2022-11-21 08:00:38.4|Info|InstallUpdateService|Starting update client C:\Users\(removed)\AppData\Local\Temp\lidarr_update\Lidarr.Update.exe
- 2022-11-21 08:00:38.4|Info|InstallUpdateService|Lidarr will restart shortly.
- 2022-11-21 08:00:38.4|Info|InstallUpdateService|Updater Arguments: 17524 C:\Users\(removed)\AppData\Local\Temp\lidarr_update C:\ProgramData\Lidarr\bin\Lidarr.exe
- 2022-11-21 08:00:52.3|Info|Bootstrap|Starting Lidarr - C:\ProgramData\Lidarr\bin\Lidarr.dll - Version 1.1.2.2815
- 2022-11-21 08:00:53.3|Info|MigrationController|*** Migrating data source=C:\ProgramData\Lidarr\lidarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
- 2022-11-21 08:00:53.5|Info|FluentMigrator.Runner.MigrationRunner|61: postgres_update_timestamp_columns_to_with_timezone migrating
- 2022-11-21 08:00:53.5|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 08:00:53.5|Info|postgres_update_timestamp_columns_to_with_timezone|Starting migration of Main DB to 61
- 2022-11-21 08:00:53.5|Info|FluentMigrator.Runner.MigrationRunner|AlterTable AlbumReleases
- 2022-11-21 08:00:53.5|Info|FluentMigrator.Runner.MigrationRunner|=> 0.0002968s
- 2022-11-21 08:00:53.5|Info|FluentMigrator.Runner.MigrationRunner|AlterColumn AlbumReleases ReleaseDate DateTimeOffset
- 2022-11-21 08:00:53.5|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|CREATE TABLE "AlbumReleases_temp" ("Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ForeignReleaseId" TEXT NOT NULL, "AlbumId" INTEGER NOT NULL, "Title" TEXT NOT NULL, "Status" TEXT NOT NULL, "Duration" INTEGER NOT NULL, "Label" TEXT, "Disambiguation" TEXT, "Country" TEXT, "ReleaseDate" DATETIME NOT NULL, "Media" TEXT, "TrackCount" INTEGER, "Monitored" INTEGER NOT NULL, "OldForeignReleaseIds" TEXT NOT NULL)
- 2022-11-21 08:00:53.5|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases"
- 2022-11-21 08:00:53.5|Error|FluentMigrator.Runner.MigrationRunner|constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- [v1.1.2.2815] System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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)
- 2022-11-21 08:00:53.7|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Rolling back transaction
- 2022-11-21 08:00:53.7|Fatal|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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)
- 2022-11-21 08:00:53.8|Fatal|WindowsApp|EPIC FAIL: Lidarr failed to start: Error creating main database
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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 D:\a\1\s\src\NzbDrone.Host\Bootstrap.cs:line 78
- at NzbDrone.WindowsApp.Main(String[] args) in D:\a\1\s\src\NzbDrone\WindowsApp.cs:line 29
- 2022-11-21 10:00:07.0|Info|Bootstrap|Starting Lidarr - C:\ProgramData\Lidarr\bin\Lidarr.dll - Version 1.1.2.2815
- 2022-11-21 10:00:07.7|Info|MigrationController|*** Migrating data source=C:\ProgramData\Lidarr\lidarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
- 2022-11-21 10:00:07.8|Info|FluentMigrator.Runner.MigrationRunner|61: postgres_update_timestamp_columns_to_with_timezone migrating
- 2022-11-21 10:00:07.8|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 10:00:07.8|Info|postgres_update_timestamp_columns_to_with_timezone|Starting migration of Main DB to 61
- 2022-11-21 10:00:07.8|Info|FluentMigrator.Runner.MigrationRunner|AlterTable AlbumReleases
- 2022-11-21 10:00:07.8|Info|FluentMigrator.Runner.MigrationRunner|=> 0.0003066s
- 2022-11-21 10:00:07.8|Info|FluentMigrator.Runner.MigrationRunner|AlterColumn AlbumReleases ReleaseDate DateTimeOffset
- 2022-11-21 10:00:07.9|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|CREATE TABLE "AlbumReleases_temp" ("Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ForeignReleaseId" TEXT NOT NULL, "AlbumId" INTEGER NOT NULL, "Title" TEXT NOT NULL, "Status" TEXT NOT NULL, "Duration" INTEGER NOT NULL, "Label" TEXT, "Disambiguation" TEXT, "Country" TEXT, "ReleaseDate" DATETIME NOT NULL, "Media" TEXT, "TrackCount" INTEGER, "Monitored" INTEGER NOT NULL, "OldForeignReleaseIds" TEXT NOT NULL)
- 2022-11-21 10:00:07.9|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases"
- 2022-11-21 10:00:07.9|Error|FluentMigrator.Runner.MigrationRunner|constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- [v1.1.2.2815] System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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)
- 2022-11-21 10:00:08.0|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Rolling back transaction
- 2022-11-21 10:00:08.0|Fatal|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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)
- 2022-11-21 10:00:08.1|Fatal|WindowsApp|EPIC FAIL: Lidarr failed to start: Error creating main database
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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 D:\a\1\s\src\NzbDrone.Host\Bootstrap.cs:line 78
- at NzbDrone.WindowsApp.Main(String[] args) in D:\a\1\s\src\NzbDrone\WindowsApp.cs:line 29
- 2022-11-21 10:09:51.5|Info|Bootstrap|Starting Lidarr - C:\ProgramData\Lidarr\bin\Lidarr.dll - Version 1.1.2.2815
- 2022-11-21 10:09:54.9|Info|MigrationController|*** Migrating data source=C:\ProgramData\Lidarr\lidarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
- 2022-11-21 10:09:55.4|Info|FluentMigrator.Runner.MigrationRunner|61: postgres_update_timestamp_columns_to_with_timezone migrating
- 2022-11-21 10:09:55.4|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 10:09:55.4|Info|postgres_update_timestamp_columns_to_with_timezone|Starting migration of Main DB to 61
- 2022-11-21 10:09:55.5|Info|FluentMigrator.Runner.MigrationRunner|AlterTable AlbumReleases
- 2022-11-21 10:09:55.5|Info|FluentMigrator.Runner.MigrationRunner|=> 0.0004431s
- 2022-11-21 10:09:55.5|Info|FluentMigrator.Runner.MigrationRunner|AlterColumn AlbumReleases ReleaseDate DateTimeOffset
- 2022-11-21 10:09:55.5|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|CREATE TABLE "AlbumReleases_temp" ("Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ForeignReleaseId" TEXT NOT NULL, "AlbumId" INTEGER NOT NULL, "Title" TEXT NOT NULL, "Status" TEXT NOT NULL, "Duration" INTEGER NOT NULL, "Label" TEXT, "Disambiguation" TEXT, "Country" TEXT, "ReleaseDate" DATETIME NOT NULL, "Media" TEXT, "TrackCount" INTEGER, "Monitored" INTEGER NOT NULL, "OldForeignReleaseIds" TEXT NOT NULL)
- 2022-11-21 10:09:55.6|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases"
- 2022-11-21 10:09:55.6|Error|FluentMigrator.Runner.MigrationRunner|constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- [v1.1.2.2815] System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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)
- 2022-11-21 10:09:56.0|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Rolling back transaction
- 2022-11-21 10:09:56.0|Fatal|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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)
- 2022-11-21 10:09:56.2|Fatal|WindowsApp|EPIC FAIL: Lidarr failed to start: Error creating main database
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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 D:\a\1\s\src\NzbDrone.Host\Bootstrap.cs:line 78
- at NzbDrone.WindowsApp.Main(String[] args) in D:\a\1\s\src\NzbDrone\WindowsApp.cs:line 29
- 2022-11-21 10:44:20.9|Info|Bootstrap|Starting Lidarr - C:\ProgramData\Lidarr\bin\Lidarr.dll - Version 1.1.2.2815
- 2022-11-21 10:44:22.1|Info|MigrationController|*** Migrating data source=C:\ProgramData\Lidarr\lidarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
- 2022-11-21 10:44:22.3|Info|FluentMigrator.Runner.MigrationRunner|61: postgres_update_timestamp_columns_to_with_timezone migrating
- 2022-11-21 10:44:22.3|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 10:44:22.3|Info|postgres_update_timestamp_columns_to_with_timezone|Starting migration of Main DB to 61
- 2022-11-21 10:44:22.3|Info|FluentMigrator.Runner.MigrationRunner|AlterTable AlbumReleases
- 2022-11-21 10:44:22.3|Info|FluentMigrator.Runner.MigrationRunner|=> 0.0004072s
- 2022-11-21 10:44:22.3|Info|FluentMigrator.Runner.MigrationRunner|AlterColumn AlbumReleases ReleaseDate DateTimeOffset
- 2022-11-21 10:44:22.4|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|CREATE TABLE "AlbumReleases_temp" ("Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ForeignReleaseId" TEXT NOT NULL, "AlbumId" INTEGER NOT NULL, "Title" TEXT NOT NULL, "Status" TEXT NOT NULL, "Duration" INTEGER NOT NULL, "Label" TEXT, "Disambiguation" TEXT, "Country" TEXT, "ReleaseDate" DATETIME NOT NULL, "Media" TEXT, "TrackCount" INTEGER, "Monitored" INTEGER NOT NULL, "OldForeignReleaseIds" TEXT NOT NULL)
- 2022-11-21 10:44:22.4|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases"
- 2022-11-21 10:44:22.4|Error|FluentMigrator.Runner.MigrationRunner|constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- [v1.1.2.2815] System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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)
- 2022-11-21 10:44:22.5|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Rolling back transaction
- 2022-11-21 10:44:22.5|Fatal|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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)
- 2022-11-21 10:44:22.6|Fatal|WindowsApp|EPIC FAIL: Lidarr failed to start: Error creating main database
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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 D:\a\1\s\src\NzbDrone.Host\Bootstrap.cs:line 78
- at NzbDrone.WindowsApp.Main(String[] args) in D:\a\1\s\src\NzbDrone\WindowsApp.cs:line 29
- 2022-11-21 10:47:41.8|Info|Bootstrap|Starting Lidarr - C:\ProgramData\Lidarr\bin\Lidarr.dll - Version 1.1.2.2815
- 2022-11-21 10:47:42.3|Info|MigrationController|*** Migrating data source=C:\ProgramData\Lidarr\lidarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
- 2022-11-21 10:47:42.4|Info|FluentMigrator.Runner.MigrationRunner|61: postgres_update_timestamp_columns_to_with_timezone migrating
- 2022-11-21 10:47:42.4|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 10:47:42.4|Info|postgres_update_timestamp_columns_to_with_timezone|Starting migration of Main DB to 61
- 2022-11-21 10:47:42.4|Info|FluentMigrator.Runner.MigrationRunner|AlterTable AlbumReleases
- 2022-11-21 10:47:42.4|Info|FluentMigrator.Runner.MigrationRunner|=> 0.000269s
- 2022-11-21 10:47:42.4|Info|FluentMigrator.Runner.MigrationRunner|AlterColumn AlbumReleases ReleaseDate DateTimeOffset
- 2022-11-21 10:47:42.4|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|CREATE TABLE "AlbumReleases_temp" ("Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ForeignReleaseId" TEXT NOT NULL, "AlbumId" INTEGER NOT NULL, "Title" TEXT NOT NULL, "Status" TEXT NOT NULL, "Duration" INTEGER NOT NULL, "Label" TEXT, "Disambiguation" TEXT, "Country" TEXT, "ReleaseDate" DATETIME NOT NULL, "Media" TEXT, "TrackCount" INTEGER, "Monitored" INTEGER NOT NULL, "OldForeignReleaseIds" TEXT NOT NULL)
- 2022-11-21 10:47:42.4|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases"
- 2022-11-21 10:47:42.4|Error|FluentMigrator.Runner.MigrationRunner|constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- [v1.1.2.2815] System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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)
- 2022-11-21 10:47:42.6|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Rolling back transaction
- 2022-11-21 10:47:42.6|Fatal|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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)
- 2022-11-21 10:47:42.6|Fatal|WindowsApp|EPIC FAIL: Lidarr failed to start: Error creating main database
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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 D:\a\1\s\src\NzbDrone.Host\Bootstrap.cs:line 78
- at NzbDrone.WindowsApp.Main(String[] args) in D:\a\1\s\src\NzbDrone\WindowsApp.cs:line 29
- 2022-11-21 10:51:02.1|Info|Bootstrap|Starting Lidarr - C:\ProgramData\Lidarr\bin\Lidarr.dll - Version 1.1.2.2815
- 2022-11-21 10:51:02.6|Info|MigrationController|*** Migrating data source=C:\ProgramData\Lidarr\lidarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
- 2022-11-21 10:51:02.7|Info|FluentMigrator.Runner.MigrationRunner|61: postgres_update_timestamp_columns_to_with_timezone migrating
- 2022-11-21 10:51:02.7|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 10:51:02.7|Info|postgres_update_timestamp_columns_to_with_timezone|Starting migration of Main DB to 61
- 2022-11-21 10:51:02.7|Info|FluentMigrator.Runner.MigrationRunner|AlterTable AlbumReleases
- 2022-11-21 10:51:02.7|Info|FluentMigrator.Runner.MigrationRunner|=> 0.0004875s
- 2022-11-21 10:51:02.7|Info|FluentMigrator.Runner.MigrationRunner|AlterColumn AlbumReleases ReleaseDate DateTimeOffset
- 2022-11-21 10:51:02.7|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|CREATE TABLE "AlbumReleases_temp" ("Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ForeignReleaseId" TEXT NOT NULL, "AlbumId" INTEGER NOT NULL, "Title" TEXT NOT NULL, "Status" TEXT NOT NULL, "Duration" INTEGER NOT NULL, "Label" TEXT, "Disambiguation" TEXT, "Country" TEXT, "ReleaseDate" DATETIME NOT NULL, "Media" TEXT, "TrackCount" INTEGER, "Monitored" INTEGER NOT NULL, "OldForeignReleaseIds" TEXT NOT NULL)
- 2022-11-21 10:51:02.7|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases"
- 2022-11-21 10:51:02.7|Error|FluentMigrator.Runner.MigrationRunner|constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- [v1.1.2.2815] System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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)
- 2022-11-21 10:51:02.9|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Rolling back transaction
- 2022-11-21 10:51:02.9|Fatal|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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)
- 2022-11-21 10:51:02.9|Fatal|WindowsApp|EPIC FAIL: Lidarr failed to start: Error creating main database
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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 D:\a\1\s\src\NzbDrone.Host\Bootstrap.cs:line 78
- at NzbDrone.WindowsApp.Main(String[] args) in D:\a\1\s\src\NzbDrone\WindowsApp.cs:line 29
- 2022-11-21 10:52:03.1|Info|Bootstrap|Starting Lidarr - C:\ProgramData\Lidarr\bin\Lidarr.dll - Version 1.1.2.2815
- 2022-11-21 10:52:03.6|Info|MigrationController|*** Migrating data source=C:\ProgramData\Lidarr\lidarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
- 2022-11-21 10:52:03.7|Info|FluentMigrator.Runner.MigrationRunner|60: update_audio_types migrating
- 2022-11-21 10:52:03.7|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 10:52:03.7|Info|update_audio_types|Starting migration of Main DB to 60
- 2022-11-21 10:52:03.7|Info|FluentMigrator.Runner.MigrationRunner|PerformDBOperation
- 2022-11-21 10:52:03.7|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Performing DB Operation
- 2022-11-21 10:52:03.8|Info|FluentMigrator.Runner.MigrationRunner|=> 0.0505952s
- 2022-11-21 10:52:03.8|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "VersionInfo" ("Version", "AppliedOn", "Description") VALUES (60, '2022-11-20T23:52:03', 'update_audio_types')
- 2022-11-21 10:52:03.8|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Committing Transaction
- 2022-11-21 10:52:03.8|Info|FluentMigrator.Runner.MigrationRunner|60: update_audio_types migrated
- 2022-11-21 10:52:03.8|Info|FluentMigrator.Runner.MigrationRunner|=> 0.0739764s
- 2022-11-21 10:52:03.8|Info|FluentMigrator.Runner.MigrationRunner|61: postgres_update_timestamp_columns_to_with_timezone migrating
- 2022-11-21 10:52:03.8|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Beginning Transaction
- 2022-11-21 10:52:03.8|Info|postgres_update_timestamp_columns_to_with_timezone|Starting migration of Main DB to 61
- 2022-11-21 10:52:03.8|Info|FluentMigrator.Runner.MigrationRunner|AlterTable AlbumReleases
- 2022-11-21 10:52:03.8|Info|FluentMigrator.Runner.MigrationRunner|=> 0.000109s
- 2022-11-21 10:52:03.8|Info|FluentMigrator.Runner.MigrationRunner|AlterColumn AlbumReleases ReleaseDate DateTimeOffset
- 2022-11-21 10:52:03.8|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|CREATE TABLE "AlbumReleases_temp" ("Id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "ForeignReleaseId" TEXT NOT NULL, "AlbumId" INTEGER NOT NULL, "Title" TEXT NOT NULL, "Status" TEXT NOT NULL, "Duration" INTEGER NOT NULL, "Label" TEXT, "Disambiguation" TEXT, "Country" TEXT, "ReleaseDate" DATETIME NOT NULL, "Media" TEXT, "TrackCount" INTEGER, "Monitored" INTEGER NOT NULL, "OldForeignReleaseIds" TEXT NOT NULL)
- 2022-11-21 10:52:03.8|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases"
- 2022-11-21 10:52:03.8|Error|FluentMigrator.Runner.MigrationRunner|constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- [v1.1.2.2815] System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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)
- 2022-11-21 10:52:03.9|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Rolling back transaction
- 2022-11-21 10:52:03.9|Fatal|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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)
- 2022-11-21 10:52:04.0|Fatal|WindowsApp|EPIC FAIL: Lidarr failed to start: Error creating main database
- [v1.1.2.2815] NzbDrone.Common.Exceptions.LidarrStartupException: Lidarr failed to start: Error creating main database
- ---> System.Exception: constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- While Processing:
- "INSERT INTO "AlbumReleases_temp" ("Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds") SELECT "Id", "ForeignReleaseId", "AlbumId", "Title", "Status", "Duration", "Label", "Disambiguation", "Country", "ReleaseDate", "Media", "TrackCount", "Monitored", "OldForeignReleaseIds" FROM "AlbumReleases""
- ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
- NOT NULL constraint failed: AlbumReleases_temp.ReleaseDate
- at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
- at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
- at System.Data.SQLite.SQLiteDataReader.NextResult()
- at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
- at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
- at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- --- End of inner exception stack trace ---
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.ExecuteNonQuery(String sql)
- at FluentMigrator.Runner.Processors.SQLite.SQLiteProcessor.Process(String sql)
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.ProcessAlterTable(TableDefinition tableDefinition, List`1 oldColumnDefinitions) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 137
- at NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor.Process(AlterColumnExpression expression) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\NzbDroneSQLiteProcessor.cs:line 45
- at FluentMigrator.Expressions.AlterColumnExpression.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) in D:\a\1\s\src\NzbDrone.Core\Datastore\Migration\Framework\MigrationController.cs:line 79
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 115
- --- End of inner exception stack trace ---
- at NzbDrone.Core.Datastore.DbFactory.CreateMain(String connectionString, MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 161
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationContext migrationContext) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 70
- at NzbDrone.Core.Datastore.DbFactory.Create(MigrationType migrationType) in D:\a\1\s\src\NzbDrone.Core\Datastore\DbFactory.cs:line 58
- at NzbDrone.Core.Datastore.Extensions.CompositionExtensions.<>c.<AddDatabase>b__0_0(IDbFactory f) in D:\a\1\s\src\NzbDrone.Core\Datastore\Extensions\CompositionExtensions.cs:line 10
- at DryIoc.Registrator.ToFuncWithObjParams[D1,TService](Func`2 f, Object d1) in /_/src/DryIoc/Container.cs:line 7862
- at DryIoc.Interpreter.TryInterpretFuncInvoke(IResolverContext r, MethodCallExpression e, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3619
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3417
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3073
- at DryIoc.Interpreter.TryInterpretAndUnwrapContainerException(IResolverContext r, Expression expr, Object& result) in /_/src/DryIoc/Container.cs:line 3007
- at DryIoc.Factory.ApplyReuse(Expression serviceExpr, Request request) in /_/src/DryIoc/Container.cs:line 10888
- at DryIoc.Factory.GetExpressionOrDefault(Request request) in /_/src/DryIoc/Container.cs:line 10807
- 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 531
- at DryIoc.Container.DryIoc.IResolver.Resolve(Type serviceType, Object serviceKey, IfUnresolved ifUnresolved, Type requiredServiceType, Request preResolveParent, Object[] args) in /_/src/DryIoc/Container.cs:line 459
- at DryIoc.Interpreter.TryInterpretMethodCall(IResolverContext r, MethodCallExpression callExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3553
- at DryIoc.Interpreter.TryInterpret(IResolverContext r, Expression expr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs, Object& result) in /_/src/DryIoc/Container.cs:line 3082
- at DryIoc.Interpreter.TryInterpretNestedLambdaBodyAndUnwrapException(IResolverContext r, Expression bodyExpr, IParameterProvider paramExprs, Object paramValues, ParentLambdaArgs parentArgs) in /_/src/DryIoc/Container.cs:line 3363
- at DryIoc.Interpreter.<>c__DisplayClass3_0.<TryInterpretNestedLambda>b__0() in /_/src/DryIoc/Container.cs:line 3262
- at DryIoc.Interpreter.<>c__DisplayClass7_0`1.<ConvertFunc>b__0() in /_/src/DryIoc/Container.cs:line 3373
- 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, 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, LidarrErrorPipeline errorHandler) in D:\a\1\s\src\NzbDrone.Host\Startup.cs:line 229
- 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 D:\a\1\s\src\NzbDrone.Host\Bootstrap.cs:line 78
- at NzbDrone.WindowsApp.Main(String[] args) in D:\a\1\s\src\NzbDrone\WindowsApp.cs:line 29
Advertisement
Add Comment
Please, Sign In to add comment