Plex Deadlocking with to many hung connections issues for last 5 months Now!. (This ended up giving me anxiety attacks!) (Edited title for clarification)

@morpheus2n2 take a look at this thread Dead in the Water after Version 1.23.6.4810 Update - Database Locked

1.23.6 caused some problems and another beta build will be coming soon.

You could try the latest 1.23.5 released a few hours ago which contains a fix for that issue if you can’t wait for the beta.

Yeah on that now, however its coursing the connection deadlocking that I was not experiencing in the build previous to it.

I thought I had finally solved and got rid of 5 months of deadlocks and anxiety for it to go bad in the space of one day due to the build that went out this morning :frowning:

Another day another deadlock, this is definitely, increasing in frequency again @sa2000 yet more diagnostics sent, this is now getting beyond a joke

I have referred one set of your diagnostics to our development team - Plex Media Server-3.DMP and associated logs and connections list

I can see that we are getting 20 metadata requests at a time - possibly this is overloading the server and may be your database access is slow and needing a database optimize. I would suggest raising this with the developers of Overseerr to see if they can do some testing and may be reduce the load on the server and number of parallel requests

I have processed the last set and referred the diagnostics to the development team

1 Like

Awesome

I already previously optimized the database and went ahead and did it again before testing Overseerr. I see the same exact issue as before.

Has just done it again I got 5 days out of it this time, I also caught it early in the lock!

I haven’t had any deadlocking since I put outside access behind an nginx proxy that is only accessible via subdomain and not IP address.

How would that work for remote clients?

I also see it a hell of a lot from Xbox’s =, it has happed twice now tonight within 20 mins of each other and looking at the connections page right now its already building up to happen again, the thing is the only people using it are my Kids so its all local connections currently, but for example My sons Xbox has opened 20 connections to Direct Play a film, we have even just done a network reboot to try and fix

Get rid of the xbox clients and see if the issue goes away. A lot of the Plex clients are garbage.

pmsl yeah would love to but Kids use them, I have asked them to start using Emby over Plex cos of this, I have had no problems with Emby at all stability wise Plex on the other had has been a utter nightmare for last 5 months :rofl::rofl:

I have actually just sent my 3rd yes THIRD set of diagnostics within a hour, this issue is clearly so very far from sorted!! @sa2000

I was curious if removing Tautulli from the equation might improve things; it figured (equally?) prominently in the log snippets from post 37.

Yeah thats not been a issue for a while now, its clients namely Xbox Clients and Amazon Firesticks there’s are the ones that do the most damage in the last few builds

I have upgraded to the build that has literally been pushed out in last 10 mins (Build 1.23.6.4881) lets see how this one is :worried:

Another thing I have done is got rid of ALL my Android clients. Maybe this is the reason the issue hasn’t shown back up. The Android client is complete garbage.

Yeah I have just gone through all my old connections grabs and the ones that pop up 99% of the time is Xbox One, Fire Stick (Android) and I have one set with Apple TV (that client has not connected since) only in 2 sets do I see Tautulli and Petio (Overseer alternative).

So Basically this is telling me that the Android App and the Xbox App are part of the root problem, especially seen as they can easily open up 100 connections alone for a single Direct play file ( I know its direct play as I can see it in the GUI just before it gose bad).

I’m not sure it’s just Android Apps and Xbox apps. I have Roku clients right now that are opening up 20 connections just to direct play a movie. (Plex for Roku, 6.8.3.7132-9d030676d-Plex, Roku, 10.x, Roku 3, 4200X)

Ahh I don’t have anyone on Roku so wouldn’t know that one lol