+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: Troubleshooting (https://forum.jellyfin.org/f-troubleshooting)
+--- Thread: SOLVED: Bizarre sqlite errors when scanning for media (/t-solved-bizarre-sqlite-errors-when-scanning-for-media)
Bizarre sqlite errors when scanning for media - Yankees4life - 2025-01-20
I'm not too sure whats causing these errors. I got a large library on hand and while autoscan and shoko goes to work sending items to update, this happens
Code:
[12:56:59] [WRN] [117] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:56:59] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:56:59] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:56:59] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:56:59] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [WRN] [171] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [WRN] [171] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [INF] [117] Trakt.Helpers.LibraryManagerEventsHelper: Timer elapsed - processing queued items
[12:57:00] [INF] [117] Trakt.Helpers.LibraryManagerEventsHelper: No events... stopping queue timer
[12:57:00] [ERR] [171] MediaBrowser.MediaEncoding.Encoder.MediaEncoder: I-frame image extraction failed, will attempt standard way. Input: file:"/media/tv/anime/hd/Strike the Blood։ Kingdom of the Valkyria [anidb-11136]/Strike the Blood։ Kingdom of the Valkyria - EP02 - Volume 2 [1080p] [HEVC] [10bit] [BluRay] [SUB] [Anime Time] [6B29D346.mkv"
MediaBrowser.Common.FfmpegException: ffmpeg image extraction timed out for file:"/media/tv/anime/hd/Strike the Blood։ Kingdom of the Valkyria [anidb-11136]/Strike the Blood։ Kingdom of the Valkyria - EP02 - Volume 2 [1080p] [HEVC] [10bit] [BluRay] [SUB] [Anime Time] [6B29D346.mkv" after 10000ms
---> System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Diagnostics.Process.WaitForExitAsync(CancellationToken cancellationToken)
at MediaBrowser.Common.Extensions.ProcessExtensions.WaitForExitAsync(Process process, TimeSpan timeout)
at MediaBrowser.MediaEncoding.Encoder.MediaEncoder.ExtractImageInternal(String inputPath, String container, MediaStream videoStream, Nullable`1 imageStreamIndex, Nullable`1 threedFormat, Nullable`1 offset, Boolean useIFrame, Nullable`1 targetFormat, Boolean isAudio, CancellationToken cancellationToken)
--- End of inner exception stack trace ---
at MediaBrowser.MediaEncoding.Encoder.MediaEncoder.ExtractImageInternal(String inputPath, String container, MediaStream videoStream, Nullable`1 imageStreamIndex, Nullable`1 threedFormat, Nullable`1 offset, Boolean useIFrame, Nullable`1 targetFormat, Boolean isAudio, CancellationToken cancellationToken)
at MediaBrowser.MediaEncoding.Encoder.MediaEncoder.ExtractImage(String inputFile, String container, MediaStream videoStream, Nullable`1 imageStreamIndex, MediaSourceInfo mediaSource, Boolean isAudio, Nullable`1 threedFormat, Nullable`1 offset, Nullable`1 targetFormat, CancellationToken cancellationToken)
[12:57:00] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:00] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:01] [INF] [171] Shokofin.Providers.EpisodeProvider: Found episode Fireteam E601 (File=25032,Episode=32894,Season=1572,ExtraSeasons=[],Group=2255)
[12:57:01] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:01] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:02] [INF] [78] Shokofin.Providers.ImageProvider: Getting 0 images for episode Fireteam E601 (Episode=32894,Language=en)
[12:57:02] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:02] [WRN] [56] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:02] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:02] [WRN] [30] Emby.Server.Implementations.Data.SqliteItemRepository: Undefined BaseItemKind to Type mapping: Program
[12:57:02] [INF] [117] Jellyfin.Plugin.PlaybackReporting.EventMonitorEntryPoint: Processing playback tracker : 081ab0e7d898c96c23c315f6c29ac864095b2edc-18c3bcd52d9946679567fb7e90a57752-2e6640cfc49a600187d0928404d6c255
[12:57:02] [INF] [117] Shokofin.Sync.UserDataSyncManager: Import user data for video Fireteam E601. (User=18c3bcd5-2d99-4667-9567-fb7e90a57752,File=25032,Series=1572,Local=True,Remote=False,InSync=True)RE: Bizarre sqlite errors when scanning for media - TheDreadPirate - 2025-01-20
I'm assuming the way autoscan and/or shoko is pushing updates to Jellyfin is causing the "Program" type errors.
The ffmpeg errors are possibly due to too much simultaneous activity. The image extraction hits the timeout limit.
RE: Bizarre sqlite errors when scanning for media - Yankees4life - 2025-01-20
(2025-01-20, 07:28 PM)TheDreadPirate Wrote: I'm assuming the way autoscan and/or shoko is pushing updates to Jellyfin is causing the "Program" type errors.
The ffmpeg errors are possibly due to too much simultaneous activity. The image extraction hits the timeout limit.
I have a hunch thats the case. Maybe I'll put some exceptions in the autoscan configs in order to ignore some files...