Content Unavailable when connecting remotely

Server Version#: 1.24.3.5033
Player Version#: various
Plex Media Server.log (776.5 KB)

Movies play locally. But when attempting to play from my remote Roku I get “Content Unavailable” on some, not all my movies. I attempted to play them on my Samsung Galaxy and they have a similar error “Something went wrong”.
I logged into my local Plex server and the non-playing movies are missing a poster. I can download them directly, but can’t play through plex.
I’ve verified I have the latest server version and rebooted and optimized database with no luck.
Can anyone assist? I’ve attached my server log.
Thanks.

You have a lot of database corruption errors. I would try to restore a backup or try to repair.

I’m going to attempt a repair.
The instructions in the repair guide aren’t specific to a Synology NAS and the commands don’t work as illustrated.
I’m working out of the "/var/packages/Plex Media Server/target/Plex SQLite" directory.
I’m not sure how to translate the corruption check command from the Windows instructions to Linux.

com.plexapp.plugins.library.db "PRAGMA integrity_check"

Hunted around the forums. Found this is the location for the query:

“/volume1/@appstore/Plex Media Server/Plex Media Server” --sqlite “/volume1/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” “PRAGMA integrity_check”

It returns:

*** in database main ***
Page 69244: btreeInitPage() returns error code 11
Page 69243: btreeInitPage() returns error code 11
Page 69242: btreeInitPage() returns error code 11
Page 69241: btreeInitPage() returns error code 11
Page 69240: btreeInitPage() returns error code 11
Page 69239: btreeInitPage() returns error code 11
Page 69238: btreeInitPage() returns error code 11
Page 69237: btreeInitPage() returns error code 11
Page 69464: btreeInitPage() returns error code 11
Page 69463: btreeInitPage() returns error code 11
Page 69462: btreeInitPage() returns error code 11
Page 69461: btreeInitPage() returns error code 11
Page 69484: btreeInitPage() returns error code 11
Page 69483: btreeInitPage() returns error code 11
Page 69482: btreeInitPage() returns error code 11
Page 69481: btreeInitPage() returns error code 11
Page 69480: btreeInitPage() returns error code 11
Page 69479: btreeInitPage() returns error code 11
Page 69478: btreeInitPage() returns error code 11
Page 69477: btreeInitPage() returns error code 11
Page 69476: btreeInitPage() returns error code 11
Page 69475: btreeInitPage() returns error code 11
Page 69474: btreeInitPage() returns error code 11
Page 69473: btreeInitPage() returns error code 11
Page 58192: btreeInitPage() returns error code 11
Page 58191: btreeInitPage() returns error code 11
Page 58190: btreeInitPage() returns error code 11
Page 58189: btreeInitPage() returns error code 11
Error: database disk image is malformed

Ran the recovery command:
“/volume1/@appstore/Plex Media Server/Plex Media Server” --sqlite “/volume1/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” “.output recover.out” “.recover”

No output on console.
Ran integrity check. Same error.

Please advise.

If you go into the Plex shared folder using FileStation

Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases

You should find:

com.plexapp.plugins.library.db - this is the main database

You should also find several backups of it with a date/time stamp appended to the name.

The easiest repair method is

  1. Stop Plex

  2. Rename com.plexapp.plugins.library.db and add a -bad to it. We can delete it as the last step

  3. Now make a copy of the most recent database backup file . It will end up with a (1) in the name.

  4. Rename that copy file to be com.plexapp.plugins.library.db

  5. Right-click it and verify it’s still owned by user plex. Change if not.

  6. Start Plex

  7. IF everything looks good (all functioning), Scan files & Refresh the metadata for each library section you have to make certain it’ in sync with changes.

IF this ‘copy’ is also damaged, repeat the process with the next older backup until you get to good one.

My backup files are in this format. -2021-09-24
I renamed the latest one and started Plex.
Plex said it needed to update my libraries as they were out of date with a legacy agent.
This is the process I went through yesterday that broke all my media.
I’ll report back if it works this time. Going to take awhile.
Thank you.

None of my media is available now.
“Something went wrong” when I attempt to browse to it on my PC.
Remote connection gives “no items to display” on one and an empty library on the other. Plex Media Server.log (3.3 MB)

Logs are attached.

Your backup is corrupted as well.

Repeat the process again until you run get one that doesn’t have a problem.

I have seen cases (very rarely) where the data got corrupted (abrupt poweroff, etc) and the database didn’t shutdown cleanly.

The longer that hangs around , the greater the chance of this type problem occurring.

All of the backups are corrupted.
How do I proceed?

You need to start from scratch as there is nothing recoverable.

  1. Delete all the files
  2. Settings - Authorized Devices - Server (dropdown)
  3. REMOVE the server entry so it doesn’t get hung up when starting over.

Delete all the files in the Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases folder?

If the server won’t start, how do I go to Settings - Authorized Devices - Server ?

Your server does not need to be running to access Authorized Devices.

Screenshot (840)

Just to clarify, delete everything in the databases folder and remove the server entry in authorized devices?
From there I reinstall the server within the NAS?
Thanks.

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