Plex media scanner crashes saying a database table is missing

Plex Media Server
1

Server Version#: 1.42.2.10102-50deb00d9
Player Version#: N/A
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

Sep 06, 2025 04:36:43.582 [138806783286016] INFO - Plex Media Scanner v1.42.2.10102-50deb00d9 - unknown Dell Inc. WAT unknown - build: linux-x86_64 - GMT 00:00
Sep 06, 2025 04:36:43.582 [138806783286016] INFO - Linux version: 6.14.8-2-pve (#1 SMP PREEMPT_DYNAMIC PMX 6.14.8-2 (2025-07-22T10:04Z)), language: en-US
Sep 06, 2025 04:36:43.585 [138806783286016] INFO - Processor: 24-core AMD EPYC 7502P 32-Core Processor
Sep 06, 2025 04:36:43.585 [138806783286016] INFO - /usr/lib/plexmediaserver/Plex Media Scanner --analyze-deeply --section 1 --log-file-suffix Analysis
Sep 06, 2025 04:36:43.582 [138806783794944] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.39.4, threadsafe=1
Sep 06, 2025 04:36:43.661 [138806783794944] ERROR - SQLITE3:0x80000001, 1, no such column: ls.content_changed_at in “SELECT ls.id,ls.library_id,ls.name,ls.name_sort,ls.section _type,ls.language,ls.agent,ls.scanner,ls.user_thumb_url,ls.user_art_url,ls.user_theme_music_url,ls.created_at,ls.updated_at,ls.scanned_at,ls.user_fields,ls.query_ xml,ls.query_type,ls.uuid,ls.changed_at,ls.content_changed_at,ls.metadata_agent_provider_group_id FROM library_sections ls WHERE ls.id=:C1 LIMIT :C2”

2

Which is odd since the column seems to exist…

sqlite> .schema library_sections
CREATE TABLE IF NOT EXISTS "library_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_id" integer, "name" varchar(255), "name_sort" varchar(255) COLLATE NOCASE, "section_type" integer, "language" varchar(255), "agent" varchar(255), "scanner" varchar(255), "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_theme_music_url" varchar(255), "public" boolean, "created_at" dt_integer(8), "updated_at" dt_integer(8), "scanned_at" dt_integer(8), "display_secondary_level" boolean, "user_fields" varchar(255), "query_xml" text, "query_type" integer, "uuid" varchar(255), "changed_at" integer(8) DEFAULT 0, 'content_changed_at' integer(8) default '0', 'metadata_agent_provider_group_id' integer);
CREATE INDEX "index_library_sections_on_name_sort" ON "library_sections" ("name_sort" collate nocase);
CREATE INDEX "index_library_sections_on_name" ON "library_sections" ("name" );
CREATE INDEX "index_library_sections_on_changed_at" ON "library_sections" ("changed_at" );
CREATE INDEX 'index_library_sections_on_metadata_agent_provider_group_id' ON 'library_sections' ('metadata_agent_provider_group_id');
3

Somebody mixed up their quotes.

4

Looks like I was just missing the ENV vars. The app SHOULD NOT CRASH and SHOULD present a related error message. This is a very mature application…

export PLEX_MEDIA_SERVER_APPLICATION_SUPPORT_DIR="/var/lib/plexmediaserver/Library/Application Support"
5

@phibs

Which distro please ?
Native or docker ?

1 Like
6

LXC/native.

PRETTY_NAME="Ubuntu 24.04.3 LTS"
NAME="Ubuntu"
VERSION_ID="24.04"
VERSION="24.04.3 LTS (Noble Numbat)"

It was the missing ENV var. Maybe the command(s) should mention this, or assume the default ?

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.