Sonarr GUI unresponsive on OSX

Help & Support
#1

Hi all,

since a few days i can’t seem to access the Sonarr GUI anymore, it just hangs on the “floating balls”. It runs on a Mac-mini with the Sonarr.app and has done so flawlessly for a long time. Reboot of the mac or killing the app by CLI doesn’t fix the problem. It seems to be still downloading series in te background…
The sonarr logs show the following messages when i try to access the GUI:

18-6-11 15:31:46.2|Fatal|NzbDroneErrorPipeline|Request Failed. GET /api/series

[v2.0.0.5163] Marr.Data.DataMappingException: The DataMapper was unable to load the following field: ‘Ratings’ value: ‘3Z",
“trigger”: “scheduled”
}�’. Unexpected character encountered while parsing number: Z. Path ‘’, line 1, position 1. —> Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing number: Z. Path ‘’, line 1, position 1.
at Newtonsoft.Json.JsonTextReader.ReadNumberIntoBuffer () [0x00000] in :0
at Newtonsoft.Json.JsonTextReader.ParseNumber (ReadType readType) [0x00000] in :0
at Newtonsoft.Json.JsonTextReader.ParseValue () [0x00000] in :0
at Newtonsoft.Json.JsonTextReader.Read () [0x00000] in :0
at Newtonsoft.Json.JsonReader.ReadAndMoveToContent () [0x00000] in :0
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType (Newtonsoft.Json.JsonReader reader, Newtonsoft.Json.Serialization.JsonContract contract, Boolean hasConverter) [0x00000] in :0
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize (Newtonsoft.Json.JsonReader reader, System.Type objectType, Boolean checkAdditionalContent) [0x00000] in :0
— End of inner exception stack trace —
at Marr.Data.Mapping.MappingHelper.LoadExistingEntity (Marr.Data.Mapping.ColumnMapCollection,System.Data.Common.DbDataReader,object,bool) [0x000a8] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\Mapping\MappingHelper.cs:79
at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity (System.Type,Marr.Data.Mapping.ColumnMapCollection,System.Data.Common.DbDataReader,bool) [0x00012] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\Mapping\MappingHelper.cs:40
at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity<NzbDrone.Core.Tv.Series> (Marr.Data.Mapping.ColumnMapCollection,System.Data.Common.DbDataReader,bool) <0x0003b>
at Marr.Data.DataMapper.Query<NzbDrone.Core.Tv.Series> (string,System.Collections.Generic.ICollection1<NzbDrone.Core.Tv.Series>,bool) <0x00183> at Marr.Data.QGen.QueryBuilder1<NzbDrone.Core.Tv.Series>.ToList () <0x00163>
at NzbDrone.Core.Datastore.BasicRepository1<NzbDrone.Core.Tv.Series>.All () <0x0004b> at NzbDrone.Core.Tv.SeriesService.GetAllSeries () [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Core\Tv\SeriesService.cs:141 at NzbDrone.Api.Series.SeriesModule.AllSeries () [0x00029] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Api\Series\SeriesModule.cs:100 at NzbDrone.Api.REST.RestModule1<NzbDrone.Api.Series.SeriesResource>.<set_GetResourceAll>b__32_0 (object) <0x0001c>
at (wrapper dynamic-method) object.CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func`2<object, object>,object) <IL 0x00038, 0x00086>
at Nancy.Routing.Route/<>c__DisplayClass4.b__3 (object,System.Threading.CancellationToken) <IL 0x0005f, 0x0013b>

18-6-11 15:32:08.7|Fatal|NzbDroneErrorPipeline|Request Failed. GET /api/series

[v2.0.0.5163] Marr.Data.DataMappingException: The DataMapper was unable to load the following field: ‘Ratings’ value: ‘3Z",
“trigger”: “scheduled”
}�’. Unexpected character encountered while parsing number: Z. Path ‘’, line 1, position 1. —> Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing number: Z. Path ‘’, line 1, position 1.
at Newtonsoft.Json.JsonTextReader.ReadNumberIntoBuffer () [0x00000] in :0
at Newtonsoft.Json.JsonTextReader.ParseNumber (ReadType readType) [0x00000] in :0
at Newtonsoft.Json.JsonTextReader.ParseValue () [0x00000] in :0
at Newtonsoft.Json.JsonTextReader.Read () [0x00000] in :0
at Newtonsoft.Json.JsonReader.ReadAndMoveToContent () [0x00000] in :0
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType (Newtonsoft.Json.JsonReader reader, Newtonsoft.Json.Serialization.JsonContract contract, Boolean hasConverter) [0x00000] in :0
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize (Newtonsoft.Json.JsonReader reader, System.Type objectType, Boolean checkAdditionalContent) [0x00000] in :0
— End of inner exception stack trace —
at Marr.Data.Mapping.MappingHelper.LoadExistingEntity (Marr.Data.Mapping.ColumnMapCollection,System.Data.Common.DbDataReader,object,bool) [0x000a8] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\Mapping\MappingHelper.cs:79
at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity (System.Type,Marr.Data.Mapping.ColumnMapCollection,System.Data.Common.DbDataReader,bool) [0x00012] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\Mapping\MappingHelper.cs:40
at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity<NzbDrone.Core.Tv.Series> (Marr.Data.Mapping.ColumnMapCollection,System.Data.Common.DbDataReader,bool) <0x0003b>
at Marr.Data.DataMapper.Query<NzbDrone.Core.Tv.Series> (string,System.Collections.Generic.ICollection1<NzbDrone.Core.Tv.Series>,bool) <0x00183> at Marr.Data.QGen.QueryBuilder1<NzbDrone.Core.Tv.Series>.ToList () <0x00163>
at NzbDrone.Core.Datastore.BasicRepository1<NzbDrone.Core.Tv.Series>.All () <0x0004b> at NzbDrone.Core.Tv.SeriesService.GetAllSeries () [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Core\Tv\SeriesService.cs:141 at NzbDrone.Api.Series.SeriesModule.AllSeries () [0x00029] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Api\Series\SeriesModule.cs:100 at NzbDrone.Api.REST.RestModule1<NzbDrone.Api.Series.SeriesResource>.<set_GetResourceAll>b__32_0 (object) <0x0001c>
at (wrapper dynamic-method) object.CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func`2<object, object>,object) <IL 0x00038, 0x00086>
at Nancy.Routing.Route/<>c__DisplayClass4.b__3 (object,System.Threading.CancellationToken) <IL 0x0005f, 0x0013b>

Sonarr version (exact version): V2
Mono version (if Sonarr is not running on Windows): Version 4.0.4
OS: OSX High Sierra 10.13

#2

updated Mono to version 5.12.0 (latest stable) but makes no difference by the way… :neutral_face:

#3

Your DB is corrupt, the easiest solution is to restore a backup. Alternatively you could use a SQLite tool to update the DB and fix the offending records. UPDATE Series SET Ratings = '{}' would reset them all and running a series refresh after you’re up and running will get the latest data.

#5

Thanks!..i’ll try it and let you know if that fixes it :+1:

@markus101 , Thanks!! That did it!!
last backup was “corrupt” too so i had to take a backup from the week before, but it’s working again.
Good stuff!!! :grinning:

#6

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