Failed to load Queue - Githubissues

Is there an existing issue for this?

[X] I have searched the existing open and closed issues

Current Behavior

When viewing activity, app shows "Failed to load Queue". Shows will not automatically import because the queue cannot be viewed. Checked download client, re-added it, no issues, Radarr works fine, same client, no issues.

Expected Behavior

In activity, Sonarr should show current queued items and when completed import and move to HDD location.

Steps To Reproduce

No response

Environment

- OS: macOS 14
- Sonarr: 4.0.4.1491
- Docker Install: NO
- Using Reverse Proxy: NO
- Browser: Chrome
- Database: Sqlite 3.36.0

What branch are you running?

Main

Trace Logs?

Events shows;

Request Failed. GET /api/v3/queue/status: Expected query to return 1 rows but returned 0

Exception: ystem.ApplicationException: Expected query to return 1 rows but returned 0 at NzbDrone.Core.Datastore.BasicRepository1.Get(IEnumerable1 ids) in ./Sonarr.Core/Datastore/BasicRepository.cs:line 121 at NzbDrone.Core.Tv.SeriesService.GetSeries(IEnumerable1 seriesIds) in ./Sonarr.Core/Tv/SeriesService.cs:line 63 at NzbDrone.Core.Download.Pending.PendingReleaseService.IncludeRemoteEpisodes(List1 releases, Dictionary`2 knownRemoteEpisodes) at NzbDrone.Core.Download.Pending.PendingReleaseService.GetPendingQueue() in ./Sonarr.Core/Download/Pending/PendingReleaseService.cs:line 183 at Sonarr.Api.V3.Queue.QueueStatusController.GetQueueStatus() in ./Sonarr.Api.V3/Queue/QueueStatusController.cs:line 48 at lambda_method77(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.gAwaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.gAwaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at Sonarr.Http.Middleware.BufferingMiddleware.InvokeAsync(HttpContext context) in ./Sonarr.Http/Middleware/BufferingMiddleware.cs:line 28 at Sonarr.Http.Middleware.IfModifiedMiddleware.InvokeAsync(HttpContext context) in ./Sonarr.Http/Middleware/IfModifiedMiddleware.cs:line 41 at Sonarr.Http.Middleware.CacheHeaderMiddleware.InvokeAsync(HttpContext context) in ./Sonarr.Http/Middleware/CacheHeaderMiddleware.cs:line 33 at Sonarr.Http.Middleware.StartingUpMiddleware.InvokeAsync(HttpContext context) in ./Sonarr.Http/Middleware/StartingUpMiddleware.cs:line 38 at Sonarr.Http.Middleware.UrlBaseMiddleware.InvokeAsync(HttpContext context) in ./Sonarr.Http/Middleware/UrlBaseMiddleware.cs:line 27 at Sonarr.Http.Middleware.VersionMiddleware.InvokeAsync(HttpContext context) in ./Sonarr.Http/Middleware/VersionMiddleware.cs:line 29 at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.InvokeCore(HttpContext context) at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)

Anything else?