Massive 500 error when requesting /emby/Users/<ID>/Items/...

[MissMakima 2]

Hello,

Recently I found my server been very slow that it may consume 10-15 secs to load the full homepage on mobile apps.

I checked the log on my Debian 12 server and I found a lot of 500 errors with an extremely long response time with the webpath above.

Here are the related logs:

2024-10-22 09:16:57.849 Info Server: http/1.1 Response 500 to ‌‍‍<ClientIP>‌. Time: 8226ms. GET http://‌‍‍<ServerHost>‌/Users/<ItemID>/Items/Latest?Fields=DateCreated,Etag,Genres,MediaSources,AlternateMediaSources,Overview,ParentId,Path,People,ProviderIds,SortName,RecursiveItemCount,ChildCount,CommunityRating,OfficialRating,PremiereDate&ParentId=162238&StartIndex=0&Limit=20
2024-10-22 09:16:57.864 Info Server: http/1.1 Response 500 to ‌‍‍<ClientIP>‌. Time: 7978ms. GET http://‌‍‍<ServerHost>‌/Users/<ItemID>/Items/Latest?Fields=DateCreated,Etag,Genres,MediaSources,AlternateMediaSources,Overview,ParentId,Path,People,ProviderIds,SortName,RecursiveItemCount,ChildCount,CommunityRating,OfficialRating,PremiereDate&ParentId=150212&StartIndex=0&Limit=20
2024-10-22 09:16:58.034 Info Server: http/1.1 Response 500 to ‌‍‍<ClientIP>‌. Time: 8147ms. GET http://‌‍‍<ServerHost>‌/Users/<ItemID>/Items/Latest?Fields=DateCreated,Etag,Genres,MediaSources,AlternateMediaSources,Overview,ParentId,Path,People,ProviderIds,SortName,RecursiveItemCount,ChildCount,CommunityRating,OfficialRating,PremiereDate&ParentId=150209&StartIndex=0&Limit=20
2024-10-22 09:16:58.071 Info Server: http/1.1 Response 500 to ‌‍‍<ClientIP>‌. Time: 8185ms. GET http://‌‍‍<ServerHost>‌/Users/<ItemID>/Items/Latest?Fields=DateCreated,Etag,Genres,MediaSources,AlternateMediaSources,Overview,ParentId,Path,People,ProviderIds,SortName,RecursiveItemCount,ChildCount,CommunityRating,OfficialRating,PremiereDate&ParentId=3&StartIndex=0&Limit=20
2024-10-22 09:16:58.072 Info Server: http/1.1 Response 500 to ‌‍‍<ClientIP>‌. Time: 8445ms. GET http://‌‍‍<ServerHost>‌/Users/<ItemID>/Items/Latest?Fields=DateCreated,Etag,Genres,MediaSources,AlternateMediaSources,Overview,ParentId,Path,People,ProviderIds,SortName,RecursiveItemCount,ChildCount,CommunityRating,OfficialRating,PremiereDate&ParentId=162235&StartIndex=0&Limit=20
2024-10-22 09:16:58.086 Info Server: http/1.1 Response 500 to ‌‍‍<ClientIP>‌. Time: 8461ms. GET http://‌‍‍<ServerHost>‌/Users/<ItemID>/Items/Latest?Fields=DateCreated,Etag,Genres,MediaSources,AlternateMediaSources,Overview,ParentId,Path,People,ProviderIds,SortName,RecursiveItemCount,ChildCount,CommunityRating,OfficialRating,PremiereDate&ParentId=162232&StartIndex=0&Limit=20
2024-10-22 09:16:58.097 Info Server: http/1.1 Response 500 to ‌‍‍<ClientIP>‌. Time: 8213ms. GET http://‌‍‍<ServerHost>‌/Users/<ItemID>/Items/Latest?Fields=DateCreated,Etag,Genres,MediaSources,AlternateMediaSources,Overview,ParentId,Path,People,ProviderIds,SortName,RecursiveItemCount,ChildCount,CommunityRating,OfficialRating,PremiereDate&ParentId=119915&StartIndex=0&Limit=20

These requests made the loading process terribly slow but I could not find any similar problem online. Could someone help me?

[MissMakima 2]

Could someone give me some advice? I re-scanned the Metadata Folder but it did not help.

[Luke 42077]

Hi there, please attach the complete Emby server log file, thanks.

[MissMakima 2]

The full server log is below:

embyserver-63865299696.txt

[MissMakima 2]

2 hours ago, Luke said:

Hi there, please attach the complete Emby server log file, thanks.

I have posted above. You can check it now.

[Luke 42077]

Hi @MissMakimahave you played with the server database settings? Can you try increasing the cache size, then restarting the server and see how things compare? Thanks !

[MissMakima 2]

On 11/7/2024 at 10:07 AM, Luke said:

Hi @MissMakimahave you played with the server database settings? Can you try increasing the cache size, then restarting the server and see how things compare? Thanks !

@LukeNo I didn't do anything like that. In the past 2 months I reinstalled the emby-server and solved this problem for a while. But now it is happening again in my new deployment. I tried increase the cache to 5120MB but it doesn't work.

[Luke 42077]

6 hours ago, MissMakima said:

@LukeNo I didn't do anything like that. In the past 2 months I reinstalled the emby-server and solved this problem for a while. But now it is happening again in my new deployment. I tried increase the cache to 5120MB but it doesn't work.

HI, can you please attach a new emby server log file ?thanks !

[MissMakima 2]

8 hours ago, Luke said:

HI, can you please attach a new emby server log file ?thanks !

Sure. You can search for 'Response 500' in the log file. There are countless results.

embyserver.txt

[Luke 42077]

OK if you need immediate relief you could always try the 4.9 beta server as there are some performance improvements there.

[MissMakima 2]

39 minutes ago, Luke said:

OK if you need immediate relief you could always try the 4.9 beta server as there are some performance improvements there.

Is that a performance-related problem? I'm using a VM with 16-core Intel Xeon Gold 6138 CPU and 32 GB RAM. The occupation of computing resources are relatively low right now.

 

 

[Luke 42077]

Hi, yes it appears to be some slow database queries.