The database was found to be corrupt

Plex Media Server NAS & Devices
1

Hello,

I have this message since a few days.

I’m trying to apply this solution :
https://support.plex.tv/articles/repair-a-corrupted-database/.

But I can’t find “/var/packages/PlexMediaServer/target/Plex SQLite”.

Has anyone information about the location of these files ?

Thank you.

The server runs fine, i have no issue.
PMS 1.41.0.8992-70008992
Synology DS1019+ running DSM 7.2.1-69057 Update 5 (last stable version)

2

See GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases

4

You can download and run from the command line.

The utility must be run as root.

You can run in interactive mode or add the desired options to the command line.

# cd to Plex Data Directory
cd /var/packages/PlexMediaServer/shares/PlexMediaServer

# Download latest version. This overwrites any existing version.  Remove "-O DBRepair.sh" to not overwrite.
wget -O DBRepair.sh https://github.com/ChuckPa/PlexDBRepair/releases/latest/download/DBRepair.sh

# Make it executable
chmod a+x DBRepair.sh

# Run it
sudo ./DBRepair.sh stop auto start exit
2 Likes
6

@MegaBit1024 before you attempt any repairs is there a chance I can get a copy of your databases?

7

I haven’t gotten to the point where I’ve changed anything so it’s entirely possible. For what purpose?

8

Thanks for this very detailled process.
My Linux is very limited…
I have the last step left but I have to wait until there is no one connected anymore!

I’m backing up my database for @dbirch during this time.

9

Plex Media Server needs to be stopped before making a backup of the active database files (the files that end in .db). If Plex is running, the database files are open, and the backup may not be valid.

The -shm & -wal files are temporary files. They normally go away when Plex Media Server is stopped (the info is incorporated into the main database files).

It is OK to backup the files that have a date appended to the name. Those are backups made by Plex Media Server as a scheduled task. They are not in use when Plex is running.

10

I am working with ChuckPa to create a repository of broke databases in order to improve the recovery tools.

If you need any assistance repairing let me know.

11

A post was merged into an existing topic: PlexDBRepair development

12

Thank you for the very detailled process.
It helps me.

Warning for other users, with a 1.7GB database, this takes several minutes.
Be patient.

13

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