No Access to libraries (remote or local) after Plex Server update this morning

Plex Media Server
1

Server Version#: 1.26.0.5715-8cf78dab3
Player Version#: 1.31.0.2254-43df1e6e

Have been running Plex for YEARS with zero problems. This morning, after updating the Plex server I am unable to access my libraries (remotely and locally).

The error message that pops up is “Something Went Wrong \ An unexpected error occurred”. This message isn’t very helpful in trying to pinpoint what the problem might be.

Nothing else has been changed. No settings have been altered. It was a simple server upgrade that I’ve done hundreds of times.

I’ve signed out of both the server and the app…and then signed back in again. Didn’t help.
I’ve shut down and restarted the Plex server. Didn’t help.
I completely rebooted the Mac (where my Plex server runs). Didn’t help.
The server app and the player app ARE both showing up as authorized devices.
(It goes without saying but I’ll say it anyhow: I can’t access my Plex libraries from ANY of the authorized devices).

I’ve had the occasional network issue over the years but that only halted remote access to my libraries. I have NEVER, EVER, had a problem with local access to the libraries.
NOTE: The drive containing the libraries is running fine, connected to the MAC, and all files/folders are available.

I have no idea what to do at this point.

Can somebody PLEASE HELP?

Thanks

2

Can you post your server logs?

3

I’ve attached the logs as requested:

A couple more ‘clues’ since I made the original posting 25 minutes ago:

  1. I restored the Plex folders from last night’s backup…and (shock!) the problem still persists!
    • I had saved the current folders elsewhere prior to the restore so when I saw the problem
      persisted…I put the original folders back in place.
  2. When I try to access ANYTHING in the SETTINGS or MANAGE menus I just get a spinning circle that eventually comes back with “Server settings unavailable”. Then…after some random amount of time…I can then access any of the SETTINGS choices or MANAGE choices…which is how I was able to generate the logs for you.
  • As a side note: The remote access SETTING page is showing “FULLY ACCESSIBLE OUTSIDE YOUR NETWORK”

Plex Media Server Logs_2022-04-25_12-32-49.zip (1.0 MB)

4

ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed

Looks like you have a corrupt database.Repair a Corrupted Database | Plex Support

5

If that is the case why did restoring the entire “Plex Media Server” from last night result with the SAME ERROR(s) ???

If the upgrade corrupted the database then restoring from last night’s backup should have resolved the issue???

6

Odds are the update didnt corrupt the database but rather exposed the database corruption. By restarting plex the database had to be reloaded. I would pull from an older plex backup or see if you can reference the linked info for repairing it.

7

I’ve done a restore of the main “Plex Media Server” directory AND this time I also restored the Plex Server App. The new Plex Server app is 1.26.0 and the previous version (that I’ve now restored) is 1.25.9.

VOILA! Everything is back to working properly.

NOTE: I’ve started/stopped/restarted the Plex Server app (the version I restored - 1.25.9) about 4 times now…and each time I restart…the database is intact, no issues, and the Plex App loads/displays all the database content fine. AT THIS POINT I AM ABOUT 99% CERTAIN THAT THE UPGRADE DID THE DAMAGE/CORRUPTION!!!

So what would you suggest I do at this point?

8

Can you check the Check for Corruption section of the linked article? Even if the database works it could still have corruption issues.

9

Well…after the restore (of both the db and the app) everything is working fine. Even after starting/stopping/restarting the Plex server numerous times.

So…since I had a “clear path” to resolve the issue if it cropped up again…I went ahead and downloaded/installed the v1.26 upgrade. With fingers crossed…it completed…and believe it, or not, everything is in working order. No issues. I’ve, again, started/stopped/restarted the Plex Server app numerous times…and everything continues to work fine.

I’m tempted to let “sleeping dogs lie” but, as I stated above…since I have a clear path back to a working version…I’ll perform the “Check for Corruption”. I’ll post back here with the results.

10

OK…here are the results of the corruption scan. Should I attempt a rebuild??

