alternatrr icon indicating copy to clipboard operation
alternatrr copied to clipboard

Published 20 hours ago • verified publisher icon TheUltimateC0der

Docker Error. An error occurred while processing your request.

Open CyronixJW opened this issue 1 year ago • 13 comments

Hi i would like to know how to fix this error Error. An error occurred while processing your request. Request ID: 00-7dd6580d4cfb4b45aa29486c180d6405-a63159500c753f42-00 I think this is related to the sonarr db. My sonarr is installed natively on my windows pc docker is on a wsl ubuntu distro where i set the path of the db thru /mnt/c/programdata/sonarr

CyronixJW avatar Jun 08 '23 15:06 CyronixJW

A little bit late, but did you actually use the github-package as the docker image or the one from dockerhub? The one in dockerhub didn't receive the latest updates for sonarr v4, which caused the same error for me.

Using ghcr.io/theultimatec0der/alternatrr:latest as the image did it's job.

Pheromir avatar Jul 12 '23 20:07 Pheromir

I'm having this same error and I used ghcr.io/theultimatec0der/alternatrr:latest.

mobamoba avatar Jul 14 '23 20:07 mobamoba

I can't do anything with that request ID

I need either an explanation what you did to reproduce it, or the full error message from docker logs or portainer

TheUltimateC0der avatar Jul 14 '23 20:07 TheUltimateC0der

My logs are filled with this. And it's what occurs the moment I login to Alternatrr:

fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[1] An unhandled exception has occurred while executing the request. Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken) at alternatrr.Controllers.HomeController.Index() in /src/alternatrr/Controllers/HomeController.cs:line 29 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 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.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|8_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task) info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] Executing endpoint 'alternatrr.Controllers.HomeController.Error (alternatrr)' info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102] Route matched with {action = "Error", controller = "Home", page = "", area = ""}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Error() on controller alternatrr.Controllers.HomeController (alternatrr). info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1] Executing ViewResult, running view Error. info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[4] Executed ViewResult - view Error executed in 3.7396ms. info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105] Executed action alternatrr.Controllers.HomeController.Error (alternatrr) in 4.4558ms info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed endpoint 'alternatrr.Controllers.HomeController.Error (alternatrr)' info: Microsoft.AspNetCore.Hosting.Diagnostics[2]

mobamoba avatar Jul 14 '23 20:07 mobamoba

Are you using V4 ?

TheUltimateC0der avatar Jul 14 '23 21:07 TheUltimateC0der

No I'm on Sonarr 3.

mobamoba avatar Jul 14 '23 21:07 mobamoba

Hello,

I'm having the same issue. Error detailed in development mode:

A database operation failed while processing the request. SqliteException: SQLite Error 1: 'no such table: Series'

Idem with both images: image: theultimatecoder/alternatrr:latest image: ghcr.io/theultimatec0der/alternatrr:latest

Sonarr version: 4.0.0.657

Thanks in advance.

raphtabe avatar Sep 05 '23 21:09 raphtabe

A bit of context:

My docker compose:

My setting: I run sonarr & alternatrr on a sinology nas. sonarr is installed from the package center alternatrr is installed with docker

version: '3'
services:
  alternatrr:
    image: ghcr.io/theultimatec0der/alternatrr:latest
    environment:
    - ConnectionStrings__DefaultConnection=Data Source=/opt/alternatrr/app/alternatrr.db
    - ConnectionStrings__sonarr=Data Source=/opt/sonarr/app/sonarr.db
    - Login__Username=**********
    - Login__Password=***********
    volumes:
    - /volume1/@appdata/sonarr/.config/Sonarr:/opt/sonarr/app  #Mounting the directory with sonarr.db in it
    - /volume1/docker/alternatrr/app:/opt/alternatrr/app #Mounting the alternatrr.db peristent login

Here is the logs:

Request finished HTTP/1.1 GET http://192.168.0.10:8004/ - - - 500 - text/html;+charset=utf-8 19.1428ms info: Microsoft.AspNetCore.Hosting.Diagnostics[2] Executed endpoint 'alternatrr.Controllers.HomeController.Error (alternatrr)' info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed action alternatrr.Controllers.HomeController.Error (alternatrr) in 1.9001ms info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105] Executed ViewResult - view Error executed in 1.7406ms. info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[4] Executing ViewResult, running view Error. info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1] Route matched with {action = "Error", controller = "Home", page = "", area = ""}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Error() on controller alternatrr.Controllers.HomeController (alternatrr). info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102] Executing endpoint 'alternatrr.Controllers.HomeController.Error (alternatrr)' info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|8_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at alternatrr.Controllers.HomeController.Index() in /src/alternatrr/Controllers/HomeController.cs:line 29 at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsyncTSource at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'. An unhandled exception has occurred while executing the request. fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[1] Executed endpoint 'alternatrr.Controllers.HomeController.Index (alternatrr)' info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed action alternatrr.Controllers.HomeController.Index (alternatrr) in 3.1981ms info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105] at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'. An exception occurred while iterating over the results of a query for context type 'alternatrr.SonarrDbContext'. fail: Microsoft.EntityFrameworkCore.Query[10100] FROM "Series" AS "s" SELECT "s"."Id", "s"."Actors", "s"."AddOptions", "s"."Added", "s"."AirTime", "s"."Certification", "s"."CleanTitle", "s"."FirstAired", "s"."Genres", "s"."Images", "s"."ImdbId", "s"."LastDiskSync", "s"."LastInfoSync", "s"."Monitored", "s"."Network", "s"."NextAiring", "s"."Overview", "s"."Path", "s"."QualityProfileId", "s"."Ratings", "s"."Runtime", "s"."SeasonFolder", "s"."Seasons", "s"."SeriesType", "s"."SortTitle", "s"."Status", "s"."Tags", "s"."Title", "s"."TitleSlug", "s"."TvMazeId", "s"."TvRageId", "s"."TvdbId", "s"."UseSceneNumbering", "s"."Year" Failed executing DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] fail: Microsoft.EntityFrameworkCore.Database.Command[20102] Route matched with {action = "Index", controller = "Home", page = "", area = ""}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Index() on controller alternatrr.Controllers.HomeController (alternatrr). info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102] Executing endpoint 'alternatrr.Controllers.HomeController.Index (alternatrr)' info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] Request starting HTTP/1.1 GET http://192.168.0.10:8004/ - - info: Microsoft.AspNetCore.Hosting.Diagnostics[1]

