There was an unexpected error loading this library. DB Corrupt

Server Version#: 1.19.5.3035-864bbcbb7
Player Version#: 4.34.3

First the Plex App on my android works as expected.
When I browse to localhost:32400 I get
There was an unexpected error loading this library when I try to browse movie Library, Recommended and Playlist sections work as expected.

When I go to TV Shows I get the same error on Recommended yet Library and Playlist work as expected.

My Roku devices exhibit the same behavior, I can do a search and play movie with no problem.

I have tried reinstalling, rebooting and performed the repair DB with not luck

When I run sqlite3 com.plexapp.plugins.library.db < dump.sql I get file size of 0

Plex Media Server Logs shows
MessageSQLITE3:0x8a40ec8, 11, database corruption at line 64757 of [bf8c1b2b7a]

MessageSQLITE3:0x8a40ec8, 11, database corruption at line 64798 of [bf8c1b2b7a]

SQLITE3:0x8a40ec8, 11, statement aborts at 59: [select distinct media_items.id as ‘media_items_id’, media_items.library_section_id as ‘media_items_library_section_id’, media_items.section_location_id as 'media_items_section_location

Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed

Can I drop media items and add them back?

Repairing the db does not always have a 100% success rate. Meaning, while it might repair alot or even most errors, it may not get them all.
Depending when the corruption started you may be able to restore from one of your backups(com.plexapp.plugins.library.db-xxxx-xx-xx). Where xxxx-xx-xx is the year-month-day. You should have about 3 backups available. If you don’t have any then the option may be disabled.


Enable it if so.
1 Like

Thank you! That fixed it.

1 Like

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