Plex Becomes Unresponsive - "Waited over 10 seconds for a busy database"

[manofoz]

Hello,

I am experiencing an issue with Plex that I have tried a few things to get around but so far no luck. Plex is becoming 100% unresponsive and requires a bounce. When this happens it spits out these logs:

 

 

It seems to happen while Plex Meta Manager is applying new overlays and something triggers a scan. They recommended I boost the "Database Cache Size (MB)" which I set to 16 GB

 

 

I also read on here that it was faster to point Plex right at the cache than at the user share so I tried that:

 

 

All of my DB files are on a Raid 1 2x2TB Crucial P3 Plus NVME SSD which is specced for 5000 MB/s read, 4200 MB/s write. I read I could move them to a RAM disk but that seems like a bad idea as the author of the guide for that had no plans for unexpected shutdowns and everything would be lost.

 

 

Anyone have a simular issue and fine a way to overcome it? 

 

Integrity check of the db came back "ok":

/mnt/cache-apps/appdata/Plex-Media-Server/databasetools/plexmediaserver# "/mnt/cache-apps/appdata/Plex-Media-Server/databasetools/plexmediaserver/Plex SQLite" "/mnt/cache-apps/appdata/Plex-Media-Server/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" "pragma integrity_check"
ok

 

Thanks!

Edited September 29, 2023 by manofoz

[manofoz]

Posted over on Plex forums, not sure what kind of support they offer: https://forums.plex.tv/t/plex-becomes-unresponsive-db-locked-busy-logged-while-unresponsive-pragma-integrity-check-ok/855275