row 563 missing from index index_metadata_item_clusterings_on_metadata_item_id

wrong # of entries in index index_metadata_item_clusterings_on_metadata_item_id

row 882 missing from index index_metadata_items_on_hash

row 1670 missing from index index_metadata_items_on_hash

row 2056 missing from index index_metadata_items_on_hash

row 3364 missing from index index_metadata_items_on_hash

row 3458 missing from index index_metadata_items_on_hash

row 3705 missing from index index_metadata_items_on_hash

row 4260 missing from index index_metadata_items_on_hash

row 4744 missing from index index_metadata_items_on_hash

row 5162 missing from index index_metadata_items_on_hash

row 5753 missing from index index_metadata_items_on_hash

row 5836 missing from index index_metadata_items_on_hash

row 6251 missing from index index_metadata_items_on_hash

row 7463 missing from index index_metadata_items_on_absolute_index

row 7463 missing from index index_metadata_items_on_changed_at

row 7463 missing from index index_metadata_items_on_created_at

row 7464 missing from index index_metadata_items_on_absolute_index

row 7464 missing from index index_metadata_items_on_changed_at

row 7464 missing from index index_metadata_items_on_created_at

row 7465 missing from index index_metadata_items_on_absolute_index

row 7465 missing from index index_metadata_items_on_changed_at

row 7465 missing from index index_metadata_items_on_created_at

row 7466 missing from index index_metadata_items_on_absolute_index

row 7466 missing from index index_metadata_items_on_changed_at

row 7466 missing from index index_metadata_items_on_created_at

row 7467 missing from index index_metadata_items_on_absolute_index

row 7467 missing from index index_metadata_items_on_changed_at

row 7467 missing from index index_metadata_items_on_created_at

row 7468 missing from index index_metadata_items_on_absolute_index

row 7468 missing from index index_metadata_items_on_changed_at

row 7468 missing from index index_metadata_items_on_created_at

row 7469 missing from index index_metadata_items_on_absolute_index

row 7469 missing from index index_metadata_items_on_changed_at

row 7469 missing from index index_metadata_items_on_created_at

row 7470 missing from index index_metadata_items_on_absolute_index

row 7470 missing from index index_metadata_items_on_changed_at

row 7470 missing from index index_metadata_items_on_created_at

row 7471 missing from index index_metadata_items_on_absolute_index

row 7471 missing from index index_metadata_items_on_changed_at

row 7471 missing from index index_metadata_items_on_created_at

row 7472 missing from index index_metadata_items_on_absolute_index

row 7472 missing from index index_metadata_items_on_changed_at

row 7472 missing from index index_metadata_items_on_created_at

row 7473 missing from index index_metadata_items_on_absolute_index

row 7473 missing from index index_metadata_items_on_changed_at

row 7473 missing from index index_metadata_items_on_created_at

row 7474 missing from index index_metadata_items_on_absolute_index

row 7474 missing from index index_metadata_items_on_changed_at

row 7474 missing from index index_metadata_items_on_created_at

row 7475 missing from index index_metadata_items_on_absolute_index

row 7475 missing from index index_metadata_items_on_changed_at

row 7475 missing from index index_metadata_items_on_created_at

row 7476 missing from index index_metadata_items_on_absolute_index

row 7476 missing from index index_metadata_items_on_changed_at

row 7476 missing from index index_metadata_items_on_created_at

row 7477 missing from index index_metadata_items_on_absolute_index

row 7477 missing from index index_metadata_items_on_changed_at

row 7477 missing from index index_metadata_items_on_created_at

row 7478 missing from index index_metadata_items_on_absolute_index

row 7478 missing from index index_metadata_items_on_changed_at

row 7478 missing from index index_metadata_items_on_created_at

row 7479 missing from index index_metadata_items_on_absolute_index

row 7479 missing from index index_metadata_items_on_changed_at

row 7479 missing from index index_metadata_items_on_created_at

