API tools faq
paste
xartin

radarr-v5-prerelease v4 sqlite database upgrade

xartin
Dec 30th, 2023
43
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.17 KB | None | 0 0
raw download clone embed print report
  1. radarr-v5-prerelease v4 sqlite database upgrade query error
  2.  
  3. Dec 30 00:35:11 fenrir Radarr[4381]: SQLite error (1): no such column: Movies.SortTitle in "SELECT "History".*, "Movies".*, "QualityProfiles".*
  4. FROM "History"
  5. JOIN "Movies" ON ("History"."MovieId" = "Movies"."Id")
  6. JOIN "QualityProfiles" ON ("Movies"."QualityProf
  7. Dec 30 00:35:11 fenrir Radarr[4381]: [Error] RadarrErrorPipeline: [GET /api/v3/history]
  8. Dec 30 00:35:11 fenrir Radarr[4381]: [v5.2.4.8328] code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
  9. Dec 30 00:35:11 fenrir Radarr[4381]: no such column: Movies.SortTitle
  10. Dec 30 00:35:11 fenrir Radarr[4381]: at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
  11. Dec 30 00:35:11 fenrir Radarr[4381]: at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
  12. Dec 30 00:35:11 fenrir Radarr[4381]: at System.Data.SQLite.SQLiteDataReader.NextResult()
  13. Dec 30 00:35:11 fenrir Radarr[4381]: at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
  14. Dec 30 00:35:11 fenrir Radarr[4381]: at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
  15. Dec 30 00:35:11 fenrir Radarr[4381]: at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1142
  16. Dec 30 00:35:11 fenrir Radarr[4381]: at Dapper.SqlMapper.MultiMapImpl[TFirst,TSecond,TThird,TFourth,TFifth,TSixth,TSeventh,TReturn](IDbConnection cnn, CommandDefinition command, Delegate map, String splitOn, DbDataReader reader, Identity identity, Boolean finalize)+MoveNext() in /_/Dapper/SqlMapper.cs:line 1537
  17. Dec 30 00:35:11 fenrir Radarr[4381]: at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
  18. Dec 30 00:35:11 fenrir Radarr[4381]: at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  19. Dec 30 00:35:11 fenrir Radarr[4381]: at Dapper.SqlMapper.MultiMap[TFirst,TSecond,TThird,TFourth,TFifth,TSixth,TSeventh,TReturn](IDbConnection cnn, String sql, Delegate map, Object param, IDbTransaction transaction, Boolean buffered, String splitOn, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 1518
  20. Dec 30 00:35:11 fenrir Radarr[4381]: at NzbDrone.Core.Datastore.SqlMapperExtensions.Query[TFirst,TSecond,TThird,TReturn](IDatabase db, String sql, Func`4 map, Object param, IDbTransaction transaction, Boolean buffered, String splitOn, Nullable`1 commandTimeout, Nullable`1 commandType) in ./Radarr.Core/Datastore/Extensions/SqlMapperExtensions.cs:line 82
  21. Dec 30 00:35:11 fenrir Radarr[4381]: at NzbDrone.Core.Datastore.SqlMapperExtensions.QueryJoined[T,T2,T3](IDatabase db, SqlBuilder builder, Func`4 mapper) in ./Radarr.Core/Datastore/Extensions/SqlMapperExtensions.cs:line 164
  22. Dec 30 00:35:11 fenrir Radarr[4381]: at NzbDrone.Core.Datastore.BasicRepository`1.GetPagedRecords(SqlBuilder builder, PagingSpec`1 pagingSpec, Func`2 queryFunc) in ./Radarr.Core/Datastore/BasicRepository.cs:line 434
  23. Dec 30 00:35:11 fenrir Radarr[4381]: at NzbDrone.Core.History.HistoryRepository.GetPaged(PagingSpec`1 pagingSpec, Int32[] languages, Int32[] qualities) in ./Radarr.Core/History/HistoryRepository.cs:line 100
  24. Dec 30 00:35:11 fenrir Radarr[4381]: at NzbDrone.Core.History.HistoryService.Paged(PagingSpec`1 pagingSpec, Int32[] languages, Int32[] qualities) in ./Radarr.Core/History/HistoryService.cs:line 54
  25. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Api.V3.History.HistoryController.<>c__DisplayClass7_0.<GetHistory>b__2(PagingSpec`1 h) in ./Radarr.Api.V3/History/HistoryController.cs:line 85
  26. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Http.Extensions.RequestExtensions.ApplyToPage[TResource,TModel](PagingSpec`1 pagingSpec, Func`2 function, Converter`2 mapper) in ./Radarr.Http/Extensions/RequestExtensions.cs:line 56
  27. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Api.V3.History.HistoryController.GetHistory(PagingRequestResource paging, Boolean includeMovie, Nullable`1 eventType, String downloadId, Int32[] movieIds, Int32[] languages, Int32[] quality) in ./Radarr.Api.V3/History/HistoryController.cs:line 85
  28. Dec 30 00:35:11 fenrir Radarr[4381]: at lambda_method489(Closure , Object , Object[] )
  29. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
  30. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
  31. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
  32. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
  33. Dec 30 00:35:11 fenrir Radarr[4381]: --- End of stack trace from previous location ---
  34. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
  35. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
  36. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
  37. Dec 30 00:35:11 fenrir Radarr[4381]: --- End of stack trace from previous location ---
  38. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
  39. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
  40. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
  41. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
  42. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Http.Middleware.BufferingMiddleware.InvokeAsync(HttpContext context) in ./Radarr.Http/Middleware/BufferingMiddleware.cs:line 28
  43. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Http.Middleware.IfModifiedMiddleware.InvokeAsync(HttpContext context) in ./Radarr.Http/Middleware/IfModifiedMiddleware.cs:line 41
  44. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Http.Middleware.CacheHeaderMiddleware.InvokeAsync(HttpContext context) in ./Radarr.Http/Middleware/CacheHeaderMiddleware.cs:line 33
  45. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Http.Middleware.StartingUpMiddleware.InvokeAsync(HttpContext context) in ./Radarr.Http/Middleware/StartingUpMiddleware.cs:line 38
  46. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Http.Middleware.UrlBaseMiddleware.InvokeAsync(HttpContext context) in ./Radarr.Http/Middleware/UrlBaseMiddleware.cs:line 27
  47. Dec 30 00:35:11 fenrir Radarr[4381]: at Radarr.Http.Middleware.VersionMiddleware.InvokeAsync(HttpContext context) in ./Radarr.Http/Middleware/VersionMiddleware.cs:line 29
  48. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.InvokeCore(HttpContext context)
  49. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult)
  50. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
  51. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
  52. Dec 30 00:35:11 fenrir Radarr[4381]: at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
  53. Dec 30 00:35:11 fenrir Radarr[4381]: SQL:
  54. Dec 30 00:35:11 fenrir Radarr[4381]: ==== Begin Query Trace ====
  55. Dec 30 00:35:11 fenrir Radarr[4381]: QUERY TEXT:
  56. Dec 30 00:35:11 fenrir Radarr[4381]: SELECT "History".*, "Movies".*, "QualityProfiles".*
  57. Dec 30 00:35:11 fenrir Radarr[4381]: FROM "History"
  58. Dec 30 00:35:11 fenrir Radarr[4381]: JOIN "Movies" ON ("History"."MovieId" = "Movies"."Id")
  59. Dec 30 00:35:11 fenrir Radarr[4381]: JOIN "QualityProfiles" ON ("Movies"."QualityProfileId" = "QualityProfiles"."Id")
  60. Dec 30 00:35:11 fenrir Radarr[4381]:
  61. Dec 30 00:35:11 fenrir Radarr[4381]: LEFT JOIN "MovieMetadata" ON ("Movies"."MovieMetadataId" = "MovieMetadata"."Id")
  62. Dec 30 00:35:11 fenrir Radarr[4381]: ORDER BY "Movies"."SortTitle" DESC LIMIT 20 OFFSET 0
  63. Dec 30 00:35:11 fenrir Radarr[4381]: PARAMETERS:
  64. Dec 30 00:35:11 fenrir Radarr[4381]: ==== End Query Trace ====
  65.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!