Server Version#: Version 1.22.2.4282
Player Version#: Version 4.55.0
About 4 days ago, my Plex stopped detecting any new files from my computer. All of the old files still play, however. I’ve reset the server and computer numerous times to no avail. I also tried to start a new library and Plex could not find any files from it. No updates or scans worked either. Any solutions?
This sometimes happens if the Plex database is corrupted.
Pull the log files from your Plex Media Server. Settings → Troubleshooting → Download Logs.
FYI, your server should be set for debug, not verbose, logging. See Settings → Server_Name → Settings → General. Select Show Advanced. Check the box next to Enable Plex Media Server debug logging. Uncheck the box next to Enable Plex Media Server verbose logging.
Unzip the file and open the Plex Media Server.log file with a text editor/reader.
Look for error messages indicating database corruption, such as those containing ERROR - SQLITE3 or ERROR - Database corruption. Some examples:
Jul 05, 2020 19:36:56.959 [0x7f59f1b85740] ERROR - SQLITE3:(nil), 11, database corruption at line 64817 of [bf8c1b2b7a]
Jul 05, 2020 19:36:56.959 [0x7f59f1b85740] ERROR - SQLITE3:(nil), 11, statement aborts at 10: [select max(max(metadata_items.changed_at),max(metadata_items.resources_changed_at)) from metadata_items] database disk image is malformed
Jul 05, 2020 19:36:56.978 [0x7f59f1b85740] ERROR - Database corruption: sqlite3_statement_backend::loadOne: database disk image is malformed
If the database is corrupt, you’ve three choices: repair, restore from a backup, or delete & start over.
If you delete the database you will have to re-create your libraries and re-share them with any users. Your media is not touched during the process.
If you’ve a backup of the database you can try restoring it. If the backup is not corrupt, you can then re-scan your libraries to pick up any additions since the date of the backup.
You can also try repairing the database. You will need to be comfortable with using Terminal and the command line for this option.
These support articles have additional information:
Thank you! Restoring a backed up database worked.
@elcappytan I was relieved to read your post because I have the same exact problem on my ubuntu 20.04 ever since i update to Plex Server 1.22.x
I tried to follow the plex instructions to correct DB corruption but Step #2 kept failing
So I’m just going to rebuild my libraries…
FordGuy61
Thanks for the quick reply. Pulled down the logfiles (non-verbose) and reviewed them after requesting a “rescan”. What I found was a scan of all the existing files and no error messages – but the scan did not see the files that have not been recognized. Doesn’t seem like existing data base is corrupt. It’s more of an issue of the scan process not seeing the files recently added. The fact that the scan process has seen 74 files ok suggests that it’s not my naming convention that’s causing it to miss the files. Any other suggestions??
If the database was corrupt you would see the error messages in the log files.
It is possible Plex considers the video a duplicate and has combined it with another video.
Look at the library in Plex Web. Click on “All” and choose “Duplicate” from the list.
If you’ve duplicates:
You can see which files are combined by pulling up the Get Info / Media Info window.
You can split the files by choosing Split Apart from the same menu where you see Get Info (You won’t see Split Apart listed unless files have been combined).
Great suggestion… I didn’t realize Plex had this capability. When I searched for duplicates, I found only one. The titles of 2 videos were similar. I had previously “repaired” this issue. Unfortunately, the “invisible” new adds did not show up in this diagnostic. They are still not being picked up by Plex. Any other suggestions?
It might be worth checking the permissions on the ones that are not appearing and make sure they are the same as the ones that are working.
You could also try looking at your library in folder view and see if the missing items are there
Finally found the “lost” videos in Plex. Turns out that in addition to the "All’ choice in the filter for Home Video, there is also an “Unmatched” choice. When I chose that, the Invisible videos were there. When I appropriately changed their names, they sorted in the list as expected.
Thanks to all who helped me here! I never would have found this without help… It also seemed to matter that enough time had to pass for a “comprehensive audit” to occur in the data base. When I went to bed Friday night, Plex said there were 75 items in the data base. When I got up on Saturday morning, it said there were 78. That was the clue that something had changed. That never happened when I simply ran a “rescan the database” after adding a video.
Paul
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
