Jump to content

All Activity

This stream auto-updates

  1. Past hour
  2. 17732

    About updating to version 4.10.0.40

    I had AI analyze the logs, and it really is an Emby issue. Investigation Conclusion The logs (Emby 4.10.0.40, Synology, with the media library located on the large-capacity /volume4 storage) have clearly identified the problem. This is a query-path defect in the new full-text search (FTS) introduced in the 4.10 release. It is not an environment configuration issue. The Difference Between the Two Search Paths (Confirmed by the Logs) 1. Default Search (Fast, ~150–250 ms) When entering a search keyword, the frontend calls a lightweight interface (/emby/ItemTypes + /Items without a type filter). For example, searching for “生化危机” (Resident Evil) takes only about 148–155 ms. 2. Clicking the Type Filter (Slow, 2–19.7 seconds) After clicking the type filter on the right side (Movie / Series / Season / Episode), the request changes to: IncludeItemTypes=Movie&SearchTerm=... The server then generates SQL like this: from mediaitems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm where A.Type=5 AND EXISTS (SELECT 1 FROM AncestorIds2 ...) Group by A.PresentationUniqueKey ORDER BY Rank ASC LIMIT 50 The logs show that queries of this type take an extremely long time. For the same “美国队长” (Captain America) movie search, the query repeatedly took approximately: * 19,368 ms * 19,371 ms * 19,383 ms * 19,426 ms * 19,440 ms * 19,445 ms * 19,775 ms The slowest query took 39,035 ms. The execution time is highly consistent and reproducible, which indicates that this is not an occasional system-load issue, but rather an inappropriate query plan caused by the combination of: * FTS matching * Type filtering * Per-row AncestorIds2 subqueries * Rank sorting Why the SQLite Errors in the Logs Are Not the Root Cause There are 97 occurrences of the following SQLite error in the logs: Sqlite: 9 - statement aborts ... interrupted This is a symptom, not the cause. The query is still running when the user gets tired of waiting and leaves the page or switches to another search/filter. The client then disconnects, and Emby cancels the still-running query. This is why the logs also contain messages such as: Response completed after client disconnected Therefore, the SQLite interruption messages are a consequence of the slow query rather than the original problem. Why This Does Not Happen in 4.9 There was no such problem with 4.9. The 4.10 series rewrote the search implementation and introduced the fts_search9 (FTS5 full-text index) search path. The type-filtered search happens to hit the worst possible query-plan combination involving FTS matching + type filtering + per-row AncestorIds2 subqueries + Rank sorting. This is a regression introduced in Emby 4.10.0.40. Recommendations (in Priority Order) 1. Upgrade to the Latest 4.10.x Beta The FTS search has continued to receive optimizations in subsequent versions of the 4.10 series. If the latest version is still slow, I recommend temporarily reverting to the 4.9 stable version. 2. Run the “Optimize Database” Scheduled Task Go to: Dashboard → Scheduled Tasks → Optimize Database It is recommended to run it manually once. This performs VACUUM + ANALYZE, which allows the SQLite query optimizer to recalculate statistics and potentially choose a better query execution plan. For this type of slow query, it may significantly improve performance. 3. Report the Issue to Emby Please provide the slow-query section beginning with “query time (slow 6x)”, including the approximately 19.7-second SQL query shown above. This is the information the Emby developers need most to investigate the problem. 4. Temporary Workarounds After searching, directly open the desired item from the default search results and avoid using the type filters on the right. Alternatively, enter the corresponding media library and use its advanced filtering instead of the global search type categories.
  3. HawkXP71

    Errors from TheAudioDB

    Lately Im getting tons of errors in my log 026-09-27 20:58:29.701 Error App: Error in TheAudioDB *** Error Report *** Version: 4.10.0.40 Command line: C:\Emby-Server\system\EmbyServer.dll -service Operating system: Microsoft Windows 10.0.22631 OS/Process: x64/x64 Framework: .NET 8.0.30 Runtime: C:/Emby-Server/system/System.Private.CoreLib.dll Processor count: 20 Data path: C:\Emby-Server\programdata Application path: C:\Emby-Server\system MediaBrowser.Model.Net.HttpException: MediaBrowser.Model.Net.HttpException: NotFound at Emby.Server.Implementations.HttpClientManager.CoreHttpClientManager.SendAsyncInternal(HttpRequestOptions options, String httpMethod) at Emby.Server.Implementations.HttpClientManager.BaseHttpClientManager.SendAsync(HttpRequestOptions options, String httpMethod) at AudioDb.AudioDbArtistProvider.EnsureArtistInfo(String musicBrainzId, IDirectoryService directoryService, CancellationToken cancellationToken) at AudioDb.AudioDbArtistProvider.GetMetadata(RemoteMetadataFetchOptions`1 options, CancellationToken cancellationToken) at Emby.Providers.Manager.MetadataService`2.ExecuteRemoteProviders(MetadataResult`1 temp, LibraryOptions libraryOptions, String logName, TIdType id, IRemoteMetadataProvider`2[] providers, MetadataRefreshOptions options, CancellationToken cancellationToken) Source: Emby.Server.Implementations TargetSite: Void MoveNext() Any ideas?
  4. In this version, the default popular search results show up quickly, but when I click on the options on the right like shows, seasons, episodes, or movies, it just keeps loading for a long time before showing results. I remember this wasn’t a problem in version 4.9. It only appeared in version 4.10.0.40, and it seriously affects the efficiency of searching for things. ...
  5. Today
  6. I am now on Version 4.10.0.40. I don't know what I was on last month for example, but it was the 'latest' at the time.
  7. HI, please let me know if the tvdb plugin update 1.6.7 resolves this. Thanks.
  8. Thanks for sharing.
  9. From what version number to what version number?
  10. Luke

    Simplify ass/ssa subtitles.

    Thanks for sharing.
  11. Luke

    Can't sing in

    Hi, what caused everything to get erased?
  12. I am just out of ideas on what to try here. Plugins and external systems all gone. The system has gone from something I don't think about to something that needs regular restarts and I have no known reason for that. It all started with the new release, so I just want to roll that back to see if it is stable again for a week for example. If it is stable, then it is the new release that has an issue with my config, and I am running out of time before I leave my system for 7 weeks so need it stable before then. So can I do this and not break anything ? But then, I don't know what version I was on now - what was the latest release before this new version ?
  13. Luke

    Seek bar icon feature?

    Not currently, but that’s potentially doable.
  14. Do you have remote access restricted?
  15. No but there’s no reason to do that.
  16. Hi, right now this looks like an issue in the dotnet runtime where it throws an error when we try to list directory contents. More investigation is needed to see if it can be avoided somehow.
  17. Intro detection and video thumbnails can also run during library scans, it just depends what settings you're using on your libraries. It's not uncommon for scans to take a long time if for example you have it set to refresh metadata every so often.
  18. I am still conducting further testing on this issue My original plan was to use STRM to map the directory path of the cloud storage to the local, and then use it locally The STEM file contains a URL for direct playback. I have found exactly the same content. When I move files from the cloud storage to the NAS local. Just the path prefix has changed, one is 115_cedia and the other is media. The content of the subsequent path is exactly the same. At this point, the function of automatically generating the cover for the emby is completely normal
  19. Deihmos

    ComSkipper ... A Emby Plugin that skips commercials

    The donation requirement ended a few years ago. The file downloadable from the site is the donator build.
  20. mario1230

    Seek bar icon feature?

    Is it something that we can customize between films or link it to certain genre tags?
  21. TMCsw

    ComSkipper ... A Emby Plugin that skips commercials

    Yep, not much info about this for the last 2-3 years it does seem donations are no longer needed… Help file Windows Binaries Easy to compile source for Linux But do keep in mind this is a third/fourth party solution and is not supported by Emby (but works great).
  22. Yesterday
  23. alex.5344@hotmail.com

    Can't sing in

    Mine and im paying for it Everything got erased i only have the app but can get it to work now
  24. tara.b

    Next Episode Pop-up

    Is there any way to resize the next episode pop-up on Roku? I don’t need a preview of the next episode, just a button to start the episode. The current pop-up is blindingly bright compared to the show, plus it starts a bit early obscuring the last minute or two of the show and any captions. I just want an unobstructive button. As a bandaid, I’ve disabled it completely, but it’s multiple clicks to get to the next episode via the bottom menu. I like the feature, just want it to be less obnoxious.
  25. Just wanted to check back on this. What this the correct way to upgrade? Thanks, HS
  26. Wynter

    HW transcoding stopped working after 4.9.3.0 update

    It is fixed for me in the newest 4.11.0.4 beta...
  27. @Luke- Were there database changes that will cause me an issue if I pull the previous docker version ?
  28. 3.5.55 still has the same issues.
  1. Load more activity
×
×
  • Create New...