Some Libraries w/ MP4s Won't Load Anymore

Plex Media Server
1

Server Version#: 1.19.1.2645
Player Version#: 4.22.3
Mac and Roku TV on the same Ethernet.
Plex Media Server Logs_2020-04-19_11-08-04.zip (2.5 MB)

Screen Shot 2020-04-19 at 11.03.19 AM
Screen Shot 2020-04-19 at 11.03.19 AM869×557 462 KB

2

First, turn off verbose logging. Debug logs only unless requested otherwise. Verbose logs generally capture too much data and wrap too quickly to see the issue. Reference: Reporting issues with Plex Media Server.

Second, looks like you’ve a corrupt database (search the Plex Media Server.log files for sqlite). See Repair a Corrupt Database. You can also try restoring the db if you’ve a known good backup. See Restore a Database Backed Up via ‘Scheduled Tasks.’

Apr 19, 2020 10:20:32.885 [0x70000fc73000] ERROR - SQLITE3:0x1078bdba0, 11, database corruption at line 65066 of [bf8c1b2b7a]
Apr 19, 2020 10:20:32.885 [0x70000fc73000] ERROR - SQLITE3:0x1078bdba0, 11, statement aborts at 3: [DELETE FROM 'main'.'fts4_tag_titles_segdir' WHERE level = ?] database disk image is malformed
Apr 19, 2020 10:20:32.885 [0x70000fc73000] ERROR - SQLITE3:0x1078bdba0, 11, statement aborts at 10: [update tags set parent_id=:tags_parent_id,metadata_item_id=:tags_metadata_item_id,tag=:tags_tag,key=:tags_key,tag_type=:tags_tag_type,tag_value=:tags_tag_value,user_thumb_url=:tags_use
Apr 19, 2020 10:20:32.885 [0x70000fc73000] ERROR - Exception inside transaction (inside=1) (../Library/MetadataItem.cpp:6525): sqlite3_statement_backend::loadOne: database disk image is malformed
Apr 19, 2020 10:20:32.885 [0x70000fc73000] ERROR - Exception loading item 'Mr. Blandings Builds His Dream House' from bundle: sqlite3_statement_backend::loadOne: database disk image is malformed
3

Thanks for the time you took to respond!

  1. Verbose logging was not on.

  2. I tried all the database rebuild options, finally restoring it from a Time Machine backup when I knew the database was fine. Same problem. And, can’t find something called sqlite much as I search.

This is a puzzle.

4

I just dumped the entire Plex Plugin folder and recreated my libraries. Thanks for your time, I really appreciate it.

5

Sometimes the database repair does not work and you have to re-create the libraries. It can be a pain, but glad you have things working. Cheers.

6

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