generate video preview thumbnails 4.8.11

[amateurgod 33]

have been having the scheduled task to generate video preview thumbnails fail since updating to 4.8.11 this is the error that it shows when i click on the dashboard entry for task failed 
 

Quote

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.SetItemExtradata(IDatabaseConnection db, Int64 itemId, Int64 extradataTypeId, String value) at Emby.Server.Implementations.Data.SqliteItemRepository.LogThumbnailImageExtractionFailure(Int64 itemId, Int64 dateModifiedUnixTimeSeconds) at Emby.Providers.MediaInfo.ChapterImagesTask.Execute(CancellationToken cancellationToken, IProgress`1 progress) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

 

[Luke 42077]

Hi there, please attach the Emby server log from when the problem occurred:

How to Report a Problem

Thanks!

 

[amateurgod 33]

53 minutes ago, Luke said:

Hi there, please attach the Emby server log from when the problem occurred:

How to Report a Problem

Thanks!

 

2025-03-24 18:20:13.517 Info QuickImageSeriesExtractor: ProcessRun 'quick-extract-imageseries' Process exited with code 0 - Succeeded
2025-03-24 18:20:13.762 Info Server: http/1.1 GET http://host3/emby/videos/92453/hls1/main/594.ts?PlaySessionId=d24e7044d6ad466f9cfcd8810e3859b4. Source Ip: host7, Accept=*/*, Host=host3, User-Agent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36, Accept-Encoding=gzip, br, Accept-Language=nb-NO,nb;q=0.9,no;q=0.8,en;q=0.7,en-US;q=0.6,nn;q=0.5, Referer=host8, X-Real-IP=host7, X-Forwarded-For=host9, cf-ray=92582e69da4d630a-HAM, sec-ch-ua-mobile=?0, priority=u=1, i, cf-ipcountry=NO, x-forwarded-proto=https, cf-visitor={"scheme":"https"}, sec-fetch-dest=empty, sec-fetch-mode=cors, cf-connecting-ip=158.112.20.147, sec-fetch-site=same-origin, cdn-loop=cloudflare; loops=1, sec-ch-ua-platform="Windows", sec-ch-ua="Chromium";v="134", "Not:A-Brand";v="24", "Google Chrome";v="134"
2025-03-24 18:20:14.176 Error ChapterImagesTask: Error refreshing thumbnails for /media/data/tv/Happy Valley (2014) [tvdbid-280537]/Season 02/Happy Valley (2014) - S02E06 - Episode 6 [Bluray-1080p][DTS 2.0][x264]-SHORTBREHD.mkv
	*** Error Report ***
	Version: 4.8.11.0
	Command line: /opt/emby-server/system/EmbyServer.dll -programdata /var/lib/emby -ffdetect /opt/emby-server/bin/ffdetect -ffmpeg /opt/emby-server/bin/ffmpeg -ffprobe /opt/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-deb_{version}_amd64.deb
	Operating system: Linux version 6.8.0-55-generic (buildd@lcy02-amd64-095) (x86_64-linux-gnu-gcc-13 (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, GNU ld (GNU Binutils for Ubunt
	Framework: .NET 6.0.36
	OS/Process: x64/x64
	Runtime: opt/emby-server/system/System.Private.CoreLib.dll
	Processor count: 16
	Data path: /var/lib/emby
	Application path: /opt/emby-server/system
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.InsertChapters(Int64 itemId, List`1 chapters, IDatabaseConnection db)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveChapters(Int64 itemId, Boolean clearExtractionFailureResult, List`1 chapters)
	   at Emby.Providers.MediaInfo.ThumbnailGenerator.RefreshThumbnailImages(Video item, MediaStream videoStream, LibraryOptions libraryOptions, IDirectoryService directoryService, List`1 chapters, Boolean extractImages, Boolean saveChapters, CancellationToken cancellationToken)
	   at Emby.Providers.MediaInfo.ChapterImagesTask.Execute(CancellationToken cancellationToken, IProgress`1 progress)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)
	
2025-03-24 18:20:14.189 Error TaskManager: Error
	*** Error Report ***
	Version: 4.8.11.0
	Command line: /opt/emby-server/system/EmbyServer.dll -programdata /var/lib/emby -ffdetect /opt/emby-server/bin/ffdetect -ffmpeg /opt/emby-server/bin/ffmpeg -ffprobe /opt/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-deb_{version}_amd64.deb
	Operating system: Linux version 6.8.0-55-generic (buildd@lcy02-amd64-095) (x86_64-linux-gnu-gcc-13 (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, GNU ld (GNU Binutils for Ubunt
	Framework: .NET 6.0.36
	OS/Process: x64/x64
	Runtime: opt/emby-server/system/System.Private.CoreLib.dll
	Processor count: 16
	Data path: /var/lib/emby
	Application path: /opt/emby-server/system
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SetItemExtradata(IDatabaseConnection db, Int64 itemId, Int64 extradataTypeId, String value)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.LogThumbnailImageExtractionFailure(Int64 itemId, Int64 dateModifiedUnixTimeSeconds)
	   at Emby.Providers.MediaInfo.ChapterImagesTask.Execute(CancellationToken cancellationToken, IProgress`1 progress)
	   at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

 

[amateurgod 33]

full log 

embyserver-63878457600.txt

[Happy2Play 9780]

Seems related to this file as it can't be probed.

Quote

file:/media/data/tv/Happy Valley (2014) [tvdbid-280537]/Season 02/Happy Valley (2014) - S02E06 - Episode 6 [Bluray-1080p][DTS 2.0][x264]-SHORTBREHD.mkv: No such file or directory

 

 

[amateurgod 33]

7 minutes ago, Happy2Play said:

Seems related to this file as it can't be probed.

 

yeah i think ive just found the issue, my media directory is set to 770 with everything under the media group, however somehow group ownership got broke and while ls -la showed them belonging to the media group with 660, about half the files were only readable to user and not group, but a ``chown -R :media /media`` seems to have fixed the visibility at least, going to test and see if that was the issue with the thumbnails too, i have a feeling something may have gone funky with the perms on one of the disks during mounting after the last reboot