Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Stuck at login page #2507

Closed
Izaya21 opened this issue Mar 13, 2021 · 16 comments
Closed

Stuck at login page #2507

Izaya21 opened this issue Mar 13, 2021 · 16 comments
Labels
bug Something isn't working

Comments

@Izaya21
Copy link

Izaya21 commented Mar 13, 2021

Describe The Bug
Jellyfin stuck at the login screen when trying to log in.
The loading wheel spins endlessly.
When the login page stuck, going to the base url takes you to the logged in area.

Steps To Reproduce

  1. Login to Your account
  2. Logout
  3. Try login again
  4. Stuck at login page

Expected Behavior
Move to the library after login

Logs

[2021-03-13 01:36:38.060 +01:00] [INF] Authentication request for "Admin" has succeeded.
[2021-03-13 01:36:38.061 +01:00] [INF] Current/Max sessions for user "Admin": 1/0
[2021-03-13 01:36:38.062 +01:00] [INF] Creating new access token for user 25ddb8b4-a016-44ac-9af8-5be6109bc20e
[2021-03-13 01:36:38.183 +01:00] [ERR] Failed executing DbCommand ("0"ms) [Parameters=["@p0='?' (Size = 4), @p1='?', @p2='?' (Size = 61), @p3='?', @p4='?'"], CommandType='Text', CommandTimeout='30']"
""INSERT INTO \"CustomItemDisplayPreferences\" (\"Client\", \"ItemId\", \"Key\", \"UserId\", \"Value\")
VALUES (@p0, @p1, @p2, @p3, @p4);
SELECT \"Id\"
FROM \"CustomItemDisplayPreferences\"
WHERE changes() = 1 AND \"rowid\" = last_insert_rowid();"
[2021-03-13 01:36:38.185 +01:00] [ERR] An exception occurred in the database while saving changes for context type '"Jellyfin.Server.Implementations.JellyfinDb"'."
""Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: CustomItemDisplayPreferences.Value'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)"
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: CustomItemDisplayPreferences.Value'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
[2021-03-13 01:36:38.188 +01:00] [ERR] Error processing request. URL "GET" "/DisplayPreferences/usersettings".
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'NOT NULL constraint failed: CustomItemDisplayPreferences.Value'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Jellyfin.Server.Implementations.Users.DisplayPreferencesManager.SaveChanges()
   at Jellyfin.Api.Controllers.DisplayPreferencesController.GetDisplayPreferences(String displayPreferencesId, Guid userId, String client)
   at lambda_method518(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.<InvokeNextResourceFilter>g__Awaited|24_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__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Jellyfin.Server.Middleware.ServerStartupMessageMiddleware.Invoke(HttpContext httpContext, IServerApplicationHost serverApplicationHost, ILocalizationManager localizationManager)
   at Jellyfin.Server.Middleware.WebSocketHandlerMiddleware.Invoke(HttpContext httpContext, IWebSocketManager webSocketManager)
   at Jellyfin.Server.Middleware.IpBasedAccessValidationMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
   at Jellyfin.Server.Middleware.LanFilteringMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
   at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.ReDoc.ReDocMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.RobotsRedirectionMiddleware.Invoke(HttpContext httpContext)
   at Jellyfin.Server.Middleware.LegacyEmbyRouteRewriteMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.ResponseTimeMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.ExceptionMiddleware.Invoke(HttpContext context)

System (please complete the following information):

  • Platform: Linux, Debian 10
  • Browser: Tested on Chrome, Edge, Firefox
  • Jellyfin Version: 10.7.0
@Izaya21 Izaya21 added the bug Something isn't working label Mar 13, 2021
@vekuda
Copy link

vekuda commented Mar 19, 2021

I have been experiencing the same issue on Windows 10 ever since the 10.7.0 update. Launching the web interface from the tray icon will open a new browser tab and it will show just a permanent loading screen. Performing a clean installation didn't fix it.

I can access the web interface only if I manually type the server IP in the address bar (ex. "http://xxx.yyy.zzz.www:8096").

The default "localhost:8096/..." leads to the above-mentioned permanent loading screen.

UPDATE:

Nevermind, I have found the fix.
I have had to delete the cookies on "localhost:8096/..." in order to get the web interface ask me to login again. I have entered the credentials and the web interface worked as usual.
So apparently "Ctrl+F5" and clearing the browser cache are not enough: deleting cookies is the way to go.

@lyz-code
Copy link

lyz-code commented Mar 29, 2021

I can reproduce this error after an upgrade from 10.6.4 to 10.7.1 using the linuxserver/jellyfin docker, but with a different exception:

[10:14:33] [ERR] [239] Microsoft.EntityFrameworkCore.Database.Command: Failed executing DbCommand (1ms) [Parameters=[@p0='?', @p1='?' (Size = 4), @p2='?', @p3='?', @p4='?', @p5='?', @p6='?', @p7='?', @p8='?', @p9='?', @p10='?', @p11='?', @p12='?'], CommandType='Text', CommandTimeout='30']
INSERT INTO "DisplayPreferences" ("ChromecastVersion", "Client", "DashboardTheme", "EnableNextVideoInfoOverlay", "IndexBy", "ItemId", "ScrollDirection", "ShowBackdrop", "ShowSidebar", "SkipBackwardLength", "SkipForwardLength", "TvHome", "UserId")
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12);
SELECT "Id"
FROM "DisplayPreferences"
WHERE changes() = 1 AND "rowid" = last_insert_rowid();
[10:14:33] [ERR] [239] Microsoft.EntityFrameworkCore.Update: An exception occurred in the database while saving changes for context type 'Jellyfin.Server.Implementations.JellyfinDb'.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
[10:14:33] [ERR] [239] Jellyfin.Server.Middleware.ExceptionMiddleware: Error processing request. URL GET /DisplayPreferences/usersettings.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Jellyfin.Server.Implementations.Users.DisplayPreferencesManager.SaveChanges()
   at Jellyfin.Api.Controllers.DisplayPreferencesController.GetDisplayPreferences(String displayPreferencesId, Guid userId, String client)
   at lambda_method395(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.<InvokeNextResourceFilter>g__Awaited|24_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__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Jellyfin.Server.Middleware.ServerStartupMessageMiddleware.Invoke(HttpContext httpContext, IServerApplicationHost serverApplicationHost, ILocalizationManager localizationManager)
   at Jellyfin.Server.Middleware.WebSocketHandlerMiddleware.Invoke(HttpContext httpContext, IWebSocketManager webSocketManager)
   at Jellyfin.Server.Middleware.IpBasedAccessValidationMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
   at Jellyfin.Server.Middleware.LanFilteringMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
   at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.ReDoc.ReDocMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.RobotsRedirectionMiddleware.Invoke(HttpContext httpContext)
   at Jellyfin.Server.Middleware.LegacyEmbyRouteRewriteMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.ResponseTimeMiddleware.Invoke(HttpContext context)
   at Jellyfin.Server.Middleware.ExceptionMiddleware.Invoke(HttpContext context)

That error makes the user browser fail when trying to access wss://xxxx.org/socket?api_key=... with a 401 error and https://xxxx.org/DisplayPreferences/usersettings?userId= with an 500.

Clearing the cache and cookies didn't solve the issue for me, rolling back to 10.6.4 did. Be careful though as they don't support downgrades and you need to restore the config directory to the state before the upgrade

@lyz-code
Copy link

lyz-code commented Mar 30, 2021

#2493 doesn't solve it either as I have the expected config.json

{
  "includeCorsCredentials": false,
  "multiserver": false,
  "themes": [
    {
      "name": "Apple TV",
      "id": "appletv"
    }, {
      "name": "Blue Radiance",
      "id": "blueradiance"
    }, {
      "name": "Dark",
      "id": "dark",
      "default": true
    }, {
      "name": "Light",
      "id": "light"
    }, {
      "name": "Purple Haze",
      "id": "purplehaze"
    }, {
      "name": "WMC",
      "id": "wmc"
    }
  ],
  "servers": [],
  "plugins": [
    "playAccessValidation/plugin",
    "experimentalWarnings/plugin",
    "htmlAudioPlayer/plugin",
    "htmlVideoPlayer/plugin",
    "photoPlayer/plugin",
    "comicsPlayer/plugin",
    "bookPlayer/plugin",
    "youtubePlayer/plugin",
    "backdropScreensaver/plugin",
    "pdfPlayer/plugin",
    "logoScreensaver/plugin",
    "sessionPlayer/plugin",
    "chromecastPlayer/plugin"
  ]
}

But surprisingly #5489 did:

systemctl stop jellyfin.service
mv /var/lib/jellyfin/data/jellyfin.db{,.bak}
systemctl start jellyfin.service
# [ Go to JF URL, get asked to log in even though there are no Users in the JF DB now]
systemctl stop jellyfin.service
mv /var/lib/jellyfin/data/jellyfin.db{.bak,}
systemctl start jellyfin.service

@sbstp
Copy link

sbstp commented Jun 18, 2021

Also having issues... It seems like a lot of these errors are linked to SQLite. Started having the issue on 10.7.5, still have it on 10.7.6.

Jun 17 23:56:08 trinity docker[9635]: [03:56:08] [ERR] [44] Microsoft.EntityFrameworkCore.Query: An exception occurred while iterating over the results of a query for context type 'Jellyfin.Server.Implementations.JellyfinDb'.
Jun 17 23:56:08 trinity docker[9635]: System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling.
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.Data.Sqlite.SqliteDataReader.GetString(Int32 ordinal)
Jun 17 23:56:08 trinity docker[9635]:    at lambda_method645(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator )
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
Jun 17 23:56:08 trinity docker[9635]: System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling.
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.Data.Sqlite.SqliteDataReader.GetString(Int32 ordinal)
Jun 17 23:56:08 trinity docker[9635]:    at lambda_method645(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator )
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
Jun 17 23:56:08 trinity docker[9635]: [03:56:08] [ERR] [44] Jellyfin.Server.Middleware.ExceptionMiddleware: Error processing request. URL GET /DisplayPreferences/usersettings.
Jun 17 23:56:08 trinity docker[9635]: System.InvalidOperationException: The data is NULL at ordinal 5. This method can't be called on NULL values. Check using IsDBNull before calling.
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.Data.Sqlite.SqliteDataReader.GetString(Int32 ordinal)
Jun 17 23:56:08 trinity docker[9635]:    at lambda_method645(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator )
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
Jun 17 23:56:08 trinity docker[9635]:    at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
Jun 17 23:56:08 trinity docker[9635]:    at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Implementations.Users.DisplayPreferencesManager.ListCustomItemDisplayPreferences(Guid userId, Guid itemId, String client)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Api.Controllers.DisplayPreferencesController.GetDisplayPreferences(String displayPreferencesId, Guid userId, String client)
Jun 17 23:56:08 trinity docker[9635]:    at lambda_method503(Closure , Object , Object[] )
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] argument
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
Jun 17 23:56:08 trinity docker[9635]: --- End of stack trace from previous location ---
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
Jun 17 23:56:08 trinity docker[9635]: --- End of stack trace from previous location ---
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isComple
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
Jun 17 23:56:08 trinity docker[9635]: --- End of stack trace from previous location ---
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.ServerStartupMessageMiddleware.Invoke(HttpContext httpContext, IServerApplicationHost serverApplicationHost, ILocalizationManager localizationManager)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.WebSocketHandlerMiddleware.Invoke(HttpContext httpContext, IWebSocketManager webSocketManager)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.IpBasedAccessValidationMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.LanFilteringMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult autho
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
Jun 17 23:56:08 trinity docker[9635]:    at Swashbuckle.AspNetCore.ReDoc.ReDocMiddleware.Invoke(HttpContext httpContext)
Jun 17 23:56:08 trinity docker[9635]:    at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
Jun 17 23:56:08 trinity docker[9635]:    at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.RobotsRedirectionMiddleware.Invoke(HttpContext httpContext)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.LegacyEmbyRouteRewriteMiddleware.Invoke(HttpContext httpContext)
Jun 17 23:56:08 trinity docker[9635]:    at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.ResponseTimeMiddleware.Invoke(HttpContext context)
Jun 17 23:56:08 trinity docker[9635]:    at Jellyfin.Server.Middleware.ExceptionMiddleware.Invoke(HttpContext context)

