Hello.
I am having issues accessing Sonarr by the web interface further investigation of the debug shown the following
mono --debug NzbDrone.exe
[Info] Bootstrap: Starting Sonarr - /opt/NzbDrone/NzbDrone.exe - Version 2.0.0.3357
[Debug] ProcessProvider: Found 0 processes with the name: NzbDrone.Console
[Debug] ProcessProvider: Found 1 processes with the name: NzbDrone
[Debug] ProcessProvider: - [13944] NzbDrone
[Info] MigrationLogger: *** Migrating data source=/home/jonesd/.config/NzbDrone/nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
[Debug] MigrationLogger: Took: 00:00:00.1751286
[Info] MigrationLogger: *** Migrating data source=/home/jonesd/.config/NzbDrone/logs.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
[Debug] MigrationLogger: Took: 00:00:00.0109153
[Info] Router: Application mode: Interactive
[Debug] Router: Console selected
[Info] OwinHostController: Listening on the following URLs:
[Info] OwinHostController: http://*:2010/
[Debug] OwinAppFactory: Attaching NzbDroneVersionMiddleWare to host
[Debug] OwinAppFactory: Attaching SignalRMiddleWare to host
[Debug] OwinAppFactory: Attaching NancyMiddleWare to host
[Info] NancyBootstrapper: Starting NzbDrone API
[Trace] EventAggregator: Publishing ApplicationStartedEvent
[Trace] EventAggregator: ApplicationStartedEvent -> UserService
[Trace] EventAggregator: ApplicationStartedEvent <- UserService
[Trace] EventAggregator: ApplicationStartedEvent -> DownloadClientFactory
[Debug] DownloadClientFactory: Initializing Providers. Count 9
[Trace] EventAggregator: ApplicationStartedEvent <- DownloadClientFactory
[Trace] EventAggregator: ApplicationStartedEvent -> IndexerFactory
[Debug] IndexerFactory: Initializing Providers. Count 14
[Trace] EventAggregator: ApplicationStartedEvent <- IndexerFactory
[Trace] EventAggregator: ApplicationStartedEvent -> ReconfigureLogging
[Error] EventAggregator: TaskManager failed while processing [ApplicationStartedEvent]
System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0
at Marr.Data.QGen.UpdateQueryBuilder`1[NzbDrone.Core.Jobs.ScheduledTask].Execute () [0x0003b] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\QGen\UpdateQueryBuilder.cs:157
at Marr.Data.DataMapper.Update[ScheduledTask] (NzbDrone.Core.Jobs.ScheduledTask entity, System.Linq.Expressions.Expression`1 filter) [0x00000] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:674
at NzbDrone.Core.Datastore.BasicRepository`1[NzbDrone.Core.Jobs.ScheduledTask].Update (NzbDrone.Core.Jobs.ScheduledTask model) [0x0002b] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\BasicRepository.cs:131
at NzbDrone.Core.Datastore.BasicRepository`1[NzbDrone.Core.Jobs.ScheduledTask].Upsert (NzbDrone.Core.Jobs.ScheduledTask model) [0x00019] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\BasicRepository.cs:192
at NzbDrone.Core.Jobs.TaskManager.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x002ff] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Jobs\TaskManager.cs:110
at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[ApplicationStartedEvent] (NzbDrone.Core.Lifecycle.ApplicationStartedEvent event) [0x000c5] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:56
[Error] EventAggregator: CommandQueueManager failed while processing [ApplicationStartedEvent]
System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0
at Marr.Data.DataMapper.ExecuteNonQuery (System.String sql) [0x0002a] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:204
at NzbDrone.Core.Messaging.Commands.CommandRepository.OrphanStarted () [0x00064] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Messaging\Commands\CommandRepository.cs:46
at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00010] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:209
at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[ApplicationStartedEvent] (NzbDrone.Core.Lifecycle.ApplicationStartedEvent event) [0x000c5] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:56
[Error] TaskExtensions: Task Error
System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement) <IL 0x0009f, 0x0026b>
at System.Data.SQLite.SQLiteDataReader.NextResult () <IL 0x00172, 0x006c6>
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior) <IL 0x00091, 0x00299>
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior) <IL 0x0001b, 0x00047>
at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior) <IL 0x0000e, 0x00043>
at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior) <IL 0x0000c, 0x00037>
at System.Data.SQLite.SQLiteCommand.ExecuteScalar () <IL 0x00008, 0x0001f>
at Marr.Data.QGen.InsertQueryBuilder`1<NzbDrone.Core.Messaging.Commands.CommandModel>.Execute () <0x000d3>
at Marr.Data.DataMapper.Insert<NzbDrone.Core.Messaging.Commands.CommandModel> (NzbDrone.Core.Messaging.Commands.CommandModel) <0x00144>
at NzbDrone.Core.Datastore.BasicRepository`1<NzbDrone.Core.Messaging.Commands.CommandModel>.Insert (NzbDrone.Core.Messaging.Commands.CommandModel) <0x00071>
at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push<NzbDrone.Core.Download.CheckForFinishedDownloadCommand> (NzbDrone.Core.Download.CheckForFinishedDownloadCommand,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) <0x004e1>
at (wrapper dynamic-method) object.CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) <IL 0x0005d, 0x000f6>
at System.Dynamic.UpdateDelegates.UpdateAndExecute4<NzbDrone.Core.Messaging.Commands.CommandQueueManager, object, NzbDrone.Core.Messaging.Commands.CommandPriority, NzbDrone.Core.Messaging.Commands.CommandTrigger, object> (System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) <IL 0x00152, 0x00579>
at (wrapper delegate-invoke) System.Func`6<System.Runtime.CompilerServices.CallSite, NzbDrone.Core.Messaging.Commands.CommandQueueManager, object, NzbDrone.Core.Messaging.Commands.CommandPriority, NzbDrone.Core.Messaging.Commands.CommandTrigger, object>.invoke_TResult__this___T1_T2_T3_T4_T5 (System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) <IL 0x00063, 0x00096>
at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (string,System.Nullable`1<System.DateTime>,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) [0x000bb] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:95
at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Jobs\Scheduler.cs:43
at System.Threading.Tasks.TaskActionInvoker/ActionInvoke.Invoke (System.Threading.Tasks.Task,object,System.Threading.Tasks.Task) <IL 0x00006, 0x0001a>
at System.Threading.Tasks.Task.InnerInvoke () <IL 0x0003f, 0x0006c>
at System.Threading.Tasks.Task.ThreadStart () <IL 0x00098, 0x0028f>
[Error] EventAggregator: QualityDefinitionService failed while processing [ApplicationStartedEvent]
System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0
at Marr.Data.QGen.UpdateQueryBuilder`1[NzbDrone.Core.Qualities.QualityDefinition].Execute () [0x0003b] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\QGen\UpdateQueryBuilder.cs:157
at Marr.Data.DataMapper.Update[QualityDefinition] (NzbDrone.Core.Qualities.QualityDefinition entity, System.Linq.Expressions.Expression`1 filter) [0x00000] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:674
at NzbDrone.Core.Datastore.BasicRepository`1[NzbDrone.Core.Qualities.QualityDefinition].UpdateMany (IList`1 models) [0x00060] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\BasicRepository.cs:173
at NzbDrone.Core.Qualities.QualityDefinitionService.InsertMissingDefinitions () [0x000d2] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:84
at NzbDrone.Core.Qualities.QualityDefinitionService.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00010] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:101
at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[ApplicationStartedEvent] (NzbDrone.Core.Lifecycle.ApplicationStartedEvent event) [0x000c5] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:56
[Info] SceneMappingService: Updating Scene mappings
[Fatal] ConsoleApp: Address already in use. This can happen if another instance of Sonarr is already running another application is using the same port (default: 8989) or the user has insufficient permissions
Press any key to exit...
[Info] HousekeepingService: Running housecleaning tasks
[Error] TaskExtensions: Task Error
System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement) <IL 0x0009f, 0x0026b>
at System.Data.SQLite.SQLiteDataReader.NextResult () <IL 0x00172, 0x006c6>
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior) <IL 0x00091, 0x00299>
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior) <IL 0x0001b, 0x00047>
at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior) <IL 0x0000e, 0x00043>
at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior) <IL 0x0000c, 0x00037>
at System.Data.SQLite.SQLiteCommand.ExecuteScalar () <IL 0x00008, 0x0001f>
at Marr.Data.QGen.InsertQueryBuilder`1<NzbDrone.Core.Messaging.Commands.CommandModel>.Execute () <0x000d3>
at Marr.Data.DataMapper.Insert<NzbDrone.Core.Messaging.Commands.CommandModel> (NzbDrone.Core.Messaging.Commands.CommandModel) <0x00144>
at NzbDrone.Core.Datastore.BasicRepository`1<NzbDrone.Core.Messaging.Commands.CommandModel>.Insert (NzbDrone.Core.Messaging.Commands.CommandModel) <0x00071>
at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push<NzbDrone.Core.Download.CheckForFinishedDownloadCommand> (NzbDrone.Core.Download.CheckForFinishedDownloadCommand,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) <0x004e1>
at (wrapper dynamic-method) object.CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) <IL 0x0005d, 0x000f6>
at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (string,System.Nullable`1<System.DateTime>,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger) [0x000bb] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:95
at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Jobs\Scheduler.cs:43
at System.Threading.Tasks.TaskActionInvoker/ActionInvoke.Invoke (System.Threading.Tasks.Task,object,System.Threading.Tasks.Task) <IL 0x00006, 0x0001a>
at System.Threading.Tasks.Task.InnerInvoke () <IL 0x0003f, 0x0006c>
at System.Threading.Tasks.Task.ThreadStart () <IL 0x00098, 0x0028f>
[Error] HousekeepingService: Error running housekeeping task: CleanupAdditionalNamingSpecs
System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0
at Marr.Data.DataMapper.ExecuteNonQuery (System.String sql) [0x0002a] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:204
at NzbDrone.Core.Housekeeping.Housekeepers.CleanupAdditionalNamingSpecs.Clean () [0x0000c] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Housekeeping\Housekeepers\CleanupAdditionalNamingSpecs.cs:18
at NzbDrone.Core.Housekeeping.HousekeepingService.Clean () [0x00040] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Housekeeping\HousekeepingService.cs:34
[Error] SceneMappingService: Failed to Update Scene Mappings:
System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0
at Marr.Data.DataMapper.Delete[SceneMapping] (System.String tableName, System.Linq.Expressions.Expression`1 filter) [0x00091] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:803
at Marr.Data.DataMapper.Delete[SceneMapping] (System.Linq.Expressions.Expression`1 filter) [0x00000] in m:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:777
at NzbDrone.Core.Datastore.BasicRepository`1[NzbDrone.Core.DataAugmentation.Scene.SceneMapping].Delete (System.Linq.Expressions.Expression`1 filter) [0x00000] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\Datastore\BasicRepository.cs:61
at NzbDrone.Core.DataAugmentation.Scene.SceneMappingRepository.Clear (System.String type) [0x0000d] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\DataAugmentation\Scene\SceneMappingRepository.cs:28
at NzbDrone.Core.DataAugmentation.Scene.SceneMappingService.UpdateMappings () [0x0003f] in m:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\DataAugmentation\Scene\SceneMappingService.cs:113
I cannot kill the Mono Process even after a restart I was wondering if anyone else has recovered from this issue?
I have tried to reinstall Mono and nzbdrone to no avail I was going to rename the DB and restart the service but I dont want to create any undue work. any help would be appreciated