raphtabe avatar Sep 09 '23 08:09 raphtabe

Ok, solved 🙂 version: '4' instead of 3...

raphtabe avatar Sep 09 '23 09:09 raphtabe

Same issue here. I'm using Sonarr version 3.0.9.1549 and configuring alternatrr with the following docker compose:

# example docker-compose.yml

version: '3'
services:
  alternatrr:
    image: ghcr.io/theultimatec0der/alternatrr:latest
    environment:
    - TZ=Europe/Madrid
    - PGID=100
    - PUID=1000
    - ConnectionStrings__DefaultConnection=Data Source=/alternatrr/app/alternatrr.db
    - ConnectionStrings__sonarr=Data Source=/sonarr/sonarr.db
    - Login__Username=user
    - Login__Password=pass
    - ASPNETCORE_ENVIRONMENT=Development
    ports:
    - 5000:80
    volumes:
    - /volume1/data/config:/sonarr  #Mounting the directory with sonarr.db in it
    - /volume1/data/config/alternatrr:/alternatrr/app #Mounting the alternatrr.db peristent login

and I'm getting the following error: Screenshot 2023-12-04 at 16 20 36

in the log:

fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
      Failed executing DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT "s"."Id", "s"."Actors", "s"."AddOptions", "s"."Added", "s"."AirTime", "s"."Certification", "s"."CleanTitle", "s"."FirstAired", "s"."Genres", "s"."Images", "s"."ImdbId", "s"."LanguageProfileId", "s"."LastDiskSync", "s"."LastInfoSync", "s"."Monitored", "s"."Network", "s"."NextAiring", "s"."Overview", "s"."Path", "s"."QualityProfileId", "s"."Ratings", "s"."Runtime", "s"."SeasonFolder", "s"."Seasons", "s"."SeriesType", "s"."SortTitle", "s"."Status", "s"."Tags", "s"."Title", "s"."TitleSlug", "s"."TvMazeId", "s"."TvRageId", "s"."TvdbId", "s"."UseSceneNumbering", "s"."Year"
      FROM "Series" AS "s"
fail: Microsoft.EntityFrameworkCore.Query[10100]
      An exception occurred while iterating over the results of a query for context type 'alternatrr.SonarrDbContext'.
      Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'.
         at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
         at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
      Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'.
         at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
         at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()

Not sure what I am doing wrong 😅

miquelalvarado avatar Dec 04 '23 15:12 miquelalvarado

Ok, solved 🙂 version: '4' instead of 3...

Yep this is what worked for me with Synology and docker

harry71019 avatar Jan 21 '24 23:01 harry71019

Same issue here. I'm using Sonarr version 3.0.9.1549 and configuring alternatrr with the following docker compose:

# example docker-compose.yml

version: '3'
services:
  alternatrr:
    image: ghcr.io/theultimatec0der/alternatrr:latest
    environment:
    - TZ=Europe/Madrid
    - PGID=100
    - PUID=1000
    - ConnectionStrings__DefaultConnection=Data Source=/alternatrr/app/alternatrr.db
    - ConnectionStrings__sonarr=Data Source=/sonarr/sonarr.db
    - Login__Username=user
    - Login__Password=pass
    - ASPNETCORE_ENVIRONMENT=Development
    ports:
    - 5000:80
    volumes:
    - /volume1/data/config:/sonarr  #Mounting the directory with sonarr.db in it
    - /volume1/data/config/alternatrr:/alternatrr/app #Mounting the alternatrr.db peristent login

and I'm getting the following error: Screenshot 2023-12-04 at 16 20 36

in the log:

fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
      Failed executing DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT "s"."Id", "s"."Actors", "s"."AddOptions", "s"."Added", "s"."AirTime", "s"."Certification", "s"."CleanTitle", "s"."FirstAired", "s"."Genres", "s"."Images", "s"."ImdbId", "s"."LanguageProfileId", "s"."LastDiskSync", "s"."LastInfoSync", "s"."Monitored", "s"."Network", "s"."NextAiring", "s"."Overview", "s"."Path", "s"."QualityProfileId", "s"."Ratings", "s"."Runtime", "s"."SeasonFolder", "s"."Seasons", "s"."SeriesType", "s"."SortTitle", "s"."Status", "s"."Tags", "s"."Title", "s"."TitleSlug", "s"."TvMazeId", "s"."TvRageId", "s"."TvdbId", "s"."UseSceneNumbering", "s"."Year"
      FROM "Series" AS "s"
fail: Microsoft.EntityFrameworkCore.Query[10100]
      An exception occurred while iterating over the results of a query for context type 'alternatrr.SonarrDbContext'.
      Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'.
         at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
         at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
      Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Series'.
         at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
         at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
         at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()

Not sure what I am doing wrong 😅

how did you fix this ?

armdan avatar Mar 22 '24 05:03 armdan

So it works or not with Sonarr v4?!

adrianmihalko avatar Mar 26 '24 20:03 adrianmihalko