Server Version#: newest version - server up to date
Player Version#:
I’ve been having an issue with my Plex server for about six or seven months now. I I have four separate hard drives plugged into my computer and four different movie folders, and none of them will recognize any new movies or TV shows that are added to it. I may have tried renaming things are in that didn’t work, recently I realized that my server and Mac operating system were very out of date so I updated both of those to the most current version and that didn’t fix the problem either. Yesterday I removed a file path on one of my hard drives to see what would happen and all the movies within it disappeared, and then after re-adding the exact same file path and doing a library scan none of the movies that had previously been working just fine will show back up and I don’t know what to do.
I have been using flex for years with no issues prior to this, but I am at my wits end. I will admit that I am not the most savvy Plex user, but it has always worked without issue for me up until this problem started. I just saw the “Plex dance” info on another post so I will try that, but any other help would be greatly appreciated. Thank you all!
Have you given PMS permissions to external drives? In System Prefs > Security & Privacy, then under Files and Folders you can give it permissions to removable volumes (external drives), or under Full Disk Access you can give it permission to everything.
It looks a bit different depending on how recent your Mac OS version is.
As requested, server logs after a library scan just completed a few minutes ago. Hopefully this provides some type of answer, I dont know enough about looking through these logs to find anything myself. Thank you for your help, BigWheel!
Dec 09, 2022 17:09:57.173 [0x70000a5a1000] ERROR - SQLITE3:(nil), 11, database corruption at line 66843 of [1b256d97b5]
Dec 09, 2022 17:09:57.173 [0x70000a5a1000] ERROR - SQLITE3:(nil), 11, database corruption at line 66993 of [1b256d97b5]
Dec 09, 2022 17:09:57.173 [0x70000a5a1000] ERROR - SQLITE3:(nil), 11, statement aborts at 9: [REPLACE INTO 'main'.'fts4_metadata_titles_icu_docsize' VALUES(?,?)] database disk image is malformed
Dec 09, 2022 17:09:57.173 [0x70000a5a1000] ERROR - SQLITE3:(nil), 11, statement aborts at 10: [insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,edi
Dec 09, 2022 17:09:57.173 [0x70000a5a1000] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/1798116294/Library/MetadataItem.cpp:1156): sqlite3_statement_backend::loadOne: database disk image is malformed
Dec 09, 2022 17:09:57.173 [0x70000a5a1000] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/1798116294/Library/MetadataItem.cpp:4003): sqlite3_statement_backend::loadOne: database disk image is malformed
Dec 09, 2022 17:09:57.173 [0x70000a5a1000] ERROR - Exception assimilating media item in Alien.Resurrection.1997.SE.1080p.BluRay.x265-RARBG: sqlite3_statement_backend::loadOne: database disk image is malformed
You can either try to repair the database or it may be easier to restore a database backup. Generally a backup will not be made if the DB is corrupt, so you don’t end up with corrupt backups, so if the dates of the back ups seem old that may be why.
Oh man, thank you SO much! My wife was at the point of making me cancel our Plex pass because it hasn’t updated since about March or April. And while I wasn’t able to fix or even restore my database, I was able to delete it and start over which is just as good of a solution at this point. Again, I really appreciate your help. You have no idea how frustrated I have been with this!
