Plex Media Server 1.41.6.9606 smart-filter DoVi boolean crash

[miaLDN]

Server Version#: Plex Media Server 1.41.6.9606
Player Version#: N/A

Searching in a Shows library with the new dovi boolean causes internal server error (500) if specified without resolution OR hdr.

This verified using Plex web GUI and PlexAPI.

Example

import os
import plexapi
from plexapi.server import PlexServer

plex = PlexServer(PLEX_URL, PLEX_TOKEN, timeout = 60)
section = plex.library.section(title='TV Shows')

# Crash - internal server error 500
m = section.search(filters = {"dovi" : True})
m = section.search(filters = {"dovi" : True, "show.year" : 2025})

# Works
m = section.search(filters = {"dovi" : True, "hdr" : True, "show.year" : 2025})
m = section.search(filters = {"dovi" : True, "resolution" : "4k", "show.year" : 2025})

Plex Media Server Log

When fails this is logged (nothing interesting logged on DEBUG or VERBOSE)

Apr 09, 2025 01:02:40.562 [140104351525688] ERROR - [Req#89b7f] SQLITE3:0x80000001, 1, no such column: grandchildren.id in "select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (1) and (media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1' and metadata_items.metadata_type=2) )"
Apr 09, 2025 01:02:40.563 [140104351525688] ERROR - Got exception from request handler: sqlite3_statement_backend::prepare: no such column: grandchildren.id for SQL: select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (1) and (media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1' and metadata_items.metadata_type=2) )

[pshanew]

This behavior can be reproduced without use of the Python API by navigating to the Library tab of a TV Shows-type library and selecting the “DOVI” advanced filter. This results in the “Something went wrong” error in the web client and logging similar to that reported by the OP.

Apr 08, 2025 20:10:59.968 [0x700007e12000] DEBUG - Request: [10.10.0.101:61359 (Allowed Network (Subnet))] GET /library/sections/15/all?type=2&sort=titleSort&episode.dovi=1&includeCollections=1&includeExternalMedia=1&includeAdvanced=1&includeMeta=1 (11 live) #55a TLS Page 0-49 GZIP
Apr 08, 2025 20:10:59.969 [0x700007e12000] ERROR - [Req#55a] SQLITE3:(nil), 1, no such column: grandchildren.id in "select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (15) and (metadata_items.metadata_type=2 and media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1') )"
Apr 08, 2025 20:10:59.970 [0x700007e12000] ERROR - Got exception from request handler: sqlite3_statement_backend::prepare: no such column: grandchildren.id for SQL: select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (15) and (metadata_items.metadata_type=2 and media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1') )
Apr 08, 2025 20:10:59.970 [0x700008330000] DEBUG - Completed: [10.10.0.101:61359] 500 GET /library/sections/15/all?type=2&sort=titleSort&episode.dovi=1&includeCollections=1&includeExternalMedia=1&includeAdvanced=1&includeMeta=1 (11 live) #55a TLS GZIP Page 0-49

[miaLDN]

@miaLDN

This verified using Plex web GUI and PlexAPI

Indeed; as I said above

[pshanew]

Ah, I did miss that. Hopefully that will end up being the most embarrassing thing I do today .

[miaLDN]

No worries!

It’s good to get replies, more chance of a DEV seeing the bug report!

Initially I got the crash in Plex web client, so I tried the PlexAPI to investigate.

[atld]

I have the same issue, this is the log I get:

Apr 11, 2025 15:05:34.950 [140580091669304] ERROR - [Req#1300] SQLITE3:0x80000001, 1, no such column: grandchildren.id in "select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (2) and (metadata_items.metadata_type=2 and media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1') )"
Apr 11, 2025 15:05:34.952 [140580091669304] ERROR - Got exception from request handler: sqlite3_statement_backend::prepare: no such column: grandchildren.id for SQL: select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (2) and (metadata_items.metadata_type=2 and media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1') )
Apr 11, 2025 15:05:34.964 [140580091669304] ERROR - [Req#1301] Unknown metadata type: folder
Apr 11, 2025 15:05:34.964 [140580091669304] ERROR - [Req#1301] SQLITE3:0x80000001, 1, no such column: grandchildren.id in "select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (2) and (metadata_items.metadata_type=2 and media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1') )"
Apr 11, 2025 15:05:34.964 [140580091669304] ERROR - Got exception from request handler: sqlite3_statement_backend::prepare: no such column: grandchildren.id for SQL: select count(*) from (select distinct(metadata_items.id) from metadata_items  join media_items on media_items.metadata_item_id=grandchildren.id  join media_parts on media_parts.media_item_id=media_items.id  left join media_streams on media_streams.media_part_id=media_parts.id  where metadata_items.library_section_id in (2) and (metadata_items.metadata_type=2 and media_streams.stream_type_id=1 and ifnull(media_streams.extra_data ->> 'ma:DOVIPresent','0')='1') )

Tried Plex Web and macOS client, same issue happens when I select DOVI is true filter.

Linuxserver.io version: 1.41.6.9685-d301f511a-ls262
Build-date: 2025-04-10T16:42:57+00:00

How can we make a bug report?

[pshanew]

@atld

How can we make a bug report?

This thread is the bug report.

[Atomatth]

Thanks for reporting!

[chris_decker08]

Does this build address the issue for you guys?

Desktop Platforms

• Windows

  • Intel - 32-bit
  • Intel - 64-bit

• Ubuntu/Debian

  • Intel - 32-bit
  • Intel - 64-bit
  • ARMv7
  • ARMv8

• RedHat/Fedora/CentOS

  • Intel - 32-bit
  • Intel - 64-bit

• FreeBSD

  • Intel - 64-bit

• macOS

  • Universal

NAS Devices

• Asustor

  • ARMv8
  • ARMv7
  • Intel - 32-bit
  • Intel - 64-bit

• Seagate

  • ARMv7
  • Intel - 64-bit

• Synology (DSM 6)

  • ARMv7_Neon (x15 Series (excluding DS115j, RS815), x16 Series (excluding DS216se), x17 Series, x18 Series, and DS414j)
  • ARMv7 (x13 Series, x14 Series (excluding DS414j), DS115j, RS815, and DS216se)
  • ARMv8 (x18 Series, x19 Series, x20 Series)
  • Intel - 32-bit (x10 Series, DS415play, and DS214play
  • Intel - 64-bit (DSM 6.0 or newer)

• Synology (DSM 7)

  • ARMv7_Neon (x15 Series (excluding DS115j, RS815), x16 Series (excluding DS216se), x17 Series, x18 Series, and DS414j)
  • ARMv7 (x13 Series, x14 Series (excluding DS414j), DS115j, RS815, and DS216se)
  • ARMv8
  • Intel - 32-bit
  • Intel - 64-bit

• QNAP

  • ARMv7 (TS-x31, and TS-x31U Series)
  • ARMv7_Neon (TS-x31+, TS-x31P, TS-x31P2, TS-x31X, and TS-x31XU Series)
  • ARMv8 (TS-x28 Series)
  • Intel - 64-bit

• Unraid

  • Intel - 64-bit

• Netgear

  • Intel - 64-bit
  • ARMv7
  • ARMv7 (RN2xx)

• Western Digital (OS 3)

  • WD MyCloud Mirror
  • WD MyCloud Mirror Gen2
  • WD MyCloud EX2100
  • WD MyCloud EX4100
  • WD MyCloud EX2 Ultra
  • WD MyCloud PR2100
  • WD MyCloud PR4100
  • WD MyCloud DL2100
  • WD MyCloud DL4100
  • WD MyCloud EX2

• Western Digital (OS 5)

  • WD MyCloud EX2 Ultra
  • WD MyCloud EX2100
  • WD MyCloud EX4100
  • WD MyCloud Mirror
  • WD MyCloud DL2100
  • WD MyCloud DL4100
  • WD MyCloud PR2100
  • WD MyCloud PR4100

[pshanew]

@chris_decker08

Does this build address the issue for you guys?

It does for me. PMS running on macOS, accessed via the hosted web app.

[miaLDN]

Thanks @chris_decker08 for the quick turn-around on this

I’m on Linux Docker container for Plex Media Server.

I did have to step-back from Beta for a week when 3rd party agents stopped working

Please don’t kill them off

[chris_decker08]

We arent killing them off but we are changing the way they work. The current plan calls for there to be overlap to give 3rd party devs time to transition.