Another Plex update - Another database corruption requiring a rebuid

Plex Media Server NAS & Devices
,
1

Server Version#:Version 1.42.1
Player Version#:4.149.0

Really tired of having to rebuild my database every time I do an update. Takes me three days to rebuild the metadata correctly each time. Casting support works differently on ios app (only sees fire TV devices) vs web app (only sees Chromecast devices). Beginning to get tiring managing a PMS server and apps.

I have PMS running on QNAP nas. I try not to update it often as its a ball ache to rebuild. I had to bite the bullet this weekend. Still in rebuild hell.

I have Plex clients on laptop, ipads and iphones, firestick enabled TVs.

I cast audio to chromecast enabled DENON RCD. This stopped working so bit the bullet.

Usual SQLlite - SQLITE3:0x80000001, 11, database corruption at line xxx, repeats three times.

Trying to start UI - Plex Media Server is currently running database migrations.

2

Meaning it’s updating the database, so I would leave it on for at least a couple of hours

3

Yeah, except its not. The database is corrupt as per the SQLLite errors and it just sits there reporting “Plex Media Server is currently running database migrations.”. Hence rebuilding again. Second time this year. Not funny anymore.

4

Run DBRepair for Plex Media Server before updating Plex.

It will check the database for structural problems and attempt to correct any it finds.

You can also use it to restore a backup copy of the database. It checks the backups before placing them in service.

Here is an example of installing it on a Synology NAS: Updated Plex Manually, then Synology Package Center, won't run manually stops - #24 by FordGuy61.

See the README for where to install the script on a QNAP NAS.

To run it: sudo ./DBRepair.sh.

For the initial run, use STOP then AUTO.

If DBRepair finds problems it cannot fix, try REPLACE to see if a viable backup exists.

4 Likes
5

Thanks for that. Will try that before next upgrade.

6

Forgot to mention this earlier…

You can have Plex Media Server send notifications to the Plex mobile app for many events, including when database corruption is detected.

Plex Media Server: Settings → server_name → General, enable Push Notifications.

Plex mobile app (Android, iOS should be same/similar): Settings → Notifications. At the bottom is the Plex Media Server section. There are notifications for New Devices, Database Corruption Detected, and Database Backed Up.

7

Think about getting a decent UPS unit for your NAS.
If you remember even a single instance where your NAS unit suddenly lost power (for whatever reason and no matter how briefly) you should seriously consider it.
Sudden loss of power can very much lead to database corruption.
It can also damage hard drives physically. No joke.

The same goes for running out of space on the storage volume where the Plex data folder is stored. Never let that happen, or database corruption is very likely to occur.

1 Like