Hi,
Has Maintenance Release 2.0.0.2106 (on Windows 7) broken nzbdrone for anyone else?
Since the update, my logs are full of “Request Failed: Expected query to return 2 rows but returned 1” errors, on the NzbDroneErrorPipeline, Scheduler, DownloadDecisionMaker and TaskExtension components, and probably others too further down the logs.
I restored the last backup from before the upgrade which allowed nzbdrone to work again, however I have ran in to the same problems after a reboot.
Cheers,
Ian
If it helps: I don’t see these issues (same version, running on synology w/ mono 3.6).
Ian, It’s likely not related to the torrents. please look in the log file to get a real stacktrace.
I’ve moved your posts to a separate topic.
@ianmcuk, I actually just saw this:
Same error.
Thanks @Taloth - I didn’t think it was specifically due to the Torrents functionality, however thought it was important to state I am on the Torrents branch.
The log file doesn’t reveal much more unfortunately, I’m wondering if anyone else knows how to solve this database problem on a more robust and permanent basis, rather than just restoring the last known good config and database backups.
4-10-14 15:41:01.2|Error|Scheduler|Error occurred while executing task NzbDrone.Core.Download.CheckForFinishedDownloadCommand
System.ApplicationException: Expected query to return 2 rows but returned 1
at NzbDrone.Core.Datastore.BasicRepository1.Get(IEnumerable1 ids) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Datastore\BasicRepository.cs:line 95
at NzbDrone.Core.Tv.EpisodeService.GetEpisodes(IEnumerable1 ids) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Tv\EpisodeService.cs:line 63 at NzbDrone.Core.Parser.ParsingService.Map(ParsedEpisodeInfo parsedEpisodeInfo, Int32 seriesId, IEnumerable1 episodeIds) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Parser\ParsingService.cs:line 124
at NzbDrone.Core.Download.DownloadTrackingService.GetTrackedDownload(String trackingId, Int32 downloadClient, DownloadClientItem downloadItem, List1 grabbedHistory) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 266 at NzbDrone.Core.Download.DownloadTrackingService.UpdateTrackedDownloads(List1 grabbedHistory) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 159
at NzbDrone.Core.Download.DownloadTrackingService.ProcessTrackedDownloads() in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 197
at NzbDrone.Core.Download.DownloadTrackingService.Execute(CheckForFinishedDownloadCommand message) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 276
at NzbDrone.Core.Messaging.Commands.CommandExecutor.ExecuteCommand[TCommand](Command command) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Messaging\Commands\CommandExecutor.cs:line 137
at NzbDrone.Core.Messaging.Commands.CommandExecutor.PublishCommand[TCommand](TCommand command) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Messaging\Commands\CommandExecutor.cs:line 48
at CallSite.Target(Closure , CallSite , CommandExecutor , Object )
at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid2[T0,T1](CallSite site, T0 arg0, T1 arg1)
at CallSite.Target(Closure , CallSite , CommandExecutor , Object )
at NzbDrone.Core.Messaging.Commands.CommandExecutor.PublishCommand(String commandTypeName, Nullable`1 lastExecutionTime) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Messaging\Commands\CommandExecutor.cs:line 61
at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands() in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Jobs\Scheduler.cs:line 46
14-10-14 15:41:30.6|Fatal|NzbDroneErrorPipeline|Request Failed
System.ApplicationException: Expected query to return 2 rows but returned 1
at NzbDrone.Core.Datastore.BasicRepository1.Get(IEnumerable1 ids) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Datastore\BasicRepository.cs:line 95
at NzbDrone.Core.Tv.EpisodeService.GetEpisodes(IEnumerable1 ids) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Tv\EpisodeService.cs:line 63 at NzbDrone.Core.Parser.ParsingService.Map(ParsedEpisodeInfo parsedEpisodeInfo, Int32 seriesId, IEnumerable1 episodeIds) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Parser\ParsingService.cs:line 124
at NzbDrone.Core.Download.DownloadTrackingService.GetTrackedDownload(String trackingId, Int32 downloadClient, DownloadClientItem downloadItem, List1 grabbedHistory) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 266 at NzbDrone.Core.Download.DownloadTrackingService.UpdateTrackedDownloads(List1 grabbedHistory) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 159
at NzbDrone.Core.Download.DownloadTrackingService.b__4() in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 83
at NzbDrone.Common.Cache.Cached1.Get(String key, Func1 function, Nullable1 lifeTime) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Common\Cache\Cached.cs:line 87 at NzbDrone.Core.Download.DownloadTrackingService.GetQueuedDownloads() in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Download\DownloadTrackingService.cs:line 81 at NzbDrone.Core.Queue.QueueService.GetQueue() in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Core\Queue\QueueService.cs:line 24 at NzbDrone.Api.Queue.QueueModule.GetQueueItems() in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Api\Queue\QueueModule.cs:line 32 at NzbDrone.Api.NzbDroneRestModule1.ToListResource[TModel](Func1 function) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Api\NzbDroneRestModule.cs:line 37 at NzbDrone.Api.Queue.QueueModule.GetQueue() in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Api\Queue\QueueModule.cs:line 27 at NzbDrone.Api.REST.RestModule1.<set_GetResourceAll>b__c(Object options) in m:\BuildAgent2\work\328d72309b633a8\src\NzbDrone.Api\REST\RestModule.cs:line 111
at CallSite.Target(Closure , CallSite , Func`2 , Object )
at Nancy.Routing.Route.<>c__DisplayClass4.b__3(Object parameters, CancellationToken context)
I could see it happening if the series is refreshed an one of the episode ID changes, but thats going to be pretty rare. Could someone pastebin some trace log files, knowing the series might help track it down.
Does the issue persist on a restart of drone?