Please Help - Something Went Wrong - Possible Errors During Update?

Plex Media Server Desktops & Laptops
1

Server Version#: 4.83.2
Player Version#: Webplayer

Windows 10 Pro, PC as server. Not running VPN during updates or normal, everyday activity.

Thank you in advance for help on this, I’m not super tech savvy and am at a loss to fix my issue.

On 18 June everything in every Plex library disappeared. I can still see the Movies, TV, Music, etc. folders through the web and my devices, but there’s no content recognized. I’m greeted with a variety of errors, including “Something went wrong. An unexpected error occured” or receive notices that my server does not have a secure connection, or is offline completely.

I’ve checked all drives, everything on my PC is healthy and functioning normally. Our content is still good and playback is normal through VLC player on the desktop.

I have uninstalled and reinstalled all Plex software from my PC since the issue first appeared. This issue first appeared when Plex was installing an update on the 18th and we lost power (thanks Texas). I tested things after the computer rebooted, and Plex wouldn’t open/function. I uninstalled/reinstalled, and was still met with the previously listed error messages on the web portal.

Plex Media Server Logs_2022-06-19_14-29-19.zip (2.7 MB)

2

The Plex Media Server database is corrupt.

From Plex Media Server.log:

Jun 18, 2022 20:46:04.046 [6788] ERROR - SQLITE3:0xd6214807, 779, index corruption at line 91877 of [1b256d97b5]
Jun 18, 2022 20:46:04.046 [6788] ERROR - SQLITE3:0xd6214807, 779, statement aborts at 22: [delete from media_parts where media_item_id=?] database disk image is malformed

You’ve three options:

  1. Repair
  2. Restore from backup.
  3. Delete & start over.

The repair process is covered in Repair a Corrupted Database.

To restore from a backup, see Restore a Database Backed Up via ‘Scheduled Tasks’.

It is not possible to tell when the corruption occurred. The backup copies of the database may also be corrupt. After loading a backup and restarting Plex, check the Plex Media Server.log file for SQLITE3 errors (any log entry with ERROR - SQLITE3).

If repairing or restoring does not work, the last option is to delete the database and start over. This will not touch your media files. You will have to re-create your libraries, re-share them with any other users, etc.

From the Repair a Corrupted Database support article:
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.)

3

Typo fixed.

FYI, there is a typo in the Repair a Corrupted Database document.

PRAGMA integrity_check should be PRAGMA integrity_check;
VACUUM should be VACUUM;
REINDEX should be REINDEX;

The commands won’t execute without the semicolon at the end.

The typo has been mentioned to Plex. Updating the thread in case you run the commands before the support document is updated.

4

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