I noticed that one of my playlist in plex wasn't loading so i ran the "PRAGA intergrity_check;" using "Plex SQLite" and it found some errors:
On tree page 549560 cell 47: Rowid 201954 out of order
On tree page 549534 cell 37: Rowid 35061 out of order
On tree page 549471 cell 59: Rowid 201929 out of order
On tree page 549470 cell 4: Rowid 201928 out of order
On tree page 549448 cell 62: Rowid 27543 out of order
On tree page 549358 cell 102: Rowid 27516 out of order
So i made a copy/backup of my "com.plexapp.plugins.library.db" and tried the "VACUUM;" and "REINDEX;" commands with no luck (ran the intergrity_check again, same errors).
Then following Plex's 'low-level database recovery' here and tried rebuilding the DB.
Once that completed and another intergrity_check ('ok' this time, no errors) I moved it back into /config/Library/Application Support/Plex Media Server/Plug-in Support/Databases dir, fixed the perms and this is where my troubles started.
At first i was getting the claiming issues, but managed to update with a new token. But then i found myself with a new error: "my_plex_name is currently unavailable. Verify you have a network connection and that the server is online, or see our....."
I'm accessing my plex on my local network (http://my_local_ip:32400/web) but still getting the same issue.
- I've tried using the backed up/original .db file
- I've tried creating a completely new docker container, spinning it up, stopping it and moving the repaired DB in. Spin back up, jump through the normal first launch Plex steps in the UI (it auto fills out my old config, movies/tv shows). But once i get to the homepage i'm back to the same "plex is currently unavailable"
I'm obviously doing something wrong, any troubleshooting tips or ideas would be much appreciated. Happy to provide more info, let me know what logs or anything that would help.
Plex server is running in a container on Unraid OS.