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

We have looked into all the diagnostics and your issue is not a deadlock but very slow disk transfers for the database.

In both process dump snapshots there is a thread that is in kernel reading disk.

Perhaps there is a bad area on the disk - the database is in this directory
C:\Users\Plex\AppData\Local\Plex Media Server\Plug-in Support\Databases

Files

com.plexapp.pligins.library.db
com.plexapp.pligins.library.db-shm
com.plexapp.pligins.library.db-wal

So it could be some disk errors repeat action perhaps slowing access. Hoping we would see that from the windows event logs:

Export the Windows Event Logs (Application and System logs) - Run Event Viewer \ Select Windows Logs then System then Save All Events As and save into a .evtx file. Do the same for the Application log and zip the two exports and send me in private message

Could it be some anti virus software interfering with the file reads ?

This chart shows the time taken to handle a couple of specific requests with extensive delays starting at about 14:50 on the 8th of August
image

Suggest checking out the drive