I have two recent issues that I have been unable to figure out. They seem slightly related and started happening around the same time.
New additions to my music and movies libraries are not being ‘found’ by Plex. I see them being scanned via the little Activity button but they haven’t been getting added to my libraries for a week or so.
Due to my impatience I have ended up with three identical Music libraries. I have tried removing two via the side bar then the three dots as well as through Settings > Manage > Libraries. About 1 second after I delete one, it pops right back up.
Any help would be greatly appreciated. I am just about to ready to delete this Plex container and start over with a fresh database in the official Plex container because I haven’t been able to figure this out.
Server Version#: 1.22.2.4276 (latest linuxserver.io Docker container)
Apr 02, 2021 17:13:06.439 [0x14b553dfe700] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]
Apr 02, 2021 17:13:06.439 [0x14b553dfe700] ERROR - SQLITE3:(nil), 11, statement aborts at 11: [SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'fts4_metadata_titles_icu_segdir' WHERE level = ? ORDER BY idx ASC] database disk image is malformed
Apr 02, 2021 17:13:06.439 [0x14b553dfe700] ERROR - SQLITE3:(nil), 11, statement aborts at 173: [update metadata_items set updated_at=null,guid=?,hash=? where id=?] database disk image is malformed
Apr 02, 2021 17:13:06.439 [0x14b553dfe700] ERROR - Exception inside transaction (inside=1) (../Library/MetadataItem.cpp:3801): sqlite3_statement_backend::loadOne: database disk image is malformed
You have three choices: repair, restore from backup, or delete & start over. If you choose the latter you will have to re-create your libraries, shares with users, etc. Your movies/tv shows/etc are not affected.
