Error Repairing A Database

Plex Media Server Desktops & Laptops
,
1

I have discovered that I have an error in my database as indicated by reading the server logs. While Plex works there are things I cannot update, like some shows keep showing as watched and not being able to edit tags, unable to empty the trash.

Walking through the instructions on repairing the database I get to the last step of reading the dump file back into the empty database and it creates an empty file. The last line of the dump file says: “ROLLBACK; – due to errors” which seems to me the dump process itself failed.

I was hoping not to loose all my watched status / associated devices. Does anyone have any other process I could try on it?

2

Repair one of the earlier backup copies and hope they don’t exhibit the same issue.
https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/

Alternatively try extracting only the viewstates:
https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/

3

Going back to a previous version was successful. Thanks so much!

4

I still recommend doing the repair procedure on this version of the DB file as well.
Just to make sure there is not already damage growing inside.

5

I did the repair process on the file before putting it into use to make sure.

1 Like
6

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