mirror of
https://github.com/jellyfin/jellyfin.git
synced 2026-07-16 05:43:54 +03:00
Progress bar not working for remote clients when trying to play all- SQLite : Expression tree is too large- for all music or big playlist #6089
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @LordJABA on GitHub (Jul 5, 2024).
Please describe your bug
Progress bar and "now playing" is broken (not showing) when casting to remote device(browser,mpv-shim and android tested)
error on the client side:
in server logs:
Reproduction Steps
Jellyfin Version
10.9.0
if other:
10.9.7
Environment
Jellyfin logs
FFmpeg logs
No response
Please attach any browser or client logs here
Please attach any screenshots here
No response
Code of Conduct
@jellyfin-bot commented on GitHub (Jul 5, 2024):
Hi, it seems like your issue report has the following item(s) that need to be addressed:
This is an automated message, currently under testing. Please file an issue here if you encounter any problems.
@SinisterMinister commented on GitHub (Jul 11, 2024):
Also encountering this issue with playing in the Windows client. Seems to prevent Jellyfin of keeping track of next up for large shows.
@breakid commented on GitHub (Sep 3, 2024):
I discovered this issue when I noticed items missing from my History in the Playback Reporting plugin.
Additional Impact: Tracing through the code a bit, I noticed the exception (which happens inside the
UpdateNowPlayingItem()method called from theOnPlaybackStart()method) has the unfortunate side effect of preventing theVideoPlaybackevent from being published. This means that affected media items do not appear in the Activity view or get logged to the Playback Reporting database.It looks like the problem is how the SQL query is generated in
GetItemList(). According to Limits In SQLite:Somehow, the query is ending up with more than 1000 expressions; unfortunately, without a debugger or a log of the actual query it generates, I'm not sure why the query ends up being so large.
If I get a chance, I'll try to log a query.
@breakid commented on GitHub (Oct 1, 2024):
I finally managed to log one of the problematic queries:
@LordJABA and @SinisterMinister I've opened a PR that solved the problem I was having. Since the cause seems to be the same, hopefully it'll fix your problems as well.
@jellyfin-bot commented on GitHub (Jan 29, 2025):
This issue has gone 120 days without an update and will be closed within 21 days if there is no new activity. To prevent this issue from being closed, please confirm the issue has not already been fixed by providing updated examples or logs.
If you have any questions you can use one of several ways to contact us.
@breakid commented on GitHub (Feb 12, 2025):
PR #12798 refactored much of the SQLite code, including entirely removing the file I patched in my PR. I tested the playlist that had previously failed to register in the Playback History this evening, and it worked as expected (using the latest 10.10.5 release).
I believe this issue may be resolved.