This happened to me a few months back.
At the time I just recovered a recent backup for the server and things got better.
However…
This time for a reason I still don’t get, my Time Machine backup has been disconnected since May.
So no recent backup. I also discovered yesterday that Crashplan doesn’t backup Plex Server data.
Tough luck.
So…
I’ve reinstalled. No change.
I’ve tried repairing the db with the instructions included here.
but… I get error messages like :
“Error: no such index: index_title_sort_naturalsort” for the 2nd check and 2nd repair items.
and
“Error: no such table: schema_migrations” for the 3rd check and 3rd repair items.
It seems doing this has deleted everything in the db. But I am really not sure as I don’t know anything about SQL commands.
I still can’t launch PMS.
And I don’t know what to do…
in the Databases folder, it seems there are old backed up versions but… while there are 4, they are all from 2016 !
So now I am at loss.
you had disabled Plex creating database backups as part of its scheduled jobs sometime in 2016
Plex recognized issues with the database and stopped overwriting the good backups… this would mean your database has been corrupted since then – apparently without immediately impacting your user experience – and the corruption has grown since then.
If the database has been corrupted over such a long time and so bad it cannot be repaired, you might indeed end up having to start over with that server of yours. Edit: … or at least you’ll need to bite the bullet and restore everything you added since 2016 if you choose to attempt restoring your server to one of those 2016 backups.
well…
I guess it’s what I’ll have to do.
I feared I would have to start from scratch anyway as I plan on migrating my server from my mac to a NAS, but I had really hoped I would be able to keep all my viewstates, collections and so on…
yes it’s faster but…
multiple versions of same movies (director’s cut, theatrical), playlists, viewstates (especially for tv shows), user restrictions (for my kid).
Naming, tagging all the family home videos (lots of them !)…
All of this will take a significant amount of time that I would have liked to be able not to waste.
Ok, I’m not in that boat as my Children are now adults. So you will need to invest in some time sorting it out. I just recently bought a new iMac and decided to start afresh, so it was good time making sure it all good.
Might be a good idea of making some solid planes of backing up those needed files, just in case the unforeseen visits again.
