Sonarr unresponsive for some periods of time

Help & Support
1

Only errors I could find in the log are down below.
Sonarr Version 2.0.0.3580
Mono Version 4.2.1
Installed on a Readynas RN314

Everything seems to be functioning as normal, but there appears to be at times some unresponsivness.
However I’m not sure if it’s to do with these errors in the logs or its just my nas with limited resources.

Thanks in advance :slight_smile:

5-11-26 22:53:18.4|Error|EventAggregator|HistoryService failed while processing [EpisodeGrabbedEvent]

System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) <0x419754d0 + 0x002ab> in :0
at System.Data.SQLite.SQLiteDataReader.NextResult () <0x41972840 + 0x00741> in :0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) <0x41972160 + 0x002b9> in :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) <0x41971760 + 0x00043> in :0
at System.Data.SQLite.SQLiteCommand.ExecuteScalar (CommandBehavior behavior) <0x41b228d0 + 0x00037> in :0
at System.Data.SQLite.SQLiteCommand.ExecuteScalar () <0x41b225a0 + 0x0001b> in :0
at Marr.Data.QGen.InsertQueryBuilder1[T].Execute () <0x41b211f0 + 0x000d3> in <filename unknown>:0 at Marr.Data.DataMapper.Insert[T] (Marr.Data.T entity) <0x41b20b90 + 0x00158> in <filename unknown>:0 at NzbDrone.Core.Datastore.BasicRepository1[TModel].Insert (NzbDrone.Core.Datastore.TModel model) <0x41b7aed0 + 0x00075> in :0
at NzbDrone.Core.History.HistoryService.Handle (NzbDrone.Core.Download.EpisodeGrabbedEvent message) <0x405f1320 + 0x008c8> in :0
at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (NzbDrone.Core.Messaging.Events.TEvent event) <0x419ea5a0 + 0x00404> in :0

15-11-26 22:57:37.7|Info|DownloadDecisionMaker|Processing 21 releases
15-11-26 23:00:01.3|Error|NzbDroneErrorPipeline|[PUT /api/episode]

System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) <0x419754d0 + 0x002ab> in :0
at System.Data.SQLite.SQLiteDataReader.NextResult () <0x41972840 + 0x00741> in :0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) <0x41972160 + 0x002b9> in :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) <0x41971760 + 0x00043> in :0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (CommandBehavior behavior) <0x419716a0 + 0x00037> in :0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () <0x41971670 + 0x0001b> in :0
at Marr.Data.QGen.UpdateQueryBuilder1[T].Execute () <0x41a33500 + 0x000bf> in <filename unknown>:0 at NzbDrone.Core.Datastore.BasicRepository1[TModel].SetFields (NzbDrone.Core.Datastore.TModel model, System.Linq.Expressions.Expression1[] properties) <0x41b81200 + 0x0032b> in <filename unknown>:0 at NzbDrone.Core.Tv.EpisodeRepository.SetMonitoredFlat (NzbDrone.Core.Tv.Episode episode, Boolean monitored) <0x40659fb0 + 0x0015b> in <filename unknown>:0 at NzbDrone.Core.Tv.EpisodeService.SetEpisodeMonitored (Int32 episodeId, Boolean monitored) <0x40659f10 + 0x0004f> in <filename unknown>:0 at NzbDrone.Api.Episodes.EpisodeModule.SetMonitored (NzbDrone.Api.Episodes.EpisodeResource episodeResource) <0x40659ec0 + 0x00039> in <filename unknown>:0 at NzbDrone.Api.REST.RestModule1[TResource].<set_UpdateResource>b__13 (System.Object options) <0x40659d40 + 0x00037> in :0
at (wrapper dynamic-method) System.Object:CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func`2<object, object>,object)
at Nancy.Routing.Route+<>c__DisplayClass4.b__3 (System.Object parameters, CancellationToken context) <0x41c02130 + 0x0014f> in :0

15-11-26 23:00:09.3|Fatal|NzbDroneErrorPipeline|Request Failed

System.Data.SQLite.SQLiteException: database is locked
database is locked
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) <0x419754d0 + 0x002ab> in :0
at System.Data.SQLite.SQLiteDataReader.NextResult () <0x41972840 + 0x00741> in :0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, CommandBehavior behave) <0x41972160 + 0x002b9> in :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) <0x41971760 + 0x00043> in :0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (CommandBehavior behavior) <0x419716a0 + 0x00037> in :0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () <0x41971670 + 0x0001b> in :0
at Marr.Data.QGen.UpdateQueryBuilder1[T].Execute () <0x41a33500 + 0x000bf> in <filename unknown>:0 at NzbDrone.Core.Datastore.BasicRepository1[TModel].SetFields (NzbDrone.Core.Datastore.TModel model, System.Linq.Expressions.Expression1[] properties) <0x41b81200 + 0x0032b> in <filename unknown>:0 at NzbDrone.Core.Tv.EpisodeRepository.SetMonitoredFlat (NzbDrone.Core.Tv.Episode episode, Boolean monitored) <0x40659fb0 + 0x0015b> in <filename unknown>:0 at NzbDrone.Core.Tv.EpisodeService.SetEpisodeMonitored (Int32 episodeId, Boolean monitored) <0x40659f10 + 0x0004f> in <filename unknown>:0 at NzbDrone.Api.Episodes.EpisodeModule.SetMonitored (NzbDrone.Api.Episodes.EpisodeResource episodeResource) <0x40659ec0 + 0x00039> in <filename unknown>:0 at NzbDrone.Api.REST.RestModule1[TResource].<set_UpdateResource>b__13 (System.Object options) <0x40659d40 + 0x00037> in :0
at (wrapper dynamic-method) System.Object:CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func`2<object, object>,object)
at Nancy.Routing.Route+<>c__DisplayClass4.b__3 (System.Object parameters, CancellationToken context) <0x41c02130 + 0x0014f> in :0

15-11-26 23:01:38.9|Info|RssSyncService|Starting RSS Sync
15-11-26 23:02:51.2|Info|DownloadDecisionMaker|Processing 200 releases
15-11-26 23:05:31.8|Info|RssSyncService|RSS Sync Completed. Reports found: 200, Reports grabbed: 0

2

If you enable trace logging do you see a lot more database is locked messages at the trace level?

DB locks aren’t usually a problem and things will be retried, but these look to be affecting the UI and normal function of Sonarr.

People are running Sonarr on lower end systems based on the details I found for that model, so that shouldn’t affect things too much, but it might come down to where Sonarr’s app data is stored.

3

Thanks Markus, I’ve just reinstalled sonarr with fresh settings, set up my tv shows again and it seems to not become unresponsive any more.
However I do still receive the occasional ‘database is locked’ error but everything seems to be functioning fine :grin:

4

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