Error occurred while executing task EpisodeSearch

v3 Testing
#1

Sonarr version (3.0.3.713):
Mono version (5.20.1.34):
OS (3.0.3.713-ls180 by linuxserver.io --> Docker Container on Unraid 6.8.2:
Debug logs:
(https://pastebin.com/Nd0PiL5R)
Description of issue:

Any kind of search end in “Failed” : I simply go in any show, clic on the search icon beside a missing episode, get this error every time. And Can understand much of it, but the 1st failing element always seems to be

( unable to load the following field: 'LastRssSyncReleaseInfo' value: '{ "magnetUrl": "", "infoHash": "", "seeders": 316, "peers": 316, "guid": "https://isohunt2.net/torrent_details/t3-4323570/Altered-Carbon-S02-COMPLETE-720p-NF-WEBRip-x264-GalaxyTV" )

why is an “altered Carbon” result always in an unrelated search ? I even tried disabling Isohunt2, still the same.

Here is the message andException from the event :

Error occurred while executing task EpisodeSearch: The DataMapper was unable to load the following field: 'LastRssSyncReleaseInfo' value: '{
  "magnetUrl": "",
  "infoHash": "",
  "seeders": 316,
  "peers": 316,
  "guid": "https://isohunt2.net/torrent_details/t3-4323570/Altered-Carbon-S02-COMPLETE-720p-NF-WEBRip-x264-GalaxyTV",
  "title": "Altered.Carbon.S02.COMPLETE.720p.NF.WEBRip.x2�B����S
?�CCC-ProcessMonitoredDownloads{
  "requiresDiskAccess": true,
  "sendUpdatesToClient": false,
  "updateScheduledTask": true,
  "completionMessage": "Completed",
  "isExclusive": false,
  "name": "ProcessMonitoredDownloads",
  "trigger": "unspecified",
  "suppressMessages": false
}2020-02-27 21:30:04.001686Z2020-02-27 21:30:04.010234Z2020-02-27 21:30:04.017626Z00:00:00.0073920�9��R
?�mACC-RefreshMonitoredDownloads{
  "sendUpdatesToClient": false,
  "updateScheduledTask": true,
  "completionMessage": "Completed",
  "requiresDiskAccess": false,
  "isExclusive": false,
  "name": "RefreshMonitoredDownloads",
  "lastExecutionTime": "2020-02-27T21:25:16.218334Z",
  "trigger": "scheduled",
  "suppressMessages": false
}�2020-02-27 21:30:03.76762Z2020-02-27 21:30:03.773147Z2020-02-27 21:30:04.005543Z00:00:00.2323960'. After parsing a value an unexpected character was encountered: r. Path 'title', line 9, position 3.

------------------------------------------------------------------------------------------------------------------------------

  Marr.Data.DataMappingException: The DataMapper was unable to load the following field: 'LastRssSyncReleaseInfo' value: '{
  "magnetUrl": "",
  "infoHash": "",
  "seeders": 316,
  "peers": 316,
  "guid": "https://isohunt2.net/torrent_details/t3-4323570/Altered-Carbon-S02-COMPLETE-720p-NF-WEBRip-x264-GalaxyTV",
  "title": "Altered.Carbon.S02.COMPLETE.720p.NF.WEBRip.x2�B����S
?�CCC-ProcessMonitoredDownloads{
  "requiresDiskAccess": true,
  "sendUpdatesToClient": false,
  "updateScheduledTask": true,
  "completionMessage": "Completed",
  "isExclusive": false,
  "name": "ProcessMonitoredDownloads",
  "trigger": "unspecified",
  "suppressMessages": false
}2020-02-27 21:30:04.001686Z2020-02-27 21:30:04.010234Z2020-02-27 21:30:04.017626Z00:00:00.0073920�9��R
?�mACC-RefreshMonitoredDownloads{
  "sendUpdatesToClient": false,
  "updateScheduledTask": true,
  "completionMessage": "Completed",
  "requiresDiskAccess": false,
  "isExclusive": false,
  "name": "RefreshMonitoredDownloads",
  "lastExecutionTime": "2020-02-27T21:25:16.218334Z",
  "trigger": "scheduled",
  "suppressMessages": false
}�2020-02-27 21:30:03.76762Z2020-02-27 21:30:03.773147Z2020-02-27 21:30:04.005543Z00:00:00.2323960'. After parsing a value an unexpected character was encountered: r. Path 'title', line 9, position 3. ---> Newtonsoft.Json.JsonReaderException: After parsing a value an unexpected character was encountered: r. Path 'title', line 9, position 3.
  at Newtonsoft.Json.JsonTextReader.ParsePostValue (System.Boolean ignoreComments) [0x0019a] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.JsonTextReader.Read () [0x0005a] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject (System.Object newObject, Newtonsoft.Json.JsonReader reader, Newtonsoft.Json.Serialization.JsonObjectContract contract, Newtonsoft.Json.Serialization.JsonProperty member, System.String id) [0x002a7] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject (Newtonsoft.Json.JsonReader reader, System.Type objectType, Newtonsoft.Json.Serialization.JsonContract contract, Newtonsoft.Json.Serialization.JsonProperty member, Newtonsoft.Json.Serialization.JsonContainerContract containerContract, Newtonsoft.Json.Serialization.JsonProperty containerMember, System.Object existingValue) [0x00161] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal (Newtonsoft.Json.JsonReader reader, System.Type objectType, Newtonsoft.Json.Serialization.JsonContract contract, Newtonsoft.Json.Serialization.JsonProperty member, Newtonsoft.Json.Serialization.JsonContainerContract containerContract, Newtonsoft.Json.Serialization.JsonProperty containerMember, System.Object existingValue) [0x0006d] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize (Newtonsoft.Json.JsonReader reader, System.Type objectType, System.Boolean checkAdditionalContent) [0x000db] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.JsonSerializer.DeserializeInternal (Newtonsoft.Json.JsonReader reader, System.Type objectType) [0x00054] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.JsonSerializer.Deserialize (Newtonsoft.Json.JsonReader reader, System.Type objectType) [0x00000] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at Newtonsoft.Json.JsonConvert.DeserializeObject (System.String value, System.Type type, Newtonsoft.Json.JsonSerializerSettings settings) [0x0002d] in <d47de75a7e3f422ca4ca64a654c80495>:0 
  at NzbDrone.Core.Datastore.Converters.EmbeddedDocumentConverter.FromDB (Marr.Data.Converters.ConverterContext context) [0x00029] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\Converters\EmbeddedDocumentConverter.cs:47 
  at Marr.Data.Mapping.MappingHelper.LoadExistingEntity (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Object ent, System.Boolean useAltName) [0x00061] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\Mapping\MappingHelper.cs:66 
   --- End of inner exception stack trace ---
  at Marr.Data.Mapping.MappingHelper.LoadExistingEntity (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Object ent, System.Boolean useAltName) [0x000aa] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\Mapping\MappingHelper.cs:79 
  at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity (System.Type entityType, Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Boolean useAltName) [0x00012] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\Mapping\MappingHelper.cs:40 
  at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity[T] (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Boolean useAltName) [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\Mapping\MappingHelper.cs:25 
  at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection`1[T] entityList, System.Boolean useAltName) [0x0008d] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:577 
  at Marr.Data.QGen.QueryBuilder`1[T].ToList () [0x00052] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\QueryBuilder.cs:279 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].All () [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:61 
  at NzbDrone.Core.ThingiProvider.Status.ProviderStatusServiceBase`2[TProvider,TModel].GetBlockedProviders () [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\ThingiProvider\Status\ProviderStatusServiceBase.cs:45 
  at NzbDrone.Core.Indexers.IndexerFactory+<FilterBlockedIndexers>d__8.MoveNext () [0x00026] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Indexers\IndexerFactory.cs:87 
  at System.Collections.Generic.List`1[T].AddEnumerable (System.Collections.Generic.IEnumerable`1[T] enumerable) [0x00059] in <254335e8c4aa42e3923a8ba0d5ce8650>:0 
  at System.Collections.Generic.List`1[T]..ctor (System.Collections.Generic.IEnumerable`1[T] collection) [0x00062] in <254335e8c4aa42e3923a8ba0d5ce8650>:0 
  at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable`1[T] source) [0x00018] in <798dd06330af4ca3886d7d2be5573af7>:0 
  at NzbDrone.Core.Indexers.IndexerFactory.AutomaticSearchEnabled (System.Boolean filterBlockedIndexers) [0x0002e] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Indexers\IndexerFactory.cs:67 
  at NzbDrone.Core.IndexerSearch.NzbSearchService.Dispatch (System.Func`2[T,TResult] searchAction, NzbDrone.Core.IndexerSearch.Definitions.SearchCriteriaBase criteriaBase) [0x0001b] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\IndexerSearch\NzbSearchService.cs:290 
  at NzbDrone.Core.IndexerSearch.NzbSearchService.SearchSingle (NzbDrone.Core.Tv.Series series, NzbDrone.Core.Tv.Episode episode, System.Boolean userInvokedSearch, System.Boolean interactiveSearch) [0x000a0] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\IndexerSearch\NzbSearchService.cs:184 
  at NzbDrone.Core.IndexerSearch.NzbSearchService.EpisodeSearch (NzbDrone.Core.Tv.Episode episode, System.Boolean userInvokedSearch, System.Boolean interactiveSearch) [0x00081] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\IndexerSearch\NzbSearchService.cs:83 
  at NzbDrone.Core.IndexerSearch.NzbSearchService.EpisodeSearch (System.Int32 episodeId, System.Boolean userInvokedSearch, System.Boolean interactiveSearch) [0x0000d] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\IndexerSearch\NzbSearchService.cs:55 
  at NzbDrone.Core.IndexerSearch.EpisodeSearchService.Execute (NzbDrone.Core.IndexerSearch.EpisodeSearchCommand message) [0x00016] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\IndexerSearch\EpisodeSearchService.cs:93 
  at NzbDrone.Core.Messaging.Commands.CommandExecutor.ExecuteCommand[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandModel commandModel) [0x000f6] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandExecutor.cs:95 
  at (wrapper dynamic-method) System.Object.CallSite.Target(System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandExecutor,object,NzbDrone.Core.Messaging.Commands.CommandModel)
  at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid3[T0,T1,T2] (System.Runtime.CompilerServices.CallSite site, T0 arg0, T1 arg1, T2 arg2) [0x0011e] in <798dd06330af4ca3886d7d2be5573af7>:0 
  at (wrapper dynamic-method) System.Object.CallSite.Target(System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandExecutor,object,NzbDrone.Core.Messaging.Commands.CommandModel)
  at NzbDrone.Core.Messaging.Commands.CommandExecutor.ExecuteCommands () [0x00027] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandExecutor.cs:41
#2

Because it’s the last item stored for that indexer.

Your DB is corrupt. You’ll either need to restore from backup or fix the affected record in the (SQLite) DB directly.

UPDATE IndexerStatus SET LastRssSyncReleaseInfo = '{}' would do it.

#3

Hi @markus101, where do I execute that command ? And would that command fix everything or I still need to restore / fix the record ?

#4

In your SQLite tool of choice, with the Sonarr DB opened.

That will fix those records, if there are others you’ll need to fix them as well, but you won’t know about other issues until you fix them.

#5

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