Upgraded to v1.41.0.8992, No Videos will play

Plex Media Server Desktops & Laptops
,
1

Server Version#: v1.41.0.8992
Player Version#: 8.39 (AppleTV)
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

Upgraded server (docker) to v1.41 this afternoon. Most screens in the Plex app for Apple TV take a while to load and attempting to play a video will spin for 10-20 seconds and then give a cannot play error.

Rolling back to 1.40.5 on server and things return to “normal”.

Logs attached.

Plex Media Server Logs_2024-09-16_20-07-30.zip (996.6 KB)

2

Thanks, I looked through the logs but I don’t see any playback requests for anything.

Were these logs taken after attempting to play something?

3

Yes.

I restarted the docker container and selected a video to show. When I compare it with the 1.40.5 logs under the same isolated restart-and-play-that-video workflow, I do see the log entries with specific video information and the video starting to play.

Using both versions, I see a PlayQueues call (with “97 generated IDs compressed down to a 204 byte blob.” as part of the log events after that call). In 1.40.5, it quickly thereafter plays the video.

So it is possible that the client is trying to play but the server isn’t able to accept the request within the timeout period.

4

Where can I download older versions of the PMS installation package for Mac?

5

I encountered a similar issue. I upgraded to version 1.41.0.8992 yesterday, and it was running fine at first. Today, I set the Ad Detection for a TV library to “For all items,” which automatically scanned the library. After a while, when I tried to access my server again, the issues started occurring.

Here’s what happened:

  • The “Recommended” section for all libraries couldn’t display, showing the error “Something went wrong - An unexpected error occurred.”
  • All libraries, except for TV shows and music, couldn’t display their Library pages, with the same error “Something went wrong - An unexpected error occurred.” TV shows and music libraries could display the Library page, but accessing any specific item would also trigger the error “Something went wrong - An unexpected error occurred,” meaning no items were accessible.
  • For the TV shows and music libraries that were still displaying, none of the items could be played. Attempting to play them resulted in “Playback Error - An error occurred loading items to play.”
  • Collections and Categories for all libraries could display, but none of the specific items within them could be opened.
  • The movie libraries and the “Continue Watching” section have disappeared from the Home page, and some of the TV libraries are missing as well.

What I tried:

  • My PMS is installed on a Mac. I tried restarting the Mac and reinstalling version 1.41.0.8992, but neither of these resolved the issue.
  • I followed the instructions for “Repair a Corrupted Database,” and the server status showed as OK, indicating no corruption was detected. I still went ahead with the repair process, but it seemed to have no effect.
  • I want to try rolling back to an older version of PMS, but I don’t know where to download the older installation packages for Mac.

I will send you my server logs via private message in the hope that you can offer some help. Right now, my Plex is completely unusable.

6

@x1ao4: Thanks for the added input. Hopefully this will help them troubleshoot further.

After your message, I switched off Ad detection and tried 1.41 again but there was no real change to my issue.

Then I also disabled all non-scheduled scanning including the new Voice Activity scanning and there doesn’t seem to be any improvement.

I jumped around and tried to play other videos. Some would spin but then play after about 10 seconds. The UI is still slow on apple TV.

On the video files that fail to play in 1.41 (but play in 1.40.5), I see the following warnings and errors:

