[Issue]: High CPU usage when enter web-site #4100

Closed
opened 2026-02-07 00:25:35 +03:00 by OVERLORD · 1 comment
Owner

Originally created by @Jacob1532 on GitHub (Aug 10, 2022).

Please describe your bug

I run Jellyfin version 10.7.8 without any issue in docker container (docker version 20.10.17) on Debian server.
I updated the jellyfin docker image to 10.8.3. Since them, when I start the docker container everything is fine, the cpu usage stays around 1% and this for hours. But when I enter the jellyfin website, no matter via web proxy Apache2 or without. The Cpu usage jumps to 50% and stays there forever.

In the logs it just shows that the SQLite queries are slow, but I don't find any hint, why it isn't working. Also with docker image version 10.8.1 the same behaviour. But if I go back to 10.7.8 everything works fine again.

Jellyfin Version

10.8.0

if other:

No response

Environment

- OS: Debian 10
- Virtualization: Docker Version 20.10.17
- Clients: Browser
- Browser: Firefox 103.0.1 and Chrome 1030.5030.134
- FFmpeg Version: 5.0.1
- Playback Method:
- Hardware Acceleration:
- Plugins:
- Reverse Proxy: apache
- Base URL:
- Networking: Host
- Storage: local

Jellyfin logs

[09:36:48] [INF] [1] Main: Jellyfin version: 10.8.3
[09:36:48] [INF] [1] Main: Environment Variables: ["[DOTNET_SYSTEM_GLOBALIZATION_INVARIANT, 1]", "[JELLYFIN_FFMPEG, /usr/lib/jellyfin-ffmpeg/ffmpeg]", "[JELLYFIN_CONFIG_DIR, /config/config]", "[JELLYFIN_PublishedServerUrl, https://jellyfin.jacob-fritsche.de]", "[JELLYFIN_CACHE_DIR, /cache]", "[JELLYFIN_DATA_DIR, /config]", "[JELLYFIN_WEB_DIR, /jellyfin/jellyfin-web]", "[JELLYFIN_LOG_DIR, /config/log]"]
[09:36:48] [INF] [1] Main: Arguments: ["/jellyfin/jellyfin.dll"]
[09:36:48] [INF] [1] Main: Operating system: Linux
[09:36:48] [INF] [1] Main: Architecture: X64
[09:36:48] [INF] [1] Main: 64-Bit Process: True
[09:36:48] [INF] [1] Main: User Interactive: True
[09:36:48] [INF] [1] Main: Processor count: 8
[09:36:48] [INF] [1] Main: Program data path: /config
[09:36:48] [INF] [1] Main: Web resources path: /jellyfin/jellyfin-web
[09:36:48] [INF] [1] Main: Application directory: /jellyfin/
[09:36:48] [DBG] [1] Jellyfin.Server.Migrations.MigrationRunner: Skipping migration 'CreateNetworkConfiguration' since it is already applied
[09:36:48] [INF] [1] Emby.Server.Implementations.AppBase.BaseConfigurationManager: Setting cache path: /cache
[09:36:48] [INF] [1] Emby.Server.Implementations.ApplicationHost: Loading assemblies
[09:36:48] [INF] [1] Emby.Server.Implementations.Plugins.PluginManager: Loaded assembly Jellyfin.Plugin.KodiSyncQueue, Version=9.0.0.0, Culture=neutral, PublicKeyToken=null from /config/plugins/Kodi Sync Queue_9.0.0.0/Jellyfin.Plugin.KodiSyncQueue.dll
[09:36:48] [INF] [1] Emby.Server.Implementations.Plugins.PluginManager: Loaded assembly LiteDB, Version=5.0.12.0, Culture=neutral, PublicKeyToken=4ee40123013c9f27 from /config/plugins/Kodi Sync Queue_9.0.0.0/LiteDB.dll
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.Common.Providers.SubtitleConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.Controller.Library.MetadataConfigurationStore
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Server.Implementations.LiveTv.LiveTvConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Server.Implementations.Branding.BrandingConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.MediaEncoding.Configuration.EncodingConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Dlna.DlnaConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Notifications.NotificationConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.XbmcMetadata.Configuration.NfoConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Jellyfin.Networking.Configuration.NetworkConfigurationFactory
[09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Jellyfin.Server.Migrations.MigrationsFactory

[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -version
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: ffmpeg output: ffmpeg version 5.0.1-Jellyfin Copyright (c) 2000-2022 the FFmpeg developers
built with gcc 10 (Debian 10.2.1-6)
configuration: --prefix=/usr/lib/jellyfin-ffmpeg --target-os=linux --extra-libs=-lfftw3f --extra-version=Jellyfin --disable-doc --disable-ffplay --disable-ptx-compression --disable-shared --disable-libxcb --disable-sdl2 --disable-xlib --enable-lto --enable-gpl --enable-version3 --enable-static --enable-gmp --enable-gnutls --enable-chromaprint --enable-libdrm --enable-libass --enable-libfreetype --enable-libfribidi --enable-libfontconfig --enable-libbluray --enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis --enable-libdav1d --enable-libwebp --enable-libvpx --enable-libx264 --enable-libx265 --enable-libzvbi --enable-libzimg --enable-libfdk-aac --arch=amd64 --enable-libshaderc --enable-libplacebo --enable-vulkan --enable-opencl --enable-vaapi --enable-amf --enable-libmfx --enable-ffnvcodec --enable-cuda --enable-cuda-llvm --enable-cuvid --enable-nvdec --enable-nvenc
libavutil      57. 17.100 / 57. 17.100
libavcodec     59. 18.100 / 59. 18.100
libavformat    59. 16.100 / 59. 16.100
libavdevice    59.  4.100 / 59.  4.100
libavfilter     8. 24.100 /  8. 24.100
libswscale      6.  4.100 /  6.  4.100
libswresample   4.  3.100 /  4.  3.100
libpostproc    56.  3.100 / 56.  3.100

[09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Found ffmpeg version 5.0.1
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -decoders
[09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available decoders: ["libdav1d", "av1", "av1_cuvid", "av1_qsv", "h264", "h264_qsv", "h264_cuvid", "hevc", "hevc_qsv", "hevc_cuvid", "mpeg2video", "mpeg2_qsv", "mpeg2_cuvid", "mpeg4", "mpeg4_cuvid", "msmpeg4", "vc1_qsv", "vc1_cuvid", "vp8", "libvpx", "vp8_cuvid", "vp8_qsv", "vp9", "libvpx-vp9", "vp9_cuvid", "vp9_qsv", "aac", "ac3", "flac", "mp3"]
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -encoders
[09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available encoders: ["libx264", "h264_amf", "h264_nvenc", "h264_qsv", "h264_v4l2m2m", "h264_vaapi", "libx265", "hevc_amf", "hevc_nvenc", "hevc_qsv", "hevc_vaapi", "mpeg4", "msmpeg4", "libvpx", "libvpx-vp9", "aac", "libfdk_aac", "ac3", "flac", "libmp3lame", "libopus", "libvorbis", "srt"]
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -filters
[09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available filters: ["deinterlace_qsv", "deinterlace_vaapi", "hwupload_cuda", "hwupload_vaapi", "overlay_opencl", "overlay_qsv", "overlay_vaapi", "overlay_cuda", "procamp_vaapi", "scale_cuda", "scale_opencl", "scale_qsv", "scale_vaapi", "tonemap_cuda", "tonemap_opencl", "tonemap_vaapi", "vpp_qsv", "yadif_cuda", "zscale", "alphasrc"]
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=scale_cuda
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=tonemap_cuda
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=tonemap_opencl
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=overlay_opencl
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=overlay_vaapi
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -hwaccels
[09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available hwaccel types: ["cuda", "vaapi", "qsv", "drm", "opencl", "vulkan"]
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -version
[09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: ffmpeg output: ffmpeg version 5.0.1-Jellyfin Copyright (c) 2000-2022 the FFmpeg developers
built with gcc 10 (Debian 10.2.1-6)
configuration: --prefix=/usr/lib/jellyfin-ffmpeg --target-os=linux --extra-libs=-lfftw3f --extra-version=Jellyfin --disable-doc --disable-ffplay --disable-ptx-compression --disable-shared --disable-libxcb --disable-sdl2 --disable-xlib --enable-lto --enable-gpl --enable-version3 --enable-static --enable-gmp --enable-gnutls --enable-chromaprint --enable-libdrm --enable-libass --enable-libfreetype --enable-libfribidi --enable-libfontconfig --enable-libbluray --enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis --enable-libdav1d --enable-libwebp --enable-libvpx --enable-libx264 --enable-libx265 --enable-libzvbi --enable-libzimg --enable-libfdk-aac --arch=amd64 --enable-libshaderc --enable-libplacebo --enable-vulkan --enable-opencl --enable-vaapi --enable-amf --enable-libmfx --enable-ffnvcodec --enable-cuda --enable-cuda-llvm --enable-cuvid --enable-nvdec --enable-nvenc
libavutil      57. 17.100 / 57. 17.100
libavcodec     59. 18.100 / 59. 18.100
libavformat    59. 16.100 / 59. 16.100
libavdevice    59.  4.100 / 59.  4.100
libavfilter     8. 24.100 /  8. 24.100
libswscale      6.  4.100 /  6.  4.100
libswresample   4.  3.100 /  4.  3.100
libpostproc    56.  3.100 / 56.  3.100

[09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: FFmpeg: /usr/lib/jellyfin-ffmpeg/ffmpeg
[09:37:01] [INF] [1] Emby.Server.Implementations.ApplicationHost: ServerId: 539eccee82c84952b72a3f2889929dce
[09:44:43] [DBG] [91] Jellyfin.Server.Middleware.BaseUrlRedirectionMiddleware: Normalizing an URL at /
[09:44:45] [INF] [87] Emby.Server.Implementations.HttpServer.WebSocketManager: WS XXX.XXX.XXX.XXX request
[09:44:45] [DBG] [87] Emby.Server.Implementations.Session.SessionManager: Creating new WebSocketController
[09:44:45] [DBG] [87] Emby.Server.Implementations.Session.WebSocketController: Adding websocket to session c3aba4eb45ff651e2aa46468808a1865
[09:44:45] [DBG] [87] Emby.Server.Implementations.Session.SessionWebSocketListener: Watching 1 WebSockets.
[09:44:45] [DBG] [91] Emby.Server.Implementations.HttpServer.WebSocketConnection: WS XXX.XXX.XXX.XXX received message: {"MessageType": "KeepAlive", "MessageId": "00000000-0000-0000-0000-000000000000", "ServerId": null, "Data": null, "$type": "WebSocketMessage`1"}
[09:44:45] [DBG] [87] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 37.7685ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
[09:44:45] [DBG] [96] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 12.584ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
[09:44:45] [DBG] [95] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 11.0469ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
[09:44:45] [DBG] [91] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 29.3379ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
[09:44:46] [DBG] [96] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 51.0718ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
[09:44:46] [DBG] [95] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 42.7033ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where playbackPositionTicks > 0 AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('febe96d1480f83839644f6760409d8bc','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f','5ebe11898e764c7252d77978ece25937','6d1caf4ded4bc0fae6431f09befbfa4b','8679d10569ec12981200c4116da3e90b') Group by PresentationUniqueKey ORDER BY LastPlayedDate DESC LIMIT 12
[09:44:46] [DBG] [93] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 54.1299ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId
[09:44:46] [DBG] [91] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 43.9699ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where playbackPositionTicks > 0 AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('febe96d1480f83839644f6760409d8bc','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f','5ebe11898e764c7252d77978ece25937','6d1caf4ded4bc0fae6431f09befbfa4b','8679d10569ec12981200c4116da3e90b') Group by PresentationUniqueKey ORDER BY LastPlayedDate DESC LIMIT 12
[09:44:46] [DBG] [96] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 68.4783ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where playbackPositionTicks > 0 AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('febe96d1480f83839644f6760409d8bc','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f','5ebe11898e764c7252d77978ece25937','6d1caf4ded4bc0fae6431f09befbfa4b','8679d10569ec12981200c4116da3e90b') Group by PresentationUniqueKey ORDER BY LastPlayedDate DESC LIMIT 12
[09:44:46] [DBG] [94] Jellyfin.Api.Auth.CustomAuthenticationHandler: AuthenticationScheme: CustomAuthentication was successfully authenticated.
[09:44:46] [DBG] [93] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 46.1114ms. Query: select type,data,EndDate,ChannelId,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,IsInMixedFolder,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,TotalBitrate,ExtraType,ExternalId,SeriesPresentationUniqueKey,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where type=@type AND TopParentId in ('6d1caf4ded4bc0fae6431f09befbfa4b','5ebe11898e764c7252d77978ece25937','febe96d1480f83839644f6760409d8bc','8679d10569ec12981200c4116da3e90b','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f') Group by SeriesPresentationUniqueKey ORDER BY MAX(LastPlayedDate) DESC
[09:44:46] [DBG] [87] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 21.7427ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 80
[09:44:46] [DBG] [95] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 34.7076ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f') Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 80
[09:44:46] [DBG] [94] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 27.7962ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 80
[09:44:46] [DBG] [85] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 38.0516ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId from TypedBaseItems A where IsFolder=@IsFolder AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 150
[09:44:46] [DBG] [85] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 23.4851ms. Query: select type,data,EndDate,ChannelId,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,IsInMixedFolder,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,ProviderIds,TotalBitrate,ExtraType,ExternalId,OwnerId from TypedBaseItems A where type=@type AND CleanName=@Name
[09:44:51] [DBG] [93] Emby.Server.Implementations.Session.WebSocketController: Removing websocket from session c3aba4eb45ff651e2aa46468808a1865
[09:44:51] [DBG] [93] Emby.Server.Implementations.Session.SessionManager: Disposing session controller synchronously WebSocketController
[09:44:51] [DBG] [93] Emby.Server.Implementations.Session.SessionWebSocketListener: WebSocket Emby.Server.Implementations.HttpServer.WebSocketConnection is closed.
[09:44:51] [INF] [93] Emby.Server.Implementations.HttpServer.WebSocketManager: WS XXX.XXX.XXX.XXX closed
[09:44:57] [DBG] [93] Emby.Server.Implementations.Session.SessionWebSocketListener: Watching 0 WebSockets.

FFmpeg logs

No response

Please attach any browser or client logs here

No response

Please attach any screenshots here

No response

Code of Conduct

  • I agree to follow this project's Code of Conduct
Originally created by @Jacob1532 on GitHub (Aug 10, 2022). ### Please describe your bug I run Jellyfin version 10.7.8 without any issue in docker container (docker version 20.10.17) on Debian server. I updated the jellyfin docker image to 10.8.3. Since them, when I start the docker container everything is fine, the cpu usage stays around 1% and this for hours. But when I enter the jellyfin website, no matter via web proxy Apache2 or without. The Cpu usage jumps to 50% and stays there forever. In the logs it just shows that the SQLite queries are slow, but I don't find any hint, why it isn't working. Also with docker image version 10.8.1 the same behaviour. But if I go back to 10.7.8 everything works fine again. ### Jellyfin Version 10.8.0 ### if other: _No response_ ### Environment ```markdown - OS: Debian 10 - Virtualization: Docker Version 20.10.17 - Clients: Browser - Browser: Firefox 103.0.1 and Chrome 1030.5030.134 - FFmpeg Version: 5.0.1 - Playback Method: - Hardware Acceleration: - Plugins: - Reverse Proxy: apache - Base URL: - Networking: Host - Storage: local ``` ### Jellyfin logs ```shell [09:36:48] [INF] [1] Main: Jellyfin version: 10.8.3 [09:36:48] [INF] [1] Main: Environment Variables: ["[DOTNET_SYSTEM_GLOBALIZATION_INVARIANT, 1]", "[JELLYFIN_FFMPEG, /usr/lib/jellyfin-ffmpeg/ffmpeg]", "[JELLYFIN_CONFIG_DIR, /config/config]", "[JELLYFIN_PublishedServerUrl, https://jellyfin.jacob-fritsche.de]", "[JELLYFIN_CACHE_DIR, /cache]", "[JELLYFIN_DATA_DIR, /config]", "[JELLYFIN_WEB_DIR, /jellyfin/jellyfin-web]", "[JELLYFIN_LOG_DIR, /config/log]"] [09:36:48] [INF] [1] Main: Arguments: ["/jellyfin/jellyfin.dll"] [09:36:48] [INF] [1] Main: Operating system: Linux [09:36:48] [INF] [1] Main: Architecture: X64 [09:36:48] [INF] [1] Main: 64-Bit Process: True [09:36:48] [INF] [1] Main: User Interactive: True [09:36:48] [INF] [1] Main: Processor count: 8 [09:36:48] [INF] [1] Main: Program data path: /config [09:36:48] [INF] [1] Main: Web resources path: /jellyfin/jellyfin-web [09:36:48] [INF] [1] Main: Application directory: /jellyfin/ [09:36:48] [DBG] [1] Jellyfin.Server.Migrations.MigrationRunner: Skipping migration 'CreateNetworkConfiguration' since it is already applied [09:36:48] [INF] [1] Emby.Server.Implementations.AppBase.BaseConfigurationManager: Setting cache path: /cache [09:36:48] [INF] [1] Emby.Server.Implementations.ApplicationHost: Loading assemblies [09:36:48] [INF] [1] Emby.Server.Implementations.Plugins.PluginManager: Loaded assembly Jellyfin.Plugin.KodiSyncQueue, Version=9.0.0.0, Culture=neutral, PublicKeyToken=null from /config/plugins/Kodi Sync Queue_9.0.0.0/Jellyfin.Plugin.KodiSyncQueue.dll [09:36:48] [INF] [1] Emby.Server.Implementations.Plugins.PluginManager: Loaded assembly LiteDB, Version=5.0.12.0, Culture=neutral, PublicKeyToken=4ee40123013c9f27 from /config/plugins/Kodi Sync Queue_9.0.0.0/LiteDB.dll [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.Common.Providers.SubtitleConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.Controller.Library.MetadataConfigurationStore [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Server.Implementations.LiveTv.LiveTvConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Server.Implementations.Branding.BrandingConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.MediaEncoding.Configuration.EncodingConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Dlna.DlnaConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Emby.Notifications.NotificationConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of MediaBrowser.XbmcMetadata.Configuration.NfoConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Jellyfin.Networking.Configuration.NetworkConfigurationFactory [09:36:48] [DBG] [1] Emby.Server.Implementations.ApplicationHost: Creating instance of Jellyfin.Server.Migrations.MigrationsFactory [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -version [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: ffmpeg output: ffmpeg version 5.0.1-Jellyfin Copyright (c) 2000-2022 the FFmpeg developers built with gcc 10 (Debian 10.2.1-6) configuration: --prefix=/usr/lib/jellyfin-ffmpeg --target-os=linux --extra-libs=-lfftw3f --extra-version=Jellyfin --disable-doc --disable-ffplay --disable-ptx-compression --disable-shared --disable-libxcb --disable-sdl2 --disable-xlib --enable-lto --enable-gpl --enable-version3 --enable-static --enable-gmp --enable-gnutls --enable-chromaprint --enable-libdrm --enable-libass --enable-libfreetype --enable-libfribidi --enable-libfontconfig --enable-libbluray --enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis --enable-libdav1d --enable-libwebp --enable-libvpx --enable-libx264 --enable-libx265 --enable-libzvbi --enable-libzimg --enable-libfdk-aac --arch=amd64 --enable-libshaderc --enable-libplacebo --enable-vulkan --enable-opencl --enable-vaapi --enable-amf --enable-libmfx --enable-ffnvcodec --enable-cuda --enable-cuda-llvm --enable-cuvid --enable-nvdec --enable-nvenc libavutil 57. 17.100 / 57. 17.100 libavcodec 59. 18.100 / 59. 18.100 libavformat 59. 16.100 / 59. 16.100 libavdevice 59. 4.100 / 59. 4.100 libavfilter 8. 24.100 / 8. 24.100 libswscale 6. 4.100 / 6. 4.100 libswresample 4. 3.100 / 4. 3.100 libpostproc 56. 3.100 / 56. 3.100 [09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Found ffmpeg version 5.0.1 [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -decoders [09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available decoders: ["libdav1d", "av1", "av1_cuvid", "av1_qsv", "h264", "h264_qsv", "h264_cuvid", "hevc", "hevc_qsv", "hevc_cuvid", "mpeg2video", "mpeg2_qsv", "mpeg2_cuvid", "mpeg4", "mpeg4_cuvid", "msmpeg4", "vc1_qsv", "vc1_cuvid", "vp8", "libvpx", "vp8_cuvid", "vp8_qsv", "vp9", "libvpx-vp9", "vp9_cuvid", "vp9_qsv", "aac", "ac3", "flac", "mp3"] [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -encoders [09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available encoders: ["libx264", "h264_amf", "h264_nvenc", "h264_qsv", "h264_v4l2m2m", "h264_vaapi", "libx265", "hevc_amf", "hevc_nvenc", "hevc_qsv", "hevc_vaapi", "mpeg4", "msmpeg4", "libvpx", "libvpx-vp9", "aac", "libfdk_aac", "ac3", "flac", "libmp3lame", "libopus", "libvorbis", "srt"] [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -filters [09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available filters: ["deinterlace_qsv", "deinterlace_vaapi", "hwupload_cuda", "hwupload_vaapi", "overlay_opencl", "overlay_qsv", "overlay_vaapi", "overlay_cuda", "procamp_vaapi", "scale_cuda", "scale_opencl", "scale_qsv", "scale_vaapi", "tonemap_cuda", "tonemap_opencl", "tonemap_vaapi", "vpp_qsv", "yadif_cuda", "zscale", "alphasrc"] [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=scale_cuda [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=tonemap_cuda [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=tonemap_opencl [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=overlay_opencl [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -h filter=overlay_vaapi [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -hwaccels [09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Available hwaccel types: ["cuda", "vaapi", "qsv", "drm", "opencl", "vulkan"] [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: Running /usr/lib/jellyfin-ffmpeg/ffmpeg -version [09:37:01] [DBG] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: ffmpeg output: ffmpeg version 5.0.1-Jellyfin Copyright (c) 2000-2022 the FFmpeg developers built with gcc 10 (Debian 10.2.1-6) configuration: --prefix=/usr/lib/jellyfin-ffmpeg --target-os=linux --extra-libs=-lfftw3f --extra-version=Jellyfin --disable-doc --disable-ffplay --disable-ptx-compression --disable-shared --disable-libxcb --disable-sdl2 --disable-xlib --enable-lto --enable-gpl --enable-version3 --enable-static --enable-gmp --enable-gnutls --enable-chromaprint --enable-libdrm --enable-libass --enable-libfreetype --enable-libfribidi --enable-libfontconfig --enable-libbluray --enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis --enable-libdav1d --enable-libwebp --enable-libvpx --enable-libx264 --enable-libx265 --enable-libzvbi --enable-libzimg --enable-libfdk-aac --arch=amd64 --enable-libshaderc --enable-libplacebo --enable-vulkan --enable-opencl --enable-vaapi --enable-amf --enable-libmfx --enable-ffnvcodec --enable-cuda --enable-cuda-llvm --enable-cuvid --enable-nvdec --enable-nvenc libavutil 57. 17.100 / 57. 17.100 libavcodec 59. 18.100 / 59. 18.100 libavformat 59. 16.100 / 59. 16.100 libavdevice 59. 4.100 / 59. 4.100 libavfilter 8. 24.100 / 8. 24.100 libswscale 6. 4.100 / 6. 4.100 libswresample 4. 3.100 / 4. 3.100 libpostproc 56. 3.100 / 56. 3.100 [09:37:01] [INF] [1] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: FFmpeg: /usr/lib/jellyfin-ffmpeg/ffmpeg [09:37:01] [INF] [1] Emby.Server.Implementations.ApplicationHost: ServerId: 539eccee82c84952b72a3f2889929dce [09:44:43] [DBG] [91] Jellyfin.Server.Middleware.BaseUrlRedirectionMiddleware: Normalizing an URL at / [09:44:45] [INF] [87] Emby.Server.Implementations.HttpServer.WebSocketManager: WS XXX.XXX.XXX.XXX request [09:44:45] [DBG] [87] Emby.Server.Implementations.Session.SessionManager: Creating new WebSocketController [09:44:45] [DBG] [87] Emby.Server.Implementations.Session.WebSocketController: Adding websocket to session c3aba4eb45ff651e2aa46468808a1865 [09:44:45] [DBG] [87] Emby.Server.Implementations.Session.SessionWebSocketListener: Watching 1 WebSockets. [09:44:45] [DBG] [91] Emby.Server.Implementations.HttpServer.WebSocketConnection: WS XXX.XXX.XXX.XXX received message: {"MessageType": "KeepAlive", "MessageId": "00000000-0000-0000-0000-000000000000", "ServerId": null, "Data": null, "$type": "WebSocketMessage`1"} [09:44:45] [DBG] [87] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 37.7685ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId [09:44:45] [DBG] [96] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 12.584ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId [09:44:45] [DBG] [95] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 11.0469ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId [09:44:45] [DBG] [91] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 29.3379ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId [09:44:46] [DBG] [96] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 51.0718ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId [09:44:46] [DBG] [95] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 42.7033ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where playbackPositionTicks > 0 AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('febe96d1480f83839644f6760409d8bc','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f','5ebe11898e764c7252d77978ece25937','6d1caf4ded4bc0fae6431f09befbfa4b','8679d10569ec12981200c4116da3e90b') Group by PresentationUniqueKey ORDER BY LastPlayedDate DESC LIMIT 12 [09:44:46] [DBG] [93] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 54.1299ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,ForcedSortName,RunTimeTicks,Size,DateCreated,DateModified,guid,Genres,ParentId,Audio,ExternalServiceId,IsInMixedFolder,DateLastSaved,LockedFields,Studios,Tags,TrailerTypes,OriginalTitle,PrimaryVersionId,DateLastMediaAdded,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,PresentationUniqueKey,InheritedParentalRatingValue,ExternalSeriesId,Tagline,ProviderIds,Images,ProductionLocations,ExtraIds,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,SeriesPresentationUniqueKey,ShowId,OwnerId from TypedBaseItems A where ParentId=@ParentId [09:44:46] [DBG] [91] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 43.9699ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where playbackPositionTicks > 0 AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('febe96d1480f83839644f6760409d8bc','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f','5ebe11898e764c7252d77978ece25937','6d1caf4ded4bc0fae6431f09befbfa4b','8679d10569ec12981200c4116da3e90b') Group by PresentationUniqueKey ORDER BY LastPlayedDate DESC LIMIT 12 [09:44:46] [DBG] [96] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 68.4783ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where playbackPositionTicks > 0 AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('febe96d1480f83839644f6760409d8bc','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f','5ebe11898e764c7252d77978ece25937','6d1caf4ded4bc0fae6431f09befbfa4b','8679d10569ec12981200c4116da3e90b') Group by PresentationUniqueKey ORDER BY LastPlayedDate DESC LIMIT 12 [09:44:46] [DBG] [94] Jellyfin.Api.Auth.CustomAuthenticationHandler: AuthenticationScheme: CustomAuthentication was successfully authenticated. [09:44:46] [DBG] [93] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 46.1114ms. Query: select type,data,EndDate,ChannelId,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,IsInMixedFolder,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,TotalBitrate,ExtraType,ExternalId,SeriesPresentationUniqueKey,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where type=@type AND TopParentId in ('6d1caf4ded4bc0fae6431f09befbfa4b','5ebe11898e764c7252d77978ece25937','febe96d1480f83839644f6760409d8bc','8679d10569ec12981200c4116da3e90b','da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f') Group by SeriesPresentationUniqueKey ORDER BY MAX(LastPlayedDate) DESC [09:44:46] [DBG] [87] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 21.7427ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 80 [09:44:46] [DBG] [95] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 34.7076ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND TopParentId in ('da2dc360811a825da45d779762e3f66f','3722313702906d436397010f1e21181f') Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 80 [09:44:46] [DBG] [94] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 27.7962ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId,UserDatas.UserId,UserDatas.lastPlayedDate,UserDatas.playbackPositionTicks,UserDatas.playcount,UserDatas.isFavorite,UserDatas.played,UserDatas.rating from TypedBaseItems A left join UserDatas on UserDataKey=UserDatas.Key And (UserId=@UserId) where IsFolder=@IsFolder AND (played is null or played=@IsPlayed) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 80 [09:44:46] [DBG] [85] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 38.0516ms. Query: select type,data,StartDate,EndDate,ChannelId,IsMovie,IsSeries,EpisodeTitle,IsRepeat,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,ExternalServiceId,IsInMixedFolder,Tags,TrailerTypes,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,SeasonName,SeasonId,SeriesId,ProviderIds,Images,TotalBitrate,ExtraType,Artists,AlbumArtists,ExternalId,ShowId,OwnerId from TypedBaseItems A where IsFolder=@IsFolder AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND (TopParentId=@TopParentId) Group by PresentationUniqueKey ORDER BY DateCreated DESC,SortName DESC,ProductionYear DESC LIMIT 150 [09:44:46] [DBG] [85] Emby.Server.Implementations.Data.SqliteItemRepository: GetItemList query time (slow): 23.4851ms. Query: select type,data,EndDate,ChannelId,CommunityRating,IndexNumber,Width,Height,Name,Path,PremiereDate,ParentIndexNumber,ProductionYear,OfficialRating,RunTimeTicks,Size,DateModified,guid,ParentId,Audio,IsInMixedFolder,PrimaryVersionId,Album,CriticRating,IsVirtualItem,SeriesName,ProviderIds,TotalBitrate,ExtraType,ExternalId,OwnerId from TypedBaseItems A where type=@type AND CleanName=@Name [09:44:51] [DBG] [93] Emby.Server.Implementations.Session.WebSocketController: Removing websocket from session c3aba4eb45ff651e2aa46468808a1865 [09:44:51] [DBG] [93] Emby.Server.Implementations.Session.SessionManager: Disposing session controller synchronously WebSocketController [09:44:51] [DBG] [93] Emby.Server.Implementations.Session.SessionWebSocketListener: WebSocket Emby.Server.Implementations.HttpServer.WebSocketConnection is closed. [09:44:51] [INF] [93] Emby.Server.Implementations.HttpServer.WebSocketManager: WS XXX.XXX.XXX.XXX closed [09:44:57] [DBG] [93] Emby.Server.Implementations.Session.SessionWebSocketListener: Watching 0 WebSockets. ``` ### FFmpeg logs _No response_ ### Please attach any browser or client logs here _No response_ ### Please attach any screenshots here _No response_ ### Code of Conduct - [X] I agree to follow this project's Code of Conduct
OVERLORD added the bug label 2026-02-07 00:25:35 +03:00
Author
Owner

@Jacob1532 commented on GitHub (Aug 13, 2022):

Hi,
still don't understand why there is this high cpu usage.
But I rebuild everything (metadata and so on) in 10.8.3 and then it everything start working again.

@Jacob1532 commented on GitHub (Aug 13, 2022): Hi, still don't understand why there is this high cpu usage. But I rebuild everything (metadata and so on) in 10.8.3 and then it everything start working again.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/jellyfin#4100