Hi all new to the forum but have been using plex for about 8 months. Literally today I’ve been trying to reopen plex media server on my Mac mini it shows that it open even the little icon come up on the task bar but then instantly closes.
I have uninstalled and reinstalled, restarted the machine but still won’t work.
Thank you for the reply
This was the file today a little while ago.
Jan 21, 2023 15:32:34.084 [0x700001949000] INFO - Plex Media Server v1.19.4.2935-79e214ead - Apple Mac x86_64 - build: darwin-x86_64 macos - GMT 00:00
Jan 21, 2023 15:32:34.084 [0x700001949000] INFO - MacOSX version: 10.16, language: en-GB
Jan 21, 2023 15:32:34.084 [0x700001949000] INFO - Processor Intel(R) Core™ i5-4278U CPU @ 2.60GHz
Jan 21, 2023 15:32:34.084 [0x700001949000] INFO - /Applications/Plex Media Server-3.app/Contents/MacOS/Plex Media Server
Jan 21, 2023 15:32:34.234 [0x700001ad2000] DEBUG - BPQ: [Idle] → [Starting]
Jan 21, 2023 15:32:34.238 [0x700001ad2000] DEBUG - FeatureManager: Using cached data for features list
Jan 21, 2023 15:32:34.246 [0x700001ad2000] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.26.0, threadsafe=1
Jan 21, 2023 15:32:34.257 [0x700001ad2000] ERROR - SQLITE3:0x1059a2de8, 11, database corruption at line 66053 of [bf8c1b2b7a]
Jan 21, 2023 15:32:34.257 [0x700001ad2000] ERROR - SQLITE3:0x1059a2de8, 11, database disk image is malformed in “PRAGMA cache_size=2000”
Jan 21, 2023 15:32:34.259 [0x700001ad2000] ERROR - Database corruption: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2000
You are looking for the 3rd file in that list DBRepair.sh
EDIT: Chuck is apparently attempting to write a Windows version, which is what you downloaded. (its been a great Unix tool, glad to see it being ported)
1. Open your browser to https://github.com/ChuckPa/PlexDBRepair/releases/latest
2. Download the source code (tar.gz) file
3. Place the tar.gz file in the appropriate directory on the system you'll use it.
4. Open a command line session (usually Terminal or SSH)
5. Elevate privilege level to root (sudo)
6. Extract the utility from the tar or zip file
7. 'cd' into the extraction directory
8. Give the utility 'execute' permission
9. Invoke the utility
To launch from the command line on MacOS (on the administrator account)
osascript -e 'quit app "Plex Media Server"'
cd ~/Downloads
tar xvf PlexDBRepai PlexDBRepair-0.6.1.tar.gz
cd PlexDBRepai PlexDBRepair-0.6.1
chmod +x DBRepair.sh
./DBRepair.sh
EDIT: Im betting I missed a step with my instructions previously
ill be honest, I rarely use Terminal so can’t say I am totally up to speed with it and using commands. When I run that it comes back as Error Unknown host. I think it maybe better and easier for me to just start again and learn from my mistake and keep a backup of it
Rename: com.plexapp.plugins.library.db-wal to com.plexapp.plugins.library.db-wal.old com.plexapp.plugins.library.db-shm to com.plexapp.plugins.library.db-shm.old com.plexapp.plugins.library.db to com.plexapp.plugins.library.db.old com.plexapp.plugins.library.blobs.db-shm to com.plexapp.plugins.library.blobs.db-shm.old com.plexapp.plugins.library.blobs.db-wal to com.plexapp.plugins.library.blobs.db-wal.old com.plexapp.plugins.library.blobs.db to com.plexapp.plugins.library.blobs.db.old
Then:
copy com.plexapp.plugins.library.blobs.db-2023-01-11 and rename the copy to com.plexapp.plugins.library.blobs.db
copy com.plexapp.plugins.library.db-2023-01-11 and rename the copy to com.plexapp.plugins.library.db
Then try starting plex
What this does is moves the existing database out of the way (aka .old) then restores a backup from January 11th
Woohoooo it worked. Missing a few name changes and some watched videos now showing not watched but apart from that its all there. Thank you so much, if I could buy you a beer I would. Thank you
No problem, we basically reverted your library back 10 days. We could have tried a newer backup, but I felt it was safer going back as far as we could (Keep it simple)
Can you go ahead and close plex, restart it, wait 5 minutes and give me a copy of your server logs? Id like to ensure that we don’t still have underlying issues.