Library Not Loading

[firesword13]

I have one user that is having issues viewing one library. When the user clicks into the library, the Shows tab loads endlessly. However, the episodes tab loads fine and does show the correct content. Additionally, all other users can access the library normally, and the affected user is not having issues with any other libraries.

[Efficient_Good_5784]

Try clearing out the user's device from Jellyfin's device list (found in the dashboard).

Also try clearing out the user's client's cache.

[firesword13]

Try clearing out the user's device from Jellyfin's device list (found in the dashboard).

Also try clearing out the user's client's cache.

No such luck, unfortunately. Even tried uninstalling completely on one device, and it still happens. Also happens on brand new devices, where it works for other users. I'm thinking it's something on the server side, but I'm not knowledgeable enough to figure out what's messed up.

[firesword13]

Finally figured this out. To any future readers, please be warned that these steps are potentially dangerous to your instance, and should not be attempted without backups and knowing how to restore them.

The fix was found and applied using sqlite3, so if the instance of Jellyfin does not have this installed (such as in a Docker setup like mine), you will have to either apply the fixes on the host system or on another machine and transfer the corrected database. These steps will assume you are working on the system where you're using sqlite3 to run the commands, and Jellyfin has been turned off or you're not working on the live dabatase.

-Change your working directory to the location of library.db
-Issue this command: sqlite3 library.db "PRAGMA integrity_check;"
-This should return errors such as "row 177 missing from index UserDatasIndex5", in my instance it returned errors for indexes 1-5
-First attempt to reindex using this command as a template: sqlite3 library.db "reindex UserDatasIndex1;"
-If an index is unique, it likely won't reindex and will need to be dropped and recreated as non-unique (this is what happened to me for UserDatasIndex1)
-To drop the UserDatasIndex1, I used this command: sqlite3 library.db "DROP INDEX IF EXISTS UserDatasIndex1;"
-To recreate the index, first attempt this command: sqlite3 library.db "CREATE UNIQUE INDEX UserDatasIndex1 on UserDatas (key, userId);"
-If that doesn't work, use this command instead: sqlite3 library.db "CREATE INDEX UserDatasIndex1 ON UserDatas (key, userId);"

If you're working on the live database while Jellyfin is turned off, you now just need to turn it back on and everything should work. If you were working on a copy of the database, you'll need to turn Jellyfin off and replace the live database with your copy.