Database Issues Causing Inability to open certain TV Shows and Movies

[azpaz]

Issue:224Some TV Shows and Movies, Show up when viewing the library (i.e. browsing all movies or tvshows), however, when trying to open the tvshow / movie, (regardless of web app / phone app / tv app), it just forever gets stuck on a loading screen.

Temporary Fix: Example if the tvshow "Heroes" isn't loading, I have to manually go to where it is located in the directories and rename the folder from "Heroes (2006)" to say "Heroes [2006]" and then rescan the library for new folders/files. Then Heroes starts working again normally.

The larger problem: I have a library of 3000+ movies and 800+ tvshows and I don't want to keep having to manually search / look for tvshows and files not working everytime.

Other symptoms: a little before I noticed this problem, i had noticed that the "Reports" Plugin/Feature no longer displays my "Media" (Movies/Tv) regardless of how long it I wait for it to load. When I change Reports to view activity, it shows all activity immediately.

What I would like: to know if there's any database fixing / cleaning procedure other people use to fix this problem if they face it too.

My Environment:
- docker container on a synology nas (will be migrating to a custom server sometime next year but I want to not have to deal with this problem before I think about migration)
- database and config files stored on a perfectly operational SSD volume, media files stored on a larger HDD volume, zero performance or integrity issues with both.
- currently running 10.9.11, but I think I first noticed this issue 10.8 onwards...not sure as I did not make a note of when I first noticed it

[TheDreadPirate]

Can you share your full jellyfin logs via pastebin?

[azpaz]

Can you share your full jellyfin logs via pastebin?

Hey sorry, new here so might need a little assistance.

Finally found another tv show that has the same issue and decided to come back here to figure this out before fixing it manually myself.

Note: already on v 10.10.3


https://pastebin.com/Nzyd5VsX

the error should be one of the last things in here. Hope it helps.

Currently going to be migrating everything to a newer server that will run on nvmes (for the database and config stuff) and have a higher end CPU, so i might just end up manually fixing more things there as it would allow me to flip throw shows and movies faster.

[azpaz]

HOLY CRAP...I popped the ending of the logs into chatgpt and asked it to help me fix the problem and IT WORKED....it fixed ALL MY PROBLEMS.

Basically, in container manager, one of the default variables was
DOTNET_SYSTEM_GLOBALIZATION_INVARIANT = 1

I just had to change to
DOTNET_SYSTEM_GLOBALIZATION_INVARIANT = 0

weirdly that fixed the tvshows and movies hanging AS WELL AS not being able to see any movie or tvshow database in the reports section

damn

[TheDreadPirate]

Yep. That is a known problem with some docker setups. Some docker environments set that variable to 1 by default. Any non-English characters in file names or folder names causes DOTNET to fail.