Jump to content

Thumbmail extraction failure

NoksC

By NoksC
in FreeBSD

 Share

Recommended Posts

NoksC

NoksC   0

Posted
Posted

Hello,

 

I use Emby server on TrueNas work fine except for thumbail image extraction, here is the error log :

  

2023-03-22 20:42:49.435 Info Server: http/1.0 POST http://192.168.1.244:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753?X-Emby-Client=Emby Web&X-Emby-Device-Name=Firefox&X-Emby-Device-Id=89dac3b6-702c-4cf0-ba61-7536aef792ab&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=fr. UserAgent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0
2023-03-22 20:42:49.435 Info Server: http/1.0 Response 204 to host2. Time: 1ms. http://192.168.1.244:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753?X-Emby-Client=Emby Web&X-Emby-Device-Name=Firefox&X-Emby-Device-Id=89dac3b6-702c-4cf0-ba61-7536aef792ab&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=fr
2023-03-22 20:42:49.437 Error TaskManager: Error
	*** Error Report ***
	Version: 4.7.11.0
	Command line: /usr/local/lib/emby-server/system/EmbyServer.dll -os freebsd -ffdetect /usr/local/lib/emby-server/bin/ffdetect -ffmpeg /usr/local/lib/emby-server/bin/ffmpeg -ffprobe /usr/local/lib/emby-server/bin/ffprobe -programdata /var/db/emby-server
	Operating system: FreeBSD 13.1-RELEASE-p7 FreeBSD 13.1-RELEASE-p7 n245418-79e75956dbb TRUENAS
	Framework: .NET 6.0.5
	OS/Process: x64/x64
	Runtime: usr/local/lib/emby-server/system/System.Private.CoreLib.dll
	Processor count: 8
	Data path: /var/db/emby-server
	Application path: /usr/local/lib/emby-server/system
	SQLitePCL.pretty.SQLiteException: Error: no such column:  - select A.Id from MediaItems A where IsFolder=@IsFolder AND ((select StartPositionTicks from Chapters3 where Chapters3.ItemId=A.Id and imagepath is null limit 1) not null) AND Coalesce((select Value from ItemExtraData where ItemExtraData.ItemId=A.Id and ExtradataTypeId=2 limit 1), "") <> Cast(A.DateModified as Text) AND IsVirtualItem=@IsVirtualItem AND MediaType=@MediaTypes AND Id in (select itemId from AncestorIds2 where AncestorId in (3))
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
	   at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Func`5 rowReaderFn, Boolean singleResult, String methodName)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.GetInternalItemIdsList(InternalItemsQuery query)
	   at Emby.Providers.MediaInfo.ChapterImagesTask.GetAllItemIdsToRefresh(Boolean extractImages)
	   at Emby.Providers.MediaInfo.ChapterImagesTask.Execute(CancellationToken cancellationToken, IProgress`1 progress)
	   at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
	Source: SQLitePCL.pretty
	TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.String ByRef)

 

Any help would be apreciated.

Link to comment
Share on other sites
NoksC

NoksC   0

Posted
  • Author
Posted

Yeah, i readed it, but i dont understand why sudently my db are f..ked. No server interruption ...

 

Sorry for my bad english.

Link to comment
Share on other sites
GrimReaper

GrimReaper   3294

Posted
Posted

 

5 minutes ago, NoksC said:

but i dont understand why sudently my db are f..ked.

I guess that'd be hard to trace, but based on:

13 minutes ago, NoksC said: 
SQLitePCL.pretty.SQLiteException: Error: no such column

I'd say you have db issues. 

Try runing first three steps (remove locks/check integrity/recover) one by one, see if you'll still get errors. 

Link to comment
Share on other sites
NoksC

NoksC   0

Posted
  • Author
Posted (edited)

I just tried the first step ( remove locks ). Same issue after that.

 

So as i said, i started with a fresh library.db directly after, to tired to try things, my db was young so it is not a big deal.

Edited by NoksC
Link to comment
Share on other sites
NoksC

NoksC   0

Posted
  • Author
Posted

Sorry but i have to reopen this issue, started with a fresh library.db and the same error on the same task .. :

  

2023-03-22 22:26:44.093 Info Server: http/1.0 POST http://192.168.1.244:8096/emby/ScheduledTasks/Running/41025d42ea034a89558382b16c965757?X-Emby-Client=Emby Web&X-Emby-Device-Name=Firefox&X-Emby-Device-Id=89dac3b6-702c-4cf0-ba61-7536aef792ab&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=fr. UserAgent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0
2023-03-22 22:26:44.095 Info Server: http/1.0 Response 204 to host1. Time: 2ms. http://192.168.1.244:8096/emby/ScheduledTasks/Running/41025d42ea034a89558382b16c965757?X-Emby-Client=Emby Web&X-Emby-Device-Name=Firefox&X-Emby-Device-Id=89dac3b6-702c-4cf0-ba61-7536aef792ab&X-Emby-Client-Version=4.7.11.0&X-Emby-Language=fr
2023-03-22 22:26:44.105 Error TaskManager: Error
	*** Error Report ***
	Version: 4.7.11.0
	Command line: /usr/local/lib/emby-server/system/EmbyServer.dll -os freebsd -ffdetect /usr/local/lib/emby-server/bin/ffdetect -ffmpeg /usr/local/lib/emby-server/bin/ffmpeg -ffprobe /usr/local/lib/emby-server/bin/ffprobe -programdata /var/db/emby-server
	Operating system: FreeBSD 13.1-RELEASE-p7 FreeBSD 13.1-RELEASE-p7 n245418-79e75956dbb TRUENAS
	Framework: .NET 6.0.5
	OS/Process: x64/x64
	Runtime: usr/local/lib/emby-server/system/System.Private.CoreLib.dll
	Processor count: 8
	Data path: /var/db/emby-server
	Application path: /usr/local/lib/emby-server/system
	SQLitePCL.pretty.SQLiteException: Error: no such column:  - select A.Id from MediaItems A where type=8 AND RunTimeTicks>=@MinRunTimeTicks AND ((Select Id from MediaItems where AlbumId=A.AlbumId and PresentationUniqueKey <> A.PresentationUniqueKey limit 1) not NULL) AND ((select StartPositionTicks from Chapters3 where Chapters3.ItemId=A.Id and MarkerType in (1) limit 1) is null) AND Coalesce((select Value from ItemExtraData where ItemExtraData.ItemId=A.Id and ExtradataTypeId=1 limit 1), "") <> Cast(A.DateModified as Text) AND IsVirtualItem=@IsVirtualItem AND Id in (select itemId from AncestorIds2 where AncestorId in (5))
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
	   at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Func`5 rowReaderFn, Boolean singleResult, String methodName)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.GetInternalItemIdsList(InternalItemsQuery query)
	   at Emby.Providers.Markers.MarkerScheduledTask.Execute(CancellationToken cancellationToken, IProgress`1 progress)
	   at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
	Source: SQLitePCL.pretty
	TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.String ByRef)

 

Link to comment
Share on other sites
Luke Emby Team

Luke   37068

Posted
Posted

Did you by any chance go back and forth between 4.8 beta and 4.7 stable ? These kinds of database errors are typically what you see after doing that.

Link to comment
Share on other sites
Luke Emby Team

Luke   37068

Posted
Posted

Ok I’m not sure of the issue but it should be resolved in the upcoming 4.8 server release. Thanks.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...