@deanishe
Copy link

deanishe commented Jul 4, 2021

For me, login actually succeeds, but another request fails (the XHR for prefs), so I'm stuck at the login page with the spinner spinning. If I enter the URL of the homepage, I am logged in.

@sbstp
Copy link

sbstp commented Jul 5, 2021

This issue was causing me issues on the favorites' page as well. I decided to try to fix it myself...

I didn't want to lose my library because I have like 450 movies tagged as favorites which is my way of keeping my 'to watch' list.

Here's what I did to fix it:

  1. Stopped jellyfin
  2. Deleted authentication.db and jellyfin.db in config/data. Good idea to back them up before just in case...
  3. Left library.db untouched.
  4. Changed <IsStartupWizardCompleted>false</IsStartupWizardCompleted> to <IsStartupWizardCompleted>true</IsStartupWizardCompleted> <IsStartupWizardCompleted>false</IsStartupWizardCompleted> in config/root.
  5. Restarted jellyfin and re-created my user.

Good as new. I'm not sure how it maps between users and favorites, I re-created my user with the exact same name and my favorites are intact. The user ID is a GUID which is most definitely different than before.

@LandazuriPaul
Copy link

I've experienced the same issue several times when loading a library page, say "movies". It would be stuck with a loading spin indefinitely.

