Can't upgrade to latest Plex server with corrupt database and repairing database results in 0k file

Plex Media Server Desktops & Laptops
,
1

Server Version#: 1.14.1.5488 (unraid docker)
Player Version#: Multiple

After updating my server from 1.14.0.5470 to 1.14.1.5488 I now get this:

“There was an unexpected error loading the dashboard
Please visit our forums if you continue to experience problems”

error on the web player and mobile devices are showing the server as offline.

I traced this back to a database corruption by following the plex repair database page I found this:

“row 125053 missing from index index_media_streams_on_media_item_id
database disk image is malformed”

The problem is when I do the last step (sqlite3 com.plexapp.plugins.library.db < dump.sql) I end up with a com.plexapp.plugins.library.db file that’s 0k. I ended up restoring the backed up com.plexapp.plugins.library.db and downgrading the server back to 1.14.0.5470 and I’m able to get back into the dashboard but I’ve tried upgrading a couple times and it seems like the database corruption is breaking something in the new server version.

I’ve also tried copying com.plexapp.plugins.library.db to my windows machine and tried to repair with sqlite3 using the windows instructions and the same 0k file is generated.

Any help would be greatly appreciated!

2

it sounds like your db file is damaged beyond repair.

if sql is not able to read it enough to export the data, you won’t get any of that data into a new db, thus the empty file.

also make sure you follow the exact instructions @ https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

3

Yeah I’ve read that over probably a dozen times now, do you think it would be possible to manually repair the database based on the integrity check error it generated?

4

if the db file is physically corrupted, that means you can’t trust any data that is pulled from it, because you don’t know what is correct and what isn’t.

If you don’t have an old uncorrupted backup file that you can successfully perform a repair from, then you are most likely out of luck and will have to bite the bullet and rebuild your library from scratch.

it sucks, believe me I know I have been through many sqlite database corruptions in my time (not just plex but other applications).

good backups are the only real solution in my experience.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.