row 7480 missing from index index_metadata_items_on_absolute_index

row 7480 missing from index index_metadata_items_on_changed_at

row 7480 missing from index index_metadata_items_on_created_at

row 7481 missing from index index_metadata_items_on_absolute_index

row 7481 missing from index index_metadata_items_on_changed_at

row 7481 missing from index index_metadata_items_on_created_at

row 7482 missing from index index_metadata_items_on_absolute_index

row 7482 missing from index index_metadata_items_on_changed_at

row 7482 missing from index index_metadata_items_on_created_at

row 7483 missing from index index_metadata_items_on_absolute_index

row 7483 missing from index index_metadata_items_on_changed_at

row 7483 missing from index index_metadata_items_on_created_at

row 7484 missing from index index_metadata_items_on_absolute_index

row 7484 missing from index index_metadata_items_on_changed_at

row 7484 missing from index index_metadata_items_on_created_at

row 7485 missing from index index_metadata_items_on_absolute_index

row 7485 missing from index index_metadata_items_on_changed_at

row 7485 missing from index index_metadata_items_on_created_at

row 7486 missing from index index_metadata_items_on_absolute_index

row 7486 missing from index index_metadata_items_on_changed_at

row 7486 missing from index index_metadata_items_on_created_at

row 7487 missing from index index_metadata_items_on_absolute_index

row 7487 missing from index index_metadata_items_on_changed_at

row 7487 missing from index index_metadata_items_on_created_at

row 7488 missing from index index_metadata_items_on_absolute_index

row 7488 missing from index index_metadata_items_on_changed_at

row 7488 missing from index index_metadata_items_on_created_at

row 7489 missing from index index_metadata_items_on_absolute_index

row 7489 missing from index index_metadata_items_on_changed_at

row 7489 missing from index index_metadata_items_on_created_at

row 7490 missing from index index_metadata_items_on_absolute_index

row 7490 missing from index index_metadata_items_on_changed_at

row 7490 missing from index index_metadata_items_on_created_at

row 7491 missing from index index_metadata_items_on_absolute_index

row 7491 missing from index index_metadata_items_on_changed_at

11

I would back the database up again (play it safe) and then run a repair. I suspected there was an underlying issue in your case.

12

You have been EXTREMELY helpful. It is MUCH APPRECIATED.

So I made a copy of the Plex DB and ran a manual repair of the database (using the dump command and then the read command…into an entirely new db file).

I then renamed the existing Plex DB file, renamed the newly build Plex DB file to the proper name, and then ran an integrity check on the new Plex DB file. It came back with “OK”.

So I then fired up the Plex Server, with the new DB file in place, and started up the Plex App and…POOF…all is well (or seems to be anyway!). NOTE: As instructed I DID remove the .db-shm and the .db-wal files as I put the newly built db into place.

I’ll keep a close eye on it over the next week or so but…I think you helped me get an underlying corrupted DB file fixed!!!

I still think it’s strange that after I did the full restore and THEN ran thru the upgrade again…this time it worked fine instead of leaving no access to the libraries. VERY STRANGE.

But…once again…thanks tons!

13

With a corrupt database you will get inconsistent results. some times plex will be able to handle an error and other times it takes too long to resolve causing another error, which plex cant handle.

14

Well…in the long run it was probably best that the 1st upgrade caused the issue…which then helped “expose” that database corruption. Better to get it fixed NOW rather than later on when it could have gotten worse…to the point of not being able to be rebuilt!

I wonder if it had anything to do with me moving my entire Plex system from one computer to the other about 2 1/2 years back. It seemed like a kinda complex maneuver…but it worked out well and the system has been up and running on the new server for the past 2 1/2 years. BUT…maybe the corruption occurred (originally?) at that point?

Who knows. I’ve been in IT for 40 years and I could write a book on the “strange, incomprehensible” things I’ve seen!

Thanks again for all your help.

15

It could have been from that, or at some point the PC wasnt turned off correctly (AKA power outage)

16

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