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

[sa2000]

The steps outlined in the linked forum thread:

Deleting the items in metadata_relations table
In your case it would be this change

DELETE FROM metadata_relations WHERE metadata_item_id = '15484';

and after committing that change - then purging all orphaned items - which can be done using an sql.txt file provided here

Slow Query time - unable to scan or play media

To update anyone else having a slow DB issue and/or a large DB filesize, the search + fix was a combination of two items. Most of the info below is above, but this hopefully summarizes it: Identifying an item in the DB that had over 2 million associated files Editing the DB to remove all those entries Step 1 was given by @Volts using this command: sqlite3 -header com.plexapp.plugins.library.db “select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_it…

The binary used is covered here
Repair a Corrupted Database | Plex Support

(I am actually part time and my next day on Plex is Wednesday - so you will need help from others)