FreeBSD Bugzilla – Attachment 240493 Details for
Bug 269889
databases/sqlite3: Disabling DQS Breaks Sonarr and Emby-Server
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
Emby Log
embyserver.log (text/plain), 15.61 KB, created by
Matt
on 2023-03-01 03:43:46 UTC
(
hide
)
Description:
Emby Log
Filename:
MIME Type:
Creator:
Matt
Created:
2023-03-01 03:43:46 UTC
Size:
15.61 KB
patch
obsolete
>2023-02-28 22:38:59.387 Info Server: http/1.1 POST http://âââ10.0.0.33â:8096/emby/Sessions/Capabilities/Full?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us&reqformat=json. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36 Edg/110.0.1587.57 >2023-02-28 22:38:59.443 Info Server: http/1.1 Response 204 to âââ10.0.0.4â. Time: 57ms. http://âââ10.0.0.33â:8096/emby/Sessions/Capabilities/Full?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us&reqformat=json >2023-02-28 22:39:01.235 Info Server: http/1.1 POST http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/41025d42ea034a89558382b16c965757?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36 Edg/110.0.1587.57 >2023-02-28 22:39:01.237 Info Server: http/1.1 Response 204 to âââ10.0.0.4â. Time: 2ms. http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/41025d42ea034a89558382b16c965757?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us >2023-02-28 22:39:01.282 Error TaskManager: Error > *** Error Report *** > Version: 4.8.0.21 > 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 /config > Operating system: FreeBSD 13.1-RELEASE-p2 FreeBSD 13.1-RELEASE-p2 n245412-484f039b1d0 TRUENAS > Framework: .NET 6.0.5 > OS/Process: x64/x64 > Runtime: usr/local/lib/emby-server/system/System.Private.CoreLib.dll > Processor count: 12 > Data path: /config > Application path: /usr/local/lib/emby-server/system > SQLitePCL.pretty.SQLiteException: Error: no such column: - select A.Id from MediaItems A join AncestorIds2 on A.Id=AncestorIds2.ItemId AND AncestorId in (3) where A.Type in (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=2 limit 1), "") <> Cast(A.DateModified as Text) AND IsVirtualItem=@IsVirtualItem > 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.Server.Implementations.Library.LibraryManager.GetInternalItemIds(InternalItemsQuery query) > at MediaBrowser.Controller.Entities.Folder.QueryRecursiveForItemIds(InternalItemsQuery query) > at MediaBrowser.Controller.Entities.Folder.GetItemIdsInternal(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) > >2023-02-28 22:39:03.380 Info Server: http/1.1 POST http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36 Edg/110.0.1587.57 >2023-02-28 22:39:03.381 Info Server: http/1.1 Response 204 to âââ10.0.0.4â. Time: 1ms. http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us >2023-02-28 22:39:03.392 Error TaskManager: Error > *** Error Report *** > Version: 4.8.0.21 > 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 /config > Operating system: FreeBSD 13.1-RELEASE-p2 FreeBSD 13.1-RELEASE-p2 n245412-484f039b1d0 TRUENAS > Framework: .NET 6.0.5 > OS/Process: x64/x64 > Runtime: usr/local/lib/emby-server/system/System.Private.CoreLib.dll > Processor count: 12 > Data path: /config > Application path: /usr/local/lib/emby-server/system > SQLitePCL.pretty.SQLiteException: Error: no such column: - select A.Id from MediaItems A join AncestorIds2 on A.Id=AncestorIds2.ItemId AND AncestorId in (3) where IsFolder=@IsFolder AND ExtraType is null 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=1 limit 1), "") <> Cast(A.DateModified as Text) AND IsVirtualItem=@IsVirtualItem AND MediaType in (1) > 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.Server.Implementations.Library.LibraryManager.GetInternalItemIds(InternalItemsQuery query) > at MediaBrowser.Controller.Entities.Folder.QueryRecursiveForItemIds(InternalItemsQuery query) > at MediaBrowser.Controller.Entities.Folder.GetItemIdsInternal(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) > >2023-02-28 22:39:05.034 Info Server: http/1.1 POST http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753/Delete?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36 Edg/110.0.1587.57 >2023-02-28 22:39:05.040 Error Server: Error processing request > *** Error Report *** > Version: 4.8.0.21 > 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 /config > Operating system: FreeBSD 13.1-RELEASE-p2 FreeBSD 13.1-RELEASE-p2 n245412-484f039b1d0 TRUENAS > Framework: .NET 6.0.5 > OS/Process: x64/x64 > Runtime: usr/local/lib/emby-server/system/System.Private.CoreLib.dll > Processor count: 12 > Data path: /config > Application path: /usr/local/lib/emby-server/system > System.InvalidOperationException: System.InvalidOperationException: Cannot cancel a Task unless it is in the Running state. > at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.Cancel() > at Emby.Server.Implementations.ScheduledTasks.TaskManager.Cancel(IScheduledTaskWorker task) > at Emby.Api.ScheduledTasks.ScheduledTaskService.Any(StopScheduledTask request) > at Emby.Server.Implementations.Services.ServiceController.<>c__DisplayClass6_0.<VoidActionDelegate>b__0(Object service, Object request) > at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req) > at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, RestPath restPath, String responseContentType, CancellationToken cancellationToken) > at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, ReadOnlyMemory`1 urlString, ReadOnlyMemory`1 localPath, CancellationToken cancellationToken) > Source: Emby.Server.Implementations > TargetSite: Void Cancel() > >2023-02-28 22:39:05.041 Info Server: http/1.1 Response 500 to âââ10.0.0.4â. Time: 7ms. http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753/Delete?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us >2023-02-28 22:39:05.725 Info Server: http/1.1 POST http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753/Delete?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36 Edg/110.0.1587.57 >2023-02-28 22:39:05.726 Error Server: Error processing request > *** Error Report *** > Version: 4.8.0.21 > 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 /config > Operating system: FreeBSD 13.1-RELEASE-p2 FreeBSD 13.1-RELEASE-p2 n245412-484f039b1d0 TRUENAS > Framework: .NET 6.0.5 > OS/Process: x64/x64 > Runtime: usr/local/lib/emby-server/system/System.Private.CoreLib.dll > Processor count: 12 > Data path: /config > Application path: /usr/local/lib/emby-server/system > System.InvalidOperationException: System.InvalidOperationException: Cannot cancel a Task unless it is in the Running state. > at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.Cancel() > at Emby.Server.Implementations.ScheduledTasks.TaskManager.Cancel(IScheduledTaskWorker task) > at Emby.Api.ScheduledTasks.ScheduledTaskService.Any(StopScheduledTask request) > at Emby.Server.Implementations.Services.ServiceController.<>c__DisplayClass6_0.<VoidActionDelegate>b__0(Object service, Object request) > at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req) > at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, RestPath restPath, String responseContentType, CancellationToken cancellationToken) > at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, ReadOnlyMemory`1 urlString, ReadOnlyMemory`1 localPath, CancellationToken cancellationToken) > Source: Emby.Server.Implementations > TargetSite: Void Cancel() > >2023-02-28 22:39:05.726 Info Server: http/1.1 Response 500 to âââ10.0.0.4â. Time: 1ms. http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/d15b3f9fc313609ffe7e49bd1c74f753/Delete?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us >2023-02-28 22:39:06.561 Info Server: http/1.1 POST http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/41025d42ea034a89558382b16c965757?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36 Edg/110.0.1587.57 >2023-02-28 22:39:06.561 Info Server: http/1.1 Response 204 to âââ10.0.0.4â. Time: 1ms. http://âââ10.0.0.33â:8096/emby/ScheduledTasks/Running/41025d42ea034a89558382b16c965757?X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=e2294fde-0891-41e7-a98e-979e6a311be4&X-Emby-Client-Version=4.8.0.21&X-Emby-Language=en-us >2023-02-28 22:39:06.565 Error TaskManager: Error > *** Error Report *** > Version: 4.8.0.21 > 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 /config > Operating system: FreeBSD 13.1-RELEASE-p2 FreeBSD 13.1-RELEASE-p2 n245412-484f039b1d0 TRUENAS > Framework: .NET 6.0.5 > OS/Process: x64/x64 > Runtime: usr/local/lib/emby-server/system/System.Private.CoreLib.dll > Processor count: 12 > Data path: /config > Application path: /usr/local/lib/emby-server/system > SQLitePCL.pretty.SQLiteException: Error: no such column: - select A.Id from MediaItems A join AncestorIds2 on A.Id=AncestorIds2.ItemId AND AncestorId in (3) where A.Type in (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=2 limit 1), "") <> Cast(A.DateModified as Text) AND IsVirtualItem=@IsVirtualItem > 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.Server.Implementations.Library.LibraryManager.GetInternalItemIds(InternalItemsQuery query) > at MediaBrowser.Controller.Entities.Folder.QueryRecursiveForItemIds(InternalItemsQuery query) > at MediaBrowser.Controller.Entities.Folder.GetItemIdsInternal(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) >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 269889
: 240493 |
240494
|
240620