Upon updating my Drobo PMS to this version I had experienced the same problem of no new media showing up and all searches broken.
Upon installing sqlite3 onto my drobo and trying to read the database I got these errors from the sqlite3 program.
sudo sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'"
Last login: Mon Apr 20 07:37:29 PDT 2020
Error: file is encrypted or is not a database
So I decided the file must be corrupt. I backed it up and deleted the original and restarted the server from scratch… sad to loose all context within the library, but it could be worse.
Hope this helps others experiencing the same problem.
The error message actually say it correct – it’s encrypted (so people or apps don’t start messing around in the productive/running server).
That being said… before jumping to fix the database, let’s rule out some more basic issues.
What exact issue do you have with your Plex? What troubleshooting steps have you already done?
Mind sharing some details about your setup / what type of files isn’t showing?!
Any related error messages?
Yes I did quit/stop Plex before attempting to “repair” the database.
Ah yes if it is encrypted then it may not have been corrupted. Should there be text/commands added on how to unencrypt it in order to execute the commands linked on the documentation page about fixing a corrupt db?
Though after deleting and reindexing everything search and recently added (really library sync) works again… Something definitely was off just don’t know what was wrong.
@tom80H I first noticed that server search wasn’t working after the upgrade to this version as called out in this other thread, Library Search Not Working
Though even after confirming that I had included via config the libraries into global search it still didn’t work. After a while I noticed that some titles I were looking for were recent additions (~3-5 days old all added after the upgrade), but weren’t showing up in the Dashboard nor in the Library View itself.
I’m not really sure why, but even manually triggering a “scan library files” didn’t resolve my issues so that led me to believe something wasn’t right about the database.
If that’s not it… can do a Plex Dance and pull some logs after returning the files and running the final scan? (Plex Dance: remove the files in question from the folder supervised by Plex, scan the library files, empty trash, clear bundles, return the files, scan the library files again)
After the removal of the old database all the media was added and read successfully by the Plex scanners. I have always used the same naming pattern: <Movie Title> (<YYYY>) and have never had a problem.
All titles missing from index/database metadata were movies and not TV Shows.
Just started having the same issues again. In the server logs I’m seeing a few logs about database corruption (before and after updating to 1.19.2.2711-bab6de29f which was just released).
Thread: Uncaught exception running async task which was spawned by thread 0x2f743450: sqlite3_statement_backend::loadOne: database disk image is malformed
SQLITE3:0x3787, 11, database corruption at line 64757 of [bf8c1b2b7a]
SQLITE3:0x3787, 11, database corruption at line 64798 of [bf8c1b2b7a]
SQLITE3:0x3787, 11, statement aborts at 13: [select statistics_bandwidth.id as 'statistics_bandwidth_id', statistics_bandwidth.account_id as 'statistics_bandwidth_account_id', statistics_bandwidth.device_id as 'statistics_bandwid
