Getting app notification database corrupted and failed to backup

Plex Media Server NAS & Devices
1

Server Version#: 1.32.6.7371

Since a couple months ago I am getting this set of push notifications:

Database Corrupted
The database on xxx was found to be corrupt

Database Backup
The database on xxx failed to backup

May I know what is causing this, is it because I don’t have enough free disk space? I followed some instruction to scan the sql file and it seemed okay, not sure if I am doing it correctly. What is this backup and how can I view my existing backups?

2

  1. A couple of months ???
    – Why not come sooner when first indications of issue(s)

  2. Failed to backup
    – Might well be “Out of space”.
    – Need DEBUG log files which capture the backup time period (scheduled tasks) to see

  3. Database corrupt
    – Might be corrupt because of “Out of space” problem.
    – Again , need DEBUG logs.

Which platform ? Need more details here.

3
  1. I don’t have an issue using it, so left it be.
  2. Would you be able to advise how exactly to get the debug logs associated with the error? And out of space: where is it trying to backup to? Same drive or another drive?
  3. I don’t have any database corrupted so I am guessing the push notification is misleading.
    Using Unraid OS and Plex official docker.
4

Item 2: Settings - Server - Troubleshooting (left panel) - Download Logs

  • This will give you a ZIP file of the current server logs. (They only hold the last 50 MB of logs so it’s best to grab the logs as close to the failure as possible
  • If you’ve not specified a location, backups will occur in the “Databases” directory (under /var/lib/plexmediaserver) right next to the DB’s themselves

Item 3: Database corruption

  • Without seeing the log message myself, I can’t evaluate further.
    The push notification hasn’t been reported as misleading so there’s an issue in there somewhere even if slight.
5

Hi. I have attached the logs hopefully successfully. It happened 7 hours ago again.

6

Unfortunately, you had added a bunch of media / the media processed.

7 hours is much to long to wait to pull the logs – but I understand why you might not have been able to get them.

Your logs show it running Intro Detection. When that runs, the log retention is very short.

There is a way to lengthen how much the logs hold (they hold about 20 minutes of elapsed time when it’s busy and about 2 hours when otherwise idle.)

Possible solutions:

  1. change your maintenance period to a time when you’ll be there and can catch it
  2. increase the number of log files retained (Preferences.xml: LogNumFiles="10" when PMS stopped)
7

Thanks for looking into it. Fresh this time round.
Plex Media Server Logs_2023-08-24_09-04-30.zip (5.0 MB)

8

Hi. Just to check in, did you manage to find anything? If not then it could be a bug somewhere

9

@ChuckPa Any update on this?

10

I am not seeing the normal log markers, can you post fresh logs shortly after you get the notification, and let us know what time that is? (will help narrow down what we need to look at)

11

Hi, that is actually the fresh logs. Happened at 9, and I got it at 9:03 if I remembered correctly.

12 
Aug 24, 2023 09:03:09.666 [22776616942392] ERROR - [Database backup/com.plexapp.plugins.library.db] The database failed its integrity check, not backing up.
Aug 24, 2023 09:03:09.666 [22776616942392] DEBUG - [Database backup/com.plexapp.plugins.library.db] Push: Sending notification tv.plex.notification.admin.database.corrupted to 1 users.
Aug 24, 2023 09:03:09.666 [22776616942392] DEBUG - [Database backup/com.plexapp.plugins.library.db/HCl#15df] HTTP requesting POST https://notifications.plex.tv/api/v1/notifications

“The database failed its integrity check”

Run the DBRepair Utility: GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases

Use the Auto option.

13

Thanks. I am using unraid and the Plex docker. Do I run it at unraid level with access to the files or inside Plex docker level?

14

In the container. The readme includes a Docker example.

15

yet another example of unraid not playing nice.

@thesoreloser any updates?

16

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