Sep 17, 2024 12:23:06.421 [127481625455416] ERROR - [Req#f615] Unknown metadata type: folder
Sep 17, 2024 12:23:06.421 [127481625455416] WARN - [Req#f615] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.

These might be unrelated but they only seem to pop up in the PMS log when I try to play one of the unplayable videos.

7

@drzoidberg33 I found the installation package for version 1.40.5.8921, and after reinstalling 1.40.5.8921, everything returned to normal. There seems to be a bug with version 1.41.0.8992.

1 Like
8

You have a corrupt blobs database.

Sep 17, 2024 19:16:56.611 [0x70000d047000] ERROR - SQLITE3:(nil), 11, database corruption at line 68825 of [a29f994989]
Sep 17, 2024 19:16:56.611 [0x70000d047000] ERROR - SQLITE3:(nil), 11, database corruption at line 68975 of [a29f994989]
Sep 17, 2024 19:16:56.611 [0x70000d047000] ERROR - SQLITE3:(nil), 11, statement aborts at 9: [SELECT bl.`id` FROM blobs bl WHERE (bl.`linked_type`=:C1 AND bl.`linked_id`=:C2 AND bl.`blob_type`=:C3)] database disk image is malformed
Sep 17, 2024 19:16:56.611 [0x70000d047000] ERROR - Exception handled: std::exception

You can follow the instructions here: https://support.plex.tv/articles/repair-a-corrupted-database/ but instead of working on the main database file com.plexapp.plugins.library.db, open the blobs database file instead: com.plexapp.plugins.library.blobs.db

9

Thank you for your response.

I checked the file “com.plexapp.plugins.library.blobs.db” and got the following results (partial excerpt):

*** in database main ***
On tree page 280 cell 0: 2nd reference to page 912437
On tree page 280 cell 10: 2nd reference to page 912399
On tree page 280 cell 9: 2nd reference to page 912359
.
.
.
Page 904334 is never used
Page 904335 is never used
Page 904336 is never used

I’m not quite sure how to proceed with the repair now. What should I do? I don’t fully understand the instructions in Repair a Corrupted Database.

10

I had this same issue, my TV shows and Movies libraries were not loading, photos were fine. This and many other threads pointed to a DB issue, so I ran the Plex DB Repair tool on Automatic and it said that both the DBs were OK, went ahead and did the optimize process using that tool and all looked good. Restarted the server and still had the same issue. Next step was to downgrade to 1.40.5 and immediately libraries were back and accessible. I can provide logs if needed, I have them from before I downgraded and afterwards, please DM me. Thanks.

11

Assuming you were able to load the database file to run the other commands and aren’t sure about the low level database recovery part.

load the database again in Plex SQLite and then enter these commands. This points the output to the file db-recover.sqlite and then executes the recover command (don’t miss the dots at the beginning of each command.

.output db-recover.sqlite
.recover

then exit the tool (using the .quit command).
then mv the com.plexapp.plugins.library.blobs.db to another name to keep it just in case. For example “mv com.plexapp.plugins.library.blobs.db com.plexapp.plugins.library.blobs.db.original”

Now load Plex SQLite with the old file name (com.plexapp.plugins.library.blobs.db) and execute the read command which will take the data from the db-recover.sqlite file you created above and create the data in the com.plexapp.plugins.library.blobs.db file.

.read db-recover.sqlite

now you can .quit Plex SQLite again and check to make sure the com.plexapp.plugins.library.blobs.db file has the correct owner and group (that is for linux like mine but not sure this is an issue on MacOS).

Your blob database is now rebuilt.

12

After entering .output db-recover.sqlite, there was no response, and I couldn’t find the db-recover.sqlite file.

13

That command just points any future output. The file is created with the .recover command

14

I am having a similar problem after upgrading to this version. Immediately after stopping the server app on the server (or rebooting) and restarting, I am able to play videos. But at some point it stops working again. Running server x64 on Windows 10.

I will check databases.

Logs available if needed, but no errors or warnings appear. The video player just spins.

1 Like
15

When entering .recover, no file was generated either.

16
  • you ran the Plex SQLite command with the filename com.plexapp.plugins.library.blobs.db? This loads that existing blob database file.
  • After entering .output db-recover.sqlite and then .recover, then .quit there was no file named “db-recover.sqlite” in the directory from which you ran the Plex SQLite command?

This is the extent of my ability to help, based upon my experience doing this the last couple of days and the Plex support document. This should generate a dump of your database in the db-recover.sqlite file which can then be imported (.read) back into an empty file to rebuild the blob database.

Sorry.

17

Alright, thank you for your help. I tried again, and now the recovery was successful.

1 Like
18

Can confirm, same issue here.

I’ve narrowed it down a bit. From the WebUI there’s API requests being made to /hubs/sections/1?count=12.... . On 1.40.x these responses on my server come back in <1s. On 1.41.x the same requests on my server are typically taking 1 - 2 minutes to return (In playing around I’ve seen some responses take 15 minutes). I had a little hack at different URL parameters to see if excluding external metadata, etc, had any impact but didn’t seem to. Looking at the network debugger in my browser I can see the requests made by the Web UI to this endpoint are terminated by the client after 30s, so they never succeed. I presume the various clients are doing a similar abort-after-30s and exhibit the same behaviour. On 1.41.x there’s no errors being reported in my logs, even with verbose, and I’ve done various SQLite integrity checks/Plex repair tools/Plex Web UI Optimizes, etc, and none of them indicate any kind of issue with the DB or make a difference. The moment I roll back to 1.40.x the same API request are back to <1s response times.

1 Like
19

Since nothing was evident in the server logs, I captured the Apple TV app logs from an attempt this morning which I am attaching here.

Also, this morning I installed a separate-but-clean install of 1.41 with just one library and one file (one of the ones that fails to play). It, of course, played without issue. This doesn’t discount a general bug but instead confirms to me that 1.41 will play the media and thus it isn’t a codec, transcode or other issue related to the file.

logging.zip (66.8 KB)

I will not even try to figure out what is going on in the attached log file but I did see attempts to access the media (British TV series “Would I Lie To You?” Season 8 Episode 8).

20

I had to rollback because the codec in the hardware encoding is will not work for anything above 3mg video. This is with I5 processor but i would assume it is impacting many