Plex Crashes Every 3 Days at 3:30am Due to System "Out of Memory" Since PMS 1.24.4.5081

[heygaul]

hmm im reading this page and for some reason my brain isn’t working I cant figure out what you did to resolve the crashing? I just went 3 days with no crash, then had a random crash but haven’t done anything you’ve done…

[SuperDragonite]

Here’s where the fix started being talked about/given:

Plex Crashes Every 3 Days at 3:30am Due to System "Out of Memory" Since PMS 1.24.4.5081

@SuperDragonite - appears that the purge was running whilst the server was crippled because a request came in at 09:31:52 to get the metadata for the movie and that was request was still in progress 2 hours later when the server crashed with OOM. This request is what led to the OOM failure. In parallel to this the library was being scanned and the extras were being purged - but very little memory free And it appears the purging has not been committed to the database and the new database copy s…

[sa2000]

@SuperDragonite

No crashes so far! Here is an export of today’s logs and database one week after the fix, as you requested. Please let me know if you need anything else from me! I really appreciate your help with this!

Thanks - database looks good with no massive additions. Last set of additions were 6 extras for a couple of movies

[SuperDragonite]

Awesome! Again, thank you for your help!

[kamakiri]

How do you run the command. I logged in VIA ssh and I get

$ “/var/packages/PlexMediaServer/target/Plex SQLite” -header com.plexapp.plugins.library.db “select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_item_id order by count(metadata_item_id) desc limit 20;”
-sh: syntax error near unexpected token `(’

[davidjwbailey]

None of these are acceptable solutions for a consumer media server - risky, require advance skills, and are not going to work for everyone - the problem is crashing a LOT of Plex instances and is not just “one database entry”. A memory leak that crashes the whole App and can crash TruNAS is a serious Grade A bug that demands immediate patching and release to the community. Come on team, please?

Version:

1.24.5.5173

Dec 10 08:15:45 MAGPIESNAS kernel: vnet0.5: promiscuous mode enabled
Dec 10 08:15:45 MAGPIESNAS kernel: lo0: link state changed to UP
AGPIESNAS swap_pager_getswapspace(16): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(12): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(17): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(13): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(10): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(8): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(6): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(7): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(28): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(14): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(5): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(4): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(11): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(4): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(25): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(22): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(8): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3)[969]: Last message ‘failed’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(21): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(19): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(8): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3)[969]: Last message ‘failed’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3)[969]: Last message ‘failed’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(21): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(19): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(8): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(8): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(8): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(8): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(20): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(18): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(9): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(3): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(2): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(4): failed
Dec 10 04:13:43 MAGPIESNAS swap_pager_getswapspace(32): failed
Dec 10 04:13:43 MAGPIESNAS kernel: pid 46237 (Plex Script Host), jid 4, uid 972, was killed: out of swap space
Dec 10 04:13:43 MAGPIESNAS kernel[969]: Last message ‘pid 46237 (Plex Scri’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS kernel: pid 88539 (Plex Script Host), jid 4, uid 972, was killed: out of swap space
Dec 10 04:13:43 MAGPIESNAS kernel[969]: Last message ‘pid 88539 (Plex Scri’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS kernel: pid 326 (python3.9), jid 0, uid 0, was killed: out of swap space
Dec 10 04:13:43 MAGPIESNAS kernel[969]: Last message ‘pid 326 (python3.9),’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS kernel: pid 88545 (Plex Script Host), jid 4, uid 972, was killed: out of swap space
Dec 10 04:13:43 MAGPIESNAS kernel[969]: Last message ‘pid 88545 (Plex Scri’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS kernel: pid 46260 (Plex DLNA Server), jid 4, uid 972, was killed: out of swap space
Dec 10 04:13:43 MAGPIESNAS kernel[969]: Last message ‘pid 46260 (Plex DLNA’ repeated 1 times, suppressed by syslog-ng on MAGPIESNAS.local
Dec 10 04:13:43 MAGPIESNAS 1 2021-12-10T04:13:43.813008+00:00 MAGPIESNAS.local upsmon 1197 - - Poll UPS [CP1500EPFCLCD@localhost:3493] failed - Server disconnected

[sa2000]

@davidjwbailey

None of these are acceptable solutions for a consumer media server - risky, require advance skills

If your problem is caused by the issue that leads to massive number of extras being added for a movie, we are working on a fix at the moment - see Slow library performance due to increasingly growing database - #45 by sa2000

[sa2000]

@kamakiri

“/var/packages/PlexMediaServer/target/Plex SQLite” -header com.plexapp.plugins.library.db “select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_item_id order by count(metadata_item_id) desc limit 20;”

could be a problem with the quote characters.

A fix is being worked on at the moment for the massive extras issue

[heygaul]

so i turned off optimize and backup database under schedued tasks, no crashes for 2 weeks, turned it back on, now crashes are back. so frustrating. plex is running like ass, so its clearly a movie file causing the crashing but i cant figure out which one…

[sa2000]

@heygaul

So i turned off optimize and backup database under schedued tasks, no crashes for 2 weeks, turned it back on, now crashes are back. so frustrating. plex is running like ass, so its clearly a movie file causing the crashing but i cant figure out which one

Are there any logs ?

Could you run the sql in step 1 on this forum post on your database to see if it is the extras issue

Slow library performance due to increasingly growing database

Hi I will follow up with all the diagnostics you provided tomorrow - but would like confirmation if I need to change any of the instructions that I have Step 1 Identify if the issue relates to extras and identify the metadata id’s affected select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_item_id order by count(metadata_item_id) desc limit 20 Step 2 (extra info for me) Identify the movie and guid (for each of those returned above with lots of extras…

[sa2000]

I have a Plex Media Server development alpha build available now with a fix for the massive number of extras (trailers / clips / scenes) problem that result in massive increase to the database size and crashes due to memory allocation failures and hangs

Anyway want to try out this build, please let me know and indicate which platform / build it is needed for and I will make it available

The fix is explained in my forum post here Slow library performance due to increasingly growing database - #48 by sa2000

[sa2000]

Anyone having a massive count returned for the first listed item from this SQLITE db query on the PMS database, is welcome to try out the alpha build

select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_item_id order by count(metadata_item_id) desc limit 20

This lists the count of extras in descending order and any with hundreds of thousands in the count in the first column displayed in the query result should try out the fix

[heygaul]

I don’t feel comfortable doing the SQL, I’ve submitted for alpha testing

[sa2000]

@heygaul

I don’t feel comfortable doing the SQL,

If I send you the alpha, I would need some indication that

• you do have the massive trailers / extras issue
• your Plex Media Server database is very large

With this alpha, the duplicate extras/trailers will be removed on launch of the new version and then after that the database will shrink in size after every database optimize (scheduled once a week or manually requested via Troubleshooting Plex Web Server Setting interface)

The reduction in size will be over a period of time - as we only purge 100K at a time for each Optimize - so if there are a million - then it would take 10 weeks for scheduled tasks to bring down the size right down - 10 db optimize actions

The actual size is released after Plex Media Server shutdown - so needs a restart every now and then

If you can find out the size of the database - then that will give me an indication that you may have the trailers/extras issue and I will make the release available to you

For DSM 7 the Database files are here

/volume1/PlexMediaServer/AppData/Plex Media Server/Plug-in Support/Databases

and filenames

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

When PMS is running - all 3 files will be present. After tidy shutdown - the db gets consolidated into
com.plexapp.plugins.library.db

[heygaul]

Had a crash again around 3am.

Database is large, 22TB worth of films…

I have multiple file names such as

com.plexapp.plugins.library.db-2021-12-20

With various dates that are 5.71GB each.

com.plexapp.plugins.library.db is also 5.71GB.

There are 4 files dated + non dated file each are 5.71GB.

They are consistent with crash dates as well.

[heygaul]

[sa2000]

@heygaul

With various dates that are 5.71GB each.

com.plexapp.plugins.library.db is also 5.71GB.

I have sent you the download for DSM 7 intel 64-bit spk

[lailoken01]

select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_item_id order by count(metadata_item_id) desc limit 20;

count(metadata_item_id)|metadata_item_id
524289|55195
59|42130
…

select id, title, guid, refreshed_at from metadata_items Where id = ‘55195’;

id|title|guid|refreshed_at
55195|Life, Above All|plex://movie/5d776880d11dd30020226dff|2021-11-11 03:45:38

select metadata_item_id, related_metadata_item_id, created_at from metadata_relations Where (metadata_item_id = ‘55195’ ) order by created_at desc limit 20;

metadata_item_id|related_metadata_item_id|created_at

55195|588241|2021-11-11 03:43:55
<same value repeated 20 times>

DELETE FROM metadata_relations WHERE (metadata_item_id IN (55195));

<doing cleanup SQL … it’s taking long>

I’ll try the Alpha build as well…

[heygaul]

ive been testing the alpha, its working very well… plex is super speedy again.

[grahamkilbourn]

I have a DB with multiple 2.6gb files with different dates and would also be glad to give the alpha a run if I meet the criteria.

Running the PMS on a Synology NAS