Recommended content doesn't load (including the home page) anymore but I still access my content from library tab. Does anyone have also this bug or it is just me and I have to reinstall everything?

Plex Media Server
1

Server Version#: 1.21.1.3766
Player Version#: Plex Web 4.43.4 or Plex for android 8.10.0.21911

I have a minor database error (two lines) from a long time ago that doesn’t seemed to affect my server till today and the following error (I think it’s new but I’m not sure) : Uncaught exception running async task which was spawned by thread 15800: sqlite3_statement_backend::loadOne: database disk image is malformed

I tried to repair the database following the Plex tutorial but it failed

Screenshot_20201214-145741
Screenshot_20201214-145741480×1041 38.9 KB
Screenshot_20201214-150115
Screenshot_20201214-150115480×1041 141 KB

(File removed)

2

That sounds like a damaged database file.
You need to repair it as soon as possible. https://support.plex.tv/articles/201100678-repair-a-corrupt-database/
Or if the repair fails, go back to a backup. https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/

3

Unfortunately the repair failed and i have no backup after september 2019… I guess it’s when the DB corruption appeared

4

Does this happen on all your clients or only on this Android phone?
If it’s isolated to the phone, I’d try resetting its home screen and side bar configuration: https://support.plex.tv/articles/customizing-the-mobile-apps-2#reset

5

Unfortunatetly it’s on all clients… I guess I have to reset everything… The only thing I want to preserve is my watched historic and on deck. Are thos in the database ?

6

Yes, they are in the database as well.
With some luck you might still be able to extract them https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/

Make sure to import these as first thing into a newly created server database, or you may encounter weird things like negative playcounts and the like.

7

The generated settings.sql is 1KB, it doesn’t smell good…

8

Open it with a text editor. It should mainly contain the guid's of your watched movies and tv show episodes and any ratings you might have assigned to them.
If it only has some general layout of a database table in it, then I’m afraid you are out of luck.

9

PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;

/**** ERROR: (10) disk I/O error *****/

ROLLBACK; – due to errors

10

Ugh, that does not only smell bad – it stinks.
Sorry about that!
I fear you have no other choice than to “go nuclear”.

11

No ok it’s beacause Plex was running so I guess the db file wasn’t readable I copied the db file in another place and re do the operation and now i have a 2MB file. I think i’m kinda saved :open_mouth:

12

If you could copy the whole file, attempt the “repair” procedure as well!

This is beginning to sound like a hardware problem. Have you ever performed a disk check of the drive which holds your Plex data folder ?
It might be defective or is dying.

13

I had hopes ahah but in the end it didn’t work

14

I will do a check you’re right

15

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