But if I manually change the URL and remove the query parameters, mainly the topParentId, then the page loads fine.

I don't know if this is the same issue, and I might open another one if they are different.

@sweisgerber
Copy link

sweisgerber commented Aug 7, 2021

@sbstp: Can confirm that your instructions work and that the library stays intact.
I had to verify that the config flag for the StartUpWizard in /etc/jellyfin/system.xml is set to false:

<IsStartupWizardCompleted>false</IsStartupWizardCompleted>

Perhaps you switched your logic? I couldn't create new users otherwise, when it was set to true.

Regarding the users: They map based on the user IDs and it seems that it increments for each user, so the creation order matters, not the names.
If you don't remember the order anymore, it's not too bad, as you can rename users after creation.

I hope that helps others.

@sbstp
Copy link

sbstp commented Aug 7, 2021

@sweisgerber yeah that was a typo, it needs to be false.

@sbstp
Copy link

sbstp commented Aug 7, 2021

@sweisgerber I actually found a better fix, this issue came back for me. The fix was to go into jellyfin.db with sqlite3 (command line) or sqlitebrowser (gui) and delete the rows of CustomItemDisplayPreferences where value is null. Make sure to backup the db before doing that just in case.

DELETE FROM CustomItemDisplayPreferences WHERE Value IS NULL;

@sweisgerber
Copy link

@sbstp Thanks a lot that's even easier. :)

@zynexiz
Copy link

zynexiz commented Aug 9, 2021

Had the same issue myself, upgraded from unstable release. My problem was not the CustomItemDisplayPreferences but in Permissions and Preference databases. One user had NULL in Permissions_Permissions_Guid and Preference_Preference_Guid. Copying the UserId to that part fixed it for me.

@cvium
Copy link
Member

cvium commented Sep 7, 2021

Fixed in 10.7.7 jellyfin/jellyfin#6512

@cvium cvium closed this as completed Sep 7, 2021
@marine1988
Copy link

hi have this issue after downgrade from nightly 10.8 to 10.7

@thornbill
Copy link
Member

Downgrading is not supported. If you are going to downgrade you need to have a backup from the previous version to restore.

@sirineBH
Copy link

sirineBH commented Jun 16, 2022

If the problem persists in v10.7.7, you have to restart Jellyfin server.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests