Hi. I recently discovered all my media was unavailable which usually happens to me when i need to update my server app. I updated the pms app on my nvidia shield but then noticed the media server settings in plex are now missing. Now the server is off and i can’t turn it back on again. The update seems to have broken plex somehow. I have tried clearing app caches and rebooting the shield but no luck. Anyone know how to fix this? Im not going to set up a new server for the 100th time, if its a server update bug id rather just wait for the next update.
Unfortunately i can’t seem to access shield internal storage. I have folled the instructions to allow the transfer of files over local network but the only thing that gives me access to is my external storage on the shield. No log files on that.
sqlite3_statement_backend::loadOne: database disk image is malformed
Dec 07, 2022 05:01:48.826 [9860] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/1265767192/Statistics/StatisticsManager.cpp:252): sqlite3_statement_backend::loadOne: database disk image is malformed
Dec 07, 2022 05:01:48.827 [9860] ERROR - Thread: Uncaught exception running async task which was spawned by thread 9834: sqlite3_statement_backend::loadOne: database disk image is malformed
So im trying to follow these guides to restore my database on the shield, however i keep getting stuck. The media server data is currently in the internal memory and not user accessible, the instructions say to move the server data directory by opening the plex client, going to settings and “On the Plex Media Server row, select Storage Location.”
My biggest problem here is the media server row is not there. The title for the row is there but there is nothing in the row. Where i would normally be avle to turn the server on or off is completely missing. How do i proceed?
Unfortunately the corrupt Db is what is causing it not to start or show up in row and since the data was still in the internal storage and cant be accessed the only thing to do is to start from scratch by clearing the PMS app data in the System settings of device. ( where force quit option is)
Ah damn! I was hoping to avoid that. Its not the first time this has happened. Ive had to start from scratch about 4 times. Is there something i can do to avoid this in the future?
after you install move the app data to user accessible or external storage. Then the PMS database will be accessible and potentially be able to be repaired or a DB backup restored.
Does the Shield get unplugged regularly? Is it on a switch that gets turned on and off or do you turn all your devices off to save power?
The database is somewhat fragile when it comes to power issues especially if these interruptions happen during a scan or database backup. If you keep getting this problem over and over you might want to look into that
An independent power supply that gets left on with some kind of surge protection might not be a bad idea.
You also might want to change the time of scheduled maintenance so it doesn’t get interrupted
