Sonarr just keeps loading


#1

Sonarr version 2.0.0.5252:
Mono version 2.0.0.5252:
OS: Debien
over the last few months It’s been getting increasing difficault for me to access the webgui, it will just get stuck on the loading screen, I’ve tried differant browsers, I’ve done clean installs and then restored, nothing seems to sort the issue seems to have come from the latest update as soon as that installs access is gone. logs are below

Additional Information:
19-1-1 10:35:06.4|Info|Bootstrap|Starting Sonarr - /opt/NzbDrone/NzbDrone.exe - Version 2.0.0.5252
19-1-1 10:35:07.1|Info|AppFolderInfo|Data directory is being overridden to [/config]
19-1-1 10:35:07.2|Info|Router|Application mode: Interactive
19-1-1 10:35:07.4|Info|MigrationLogger|*** Migrating data source=/config/nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
19-1-1 10:35:07.8|Info|MigrationLogger|*** Migrating data source=/config/logs.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
19-1-1 10:35:08.1|Info|OwinHostController|Listening on the following URLs:
19-1-1 10:35:08.1|Info|OwinHostController| http://*:8989/
19-1-1 10:35:08.3|Info|NancyBootstrapper|Starting Web Server
19-1-1 10:35:09.2|Error|EventAggregator|QualityDefinitionService failed while processing [ApplicationStartedEvent]

[v2.0.0.5252] System.Data.SQLite.SQLiteException (0x80004005): database or disk is full
database or disk is full
at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00083] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0003c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0016b] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x00090] in <61a20cde294d4a3eb43b9d9f6284613b>: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 (System.Data.CommandBehavior behavior) [0x0000c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at Marr.Data.QGen.UpdateQueryBuilder1[T].Execute () [0x0003b] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\QGen\UpdateQueryBuilder.cs:157 at Marr.Data.DataMapper.Update[T] (T entity, System.Linq.Expressions.Expression1[TDelegate] filter) [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\DataMapper.cs:674
at NzbDrone.Core.Datastore.BasicRepository1[TModel].UpdateMany (System.Collections.Generic.IList1[T] models) [0x00055] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\Datastore\BasicRepository.cs:167
at NzbDrone.Core.Qualities.QualityDefinitionService.InsertMissingDefinitions () [0x000c6] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:84
at NzbDrone.Core.Qualities.QualityDefinitionService.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00010] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:101
at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x00117] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:96

19-1-1 10:35:25.6|Error|NzbDroneErrorPipeline|[GET /api/series]

[v2.0.0.5252] System.Data.SQLite.SQLiteException (0x80004005): database or disk is full
database or disk is full
at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00083] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0003c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0016b] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x00090] in <61a20cde294d4a3eb43b9d9f6284613b>: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 (System.Data.CommandBehavior behavior) [0x0000c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.Common.DbCommand.ExecuteReader () [0x00000] in :0
at (wrapper remoting-invoke-with-check) System.Data.Common.DbCommand.ExecuteReader()
at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection1[T] entityList, System.Boolean useAltName) [0x0006b] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\DataMapper.cs:567 at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection1[T] entityList) [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\DataMapper.cs:546
at Marr.Data.DataMapper.Query[T] (System.String sql) [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\DataMapper.cs:537
at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics () [0x00053] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\SeriesStats\SeriesStatisticsRepository.cs:35
at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics () [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\SeriesStats\SeriesStatisticsService.cs:23
at NzbDrone.Api.Series.SeriesModule.AllSeries () [0x0001d] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Series\SeriesModule.cs:99
at NzbDrone.Api.REST.RestModule1[TResource].<set_GetResourceAll>b__32_0 (System.Object options) [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\REST\RestModule.cs:111 at (wrapper dynamic-method) System.Object.CallSite.Target(System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func2<object, object>,object)
at Nancy.Routing.Route+<>c__DisplayClass4.b__3 (System.Object parameters, System.Threading.CancellationToken context) [0x00049] in <63c44d6f8d7e4f339a987bf9eb94d931>:0

19-1-1 10:35:25.7|Fatal|NzbDroneErrorPipeline|Request Failed. GET /api/series

[v2.0.0.5252] System.Data.SQLite.SQLiteException (0x80004005): database or disk is full
database or disk is full
at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00083] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0003c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0016b] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x00090] in <61a20cde294d4a3eb43b9d9f6284613b>: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 (System.Data.CommandBehavior behavior) [0x0000c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.Common.DbCommand.ExecuteReader () [0x00000] in :0
at (wrapper remoting-invoke-with-check) System.Data.Common.DbCommand.ExecuteReader()
at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection1[T] entityList, System.Boolean useAltName) [0x0006b] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\DataMapper.cs:567 at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection1[T] entityList) [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\DataMapper.cs:546
at Marr.Data.DataMapper.Query[T] (System.String sql) [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\Marr.Data\DataMapper.cs:537
at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics () [0x00053] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\SeriesStats\SeriesStatisticsRepository.cs:35
at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics () [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Core\SeriesStats\SeriesStatisticsService.cs:23
at NzbDrone.Api.Series.SeriesModule.AllSeries () [0x0001d] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Series\SeriesModule.cs:99
at NzbDrone.Api.REST.RestModule1[TResource].<set_GetResourceAll>b__32_0 (System.Object options) [0x00000] in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\REST\RestModule.cs:111 at (wrapper dynamic-method) System.Object.CallSite.Target(System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func2<object, object>,object)
at Nancy.Routing.Route+<>c__DisplayClass4.b__3 (System.Object parameters, System.Threading.CancellationToken context) [0x00049] in <63c44d6f8d7e4f339a987bf9eb94d931>:0


#2

Do you have enough space? Does the user running sonarr have access to the database location?


#3

yes i have 8 tb and 6tb is still free, yes its got full access to everything, I thought the DB might be corrupt but i’ve done a complete fresh install re-added everything, but this morning i get the same error again db is full


#4

0x80004005 can also mean the file is locked by another process/locked by sql.

(actually, is that some kind of generic exception? radarr had a similar failure resulting in System.Data.SQLite.SQLiteException (0x80004005): constraint failed
UNIQUE constraint failed: Movies.TitleSlug, and other apps are similar but different error text)

i dont know debian but i presume theres a way to find out if the database file itself has been locked in some way by another process (maybe even something as simple as it being readonly for some weird reason)

you could also try using a different /config folder, see if that lets you in


#5

Ok ty will give it a go


#6

Turns out the servers SQL is overloaded with requests so i have to wait for it to give me access, sucks but nothing i can do about that