+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: Troubleshooting (https://forum.jellyfin.org/f-troubleshooting)
+--- Thread: Slow UI and slow DB queries (/t-slow-ui-and-slow-db-queries)
Pages:
1
2
Slow UI and slow DB queries - laRoulade - 2025-04-09
Hello,
I am running Jellyfin 10.10.7 on Windows.
The issue started on 10.10.6 but did not start when installing the version (it started a couple weeks later). It kind of happened over night...
I have searched the forums but cannot find an issue that matches my problem and I am out of ideas on the subject…
When I access a Jellyfin client (web, mobile, kodi), everything is really slow to load (about 15 seconds vs almost instantly before) (libraries, collections, images, medias…). It occurs on localhost, on local network and through my reverse proxy all the same.
The thing is once I have accessed it once, if I access it again it works flawlessly. But if I do not access it for about 10min, the issue appears again.
On debug logs I see a lot of db queries taking about 1000ms (I do not have access to the logs right now but will post them if needed in the evening).
My Jellyfin instance (and its db) runs on a SSD with a i5 12500 and 32GB RAM (with ~16GB of free RAM).
My library.db file is about 100Mo.
I have the following plugins running (but haven't added any for a really long time): AudioDB, DLNA, Intro Skipper, MusicBrainz, Open Subtitles, OMDb, Sutio Images, TMDb.
What I've tried so far: Reboot the Jellyfin instance, reboot the server, replace all metadatas.
All my other apps on the server work flawlessly and Jellyfin did too until now.
Thanks in advance if any of you have an idea.
I typically get those: https://pastebin.com/raw/suL4Mn4y
RE: Slow UI and slow DB queries - TheDreadPirate - 2025-04-09
Can you share your jellyfin log via privatebin.net? Preferably without debug logging as it generates a massive amount of logs that gets in the way of initial diagnosis and information gathering.
FWIW, a 100MB library DB is not that large. Mine is 335MB.
RE: Slow UI and slow DB queries - laRoulade - 2025-04-09
Here is the full log from two days ago (problem was lready occurring): https://privatebin.net/?2a442144f60fe9fa#AmnpPnUu7rHiFCcnW5xeRUKgDJQiTPY2PCmJfgcVCPph
Yes I figured 100MB is not that big but I'm trying to give as much info as I can.
RE: Slow UI and slow DB queries - TheDreadPirate - 2025-04-09
I see two network interfaces in the log.
192.168.1.106
10.140.230.185
I'm assuming the 10. address is a VPN? If so, does this issue go away if you disable the VPN?
RE: Slow UI and slow DB queries - laRoulade - 2025-04-09
It is indeed a VPN and no the issue persists without the VPN. It is anyway bypassed by everything but my {app we don't talk about - TDP} client.
RE: Slow UI and slow DB queries - TheDreadPirate - 2025-04-09
The only thing I see out of place is this log message. Which happens quite a lot.
Code:
Emby.Server.Implementations.HttpServer.WebSocketConnection: WS "192.168.1.100" error receiving data: "The remote party closed the WebSocket connection without completing the close handshake."I checked my log and that log entry occurs only during my daily restart for my backup job.
So SOMETHING network related is causing your problem, but I don't have enough info in your log to say what.
RE: Slow UI and slow DB queries - laRoulade - 2025-04-09
I am able to reproduce those. It happens everytime I reload the web page on my domain name.
192.168.1.100 it where my reverse proxy is located.
RE: Slow UI and slow DB queries - TheDreadPirate - 2025-04-09
You mentioned that you saw in the debug log that queries were taking a long time. Is there some sort of power saving feature enabled that could be putting your SSD or OS in a lower power state?
RE: Slow UI and slow DB queries - laRoulade - 2025-04-09
I have tried to disable everything I can, I will let you know how it goes.
For reference I get such logs for db calls: https://privatebin.net/?ab15ee7b0d3ffdfe#Cky7pSMYGU9EKnxdg9RUvrSgXNev7PJ6vaR89E64G3Yy
Edit: Disabling all power saving feature did not change anything.
RE: Slow UI and slow DB queries - TheDreadPirate - 2025-04-10
Nothing obviously wrong from a Jellyfin perspective. No plugins installed that may be doing expensive queries. Do you have an external app setup that would access Jellyfin? Jellysearch? Some other external Jellyfin search app? Anything that may periodically query Jellyfin?
If none of that applies, another thing you can check is windows event viewer to look anything that can give us a clue of what is going on.