PLEX TOTTALLY UNUSABLE!! Error loading the dashboard

General Discussions
1

Please, my Plex server which I’m using daily since 2011 is totally unusable.
Here is my problem

I have this error for a few days.
I’ve got 4 libraries (TV shows, HD movies, 4K movies, Animé) I only have the issue with HD movies library (2404 movies) I usually sort my library by “recently added” so that the latest movies added appears first. I’ve just discovered that I got no issue when sorting by title, by resolution, by debit or by rating my library shows up with no problem. As soon as I select another way of sorting (Year, date added, progress…) I have the error message.
I ran database check with sqlite3, I got the result OK. Nevertheless I ran a database repair, just to got sure, check again and OK again.
PMS 1.5.3.3580 under mac OS. I tried to update to latest version with no success.

Consequently, I cannot reach Plex on my Apple TV. It says it can’t find any available content on my server so I can’t watch any movie

Please, PLEX team, find a fix, many users have this issue, could all databases crash at the same time?
I’ve been using Plex since 2011 with no major issue, I can’t believe my favorite media server is falling appart…

Best regards

2

have you optimized your database recently?

do you have database auto backups enabled so that you can restore from one?

3

Hello Thank you for your answer

Yes I did optimize my database recently. In fact, I do it at least once a week.

I do have auto backup every 3 days.

If you have a solution, please tell me how to restore database I don’t want to mess with it.

4

Thank you man

I’ve restored backup database and it now works!!