NVIDIA Shield - how to repair database?

[firles]

Hello. I can’t find the “repair database” command for a Plex server running on a new NVIDIA Shield (all software updates applied). Am I missing something?

To be clear, the server appears to be working fine, but every few days I get an error about how the database is corrupt and it can’t backup. Scanning the libraries works, as does optimizing the database. There are no errors except the “database corrupt” and “cannot backup the database” errors, which I see on my phone (push updates from the server) every few days.

Thanks!

[anon18523487]

You can’t repair the database directly on the Shield. You’ll need to extract the database and do the repair from a desktop computer, then put the file back.

[firles]

Thanks! Is there a place that has explicit instructions for how to do that using a Mac?

I found an article about repairing corrupt databases, but it has a lot of terminal commands and doesn’t speak to extracting the database.

Feature request: a “repair database” button I can suss out terminal commands, but needing them makes it very hard to recommend to regular folks w/o tech experience.

[anon18523487]

That article is the only thing with instructions. There are other posts here in the forum discussing them, but I don’t have a reference to anything specific handy.

To obtain the database from the Shield, you will need to move the Plex appdata to a user accessible location. There is an option form the Plex client to do this for the server. https://support.plex.tv/articles/moving-server-data-storage-location-on-nvidia-shield/

Once that is done, you can then access that location from your Mac using https://support.plex.tv/articles/220347688-accessing-shield-storage/. You then put the file back using this method overwriting the old one.

@firles

Feature request: a “repair database” button

Damaging your database is not something that typically happens and sometimes doing a repair can cause more damage. Or depending on the amount of damage, can result in a lot of loss of data. This si not something you’d want to happen with a click of a button.

[firles]

Thanks! I tried that and everything seems OK on the reboot. No lost data! I assume I’ll know more in a few days, when the regularly scheduled backup tries to run next and either fails or succeeds. Fingers crossed! Will report back!

[firles]

Success! The system automatically backed up last night without a hitch. Thanks for all your help!

As an aside, I’d still suggest the “repair database” button. At bottom, it looks like I had two choices: start with a fresh database or run those terminal scripts in order. Running all the scripts in order could be a button (with warnings), and if it fails you’re no worse off than you would have been if you’d have run the steps manually. Thanks again!