Corrupt database, but pms is running

Hi Sir/Mam,

I am deeply sorry if i post this wrong, but please help, it would mean all to me, and i will be super happy.

This morning my mobile with Plex dashboard had a message “could not backup database”, “database corrupt”. But my plex is running without any visual errors.
I then went to 3. last menu, and pressed, clean database, and optimize database.
Then tried to save the database, but the zip file that saves is empty, i can only save the attached log file.

I my self am not new to plex, but as i am not a linux code man i dont know what more to do. I am grafic user, not code guy. I help many other users here in Demark on the danish fb community plex group, but this one i cant figure out.

My plex runs on a Windows 10 machine, and there are space on the drive.
i run plex version 1.24.0.4930Plex Media Server Logs_2021-08-13_08-18-52.zip (1.7 MB)

Kind regards
Mr. ThaigerPlex

Your log files show database corruption:
Aug 12, 2021 19:17:08.026 [16368] ERROR - SQLITE3:0xbf6285b2, 11, database corruption at line 81887 of [1b256d97b5]

You have three choices: a) repair; b) restore from backup; c) delete and start over.

The database is located in %LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases. The default location for %LOCALAPPDATA% is c:\Users\user_name\AppData which Windows hides by default. To see the folder in Windows File Manager, select the View tab, then check the box next to Hidden Items. Reference: Where is the Plex Database Located.

Repair a Corrupted Database details how to repair a database.

If Plex Media Server is backing up the database (part of scheduled tasks), you can try restoring from one of the backups. After restoring, scan your libraries to pick up any media added since the backup occurred. Restore a Database Backed Up via ‘Scheduled Tasks’ has additional information.

If repair and restoral do not work, you can delete the database and start over. You will have to re-create your libraries, reshare them with any friends, etc. Your media files remain intact during the process (this deletes only the database, not your media).

From Repair a Corrupted Database:
Note : You can also simply delete the com.plexapp.plugins.library.db database file while the Plex Media Server is not running. Restarting the server will then restore your server to a nearly-fresh install state. (i.e. You will lose your existing libraries and need to recreate them , but you won’t be affecting your content itself.)

1 Like

Two unrelated items to address: Nvidia Driver versions and Logging Levels.

Nvidia Drivers
You need to update your Nvidia drivers. Hardware accelerated transcoding will not work correctly with out of date drivers.
Aug 13, 2021 03:16:41.956 [4384] ERROR - [FFMPEG] - The minimum required Nvidia driver for nvenc is 418.81 or newer

Logging Level
Enable DEBUG level logging in Plex Media Server. It provides the necessary level of information (it is not currently enabled).

Do not enable verbose logging, which causes the log files to wrap too quickly.

1 Like

How much free space is on your C: drive?
If it’s nearly full, this might be the very reason for the database corruption.
While you have installed the plex server on drive D: (which is not recommended by the way), this will only move ~170MB off of C:
Your plex data folder and the main database file are still residing on drive C:, and this folder can get much bigger than 170 MB.

So before you are trying to repair the database, move your plex data folder to someplace else.
Otherwise your freshly repaired (or recreated) database might get damaged again shortly: [HowTo] An extended guide on how to move the Plex data folder on Windows

1 Like

Hi,

Super thanks to you both, werry werry appriciated :wink:
It seems that the problem is solved by restoring a backup.
Super thanks for your kind and fast help :wink:

Would be nice with a “advanced user” butten, “restore backup” in pms directly :slight_smile:
with warning of the potential consequences…

Chears
ThaigerPlex

Just to be on the safe side, repair the restored database file as well.

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