I have had Plex installed on my Unraid server for years, and generally speaking, it has been rock solid. This week, I noticed that my TV Library is now showing unavailable. All other libraries are working, and you can even continue watching TV shows that are shown in the continue watching section. I have tried to access the TV library both locally and remotely and on multiple different devices (Android Fire Stick, Roku, PC, android phone), all with the same issues.
I have already tried to optimize the database, Clean Bundles, and refresh all the metadata in the TV shows library. Where do I go from here?
Nov 06, 2023 19:44:26.009 [22642397072184] ERROR - [Req#18d314] SQLITE3:0x80000001, 11, database corruption at line 84326 of [a29f994989]
Nov 06, 2023 19:44:26.009 [22642397072184] ERROR - [Req#18d314] SQLITE3:0x80000001, 11, statement aborts at 58: [select count(*) from (select distinct(metadata_items.id) from metadata_items where metadata_items.library_section_id in (3) and (metadata_items.metadata_type=2 and (select count(*) from metadata_items as leaves join metadata_items as parents on leaves.parent_id=parents.id left join metadata_item_settings on metadata_item_settings.guid = leaves.guid and metadata_item_settings.account_id=1 where (parents.parent_id=metadata_items.id or parents.id=metadata_items.id) and (metadata_item_settings.view_count=0 or metadata_item_settings.view_count is null) and leaves.metadata_type in (1, 4, 10))>=1) )] database disk image is malformed
Nov 06, 2023 19:44:26.011 [22642397072184] ERROR - Got exception from request handler: sqlite3_statement_backend::loadOne: database disk image is malformed
