Server Version#:1.25.0.5220 Player Version#:4.66,1 Wondering if anyone could help me as I am at my wit’s end. Running Plex on a docker container on a fresh new box. Could someone please confirm if it’s normal to have a whole host of “waited one whole second for a busy database” or “Held transa…

Which PMS version are you using?

This just occurred again this morning. In fact PMS consumed so much memory this time that the server ran out of memory and took down my virtual machines. Database exploded from 711M to 990M between 00:30 to 01:30 (on hour). Looking at that dashboard it was spinning again on Alien Directors Cut… …

It only takes a few minutes now before it freaks out. I’ve attached the logs and database. Plex Media Server Databases_2018-07-11_15-15-16.zip (22 Bytes) Plex Media Server Logs_2021-12-05_05-48-17.zip (2.0 MB) Edit: I’ve reverted to an even older database from yesterday and I’ve turned of the a…

@Ryushin I recommend creating a fresh server (Preserve the DB) After creation, migrate the watch history. I’ve not seen anyone with as much difficulties as you have so therefore wonder if there is a corruption so deep that we’ll never find it. Possible ?

With the amount of time I have invested in my Plex layout, creating a fresh install is not very feasible. Thing is, I never had this kind of problem until the update came out. Leaving off the “Scan library automatically” function and just have it run periodic every 15 minutes seems to be stable. D…

I’ve tried migrating watch history before from one old DB to a brand new fresh install following your (plex tutorials) instructions and was SOL. Had to resort to a trakt import via a not well maintained trakt plugin.

@Ryushin I might have something about resolving this. This is a sqlite3 query on a DB to see if it has the multiple-IVA record problem. Inspect [chuck@lizum plexdb.2007]$ sqlite3 com.plexapp.plugins.library.db SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> sel…

Thanks Chuck, My database is now 267MB. Though I had a go about a different way to get it repaired. The SQL Query to look for multiple-IVA record problem: select count(metadata_item_id),metadata_item_id from metadata_relations group by metadata_item_id order by count(metadata_item_id) desc limit…

May I see the DELETE FROM statements you used so I can try it on others’ databases ? If I can find the sequence to do it via SQL, I’ll craft some script-foo to construct SQL statements and perform the deletions with PMS stopped (which will be MUCH faster). What I’m hoping to craft (you’ve seen my…

My com.plexapp.plugins.library.blobs.db is 670mb, and my com.plexapp.plugins.library.db is 199mb, I guess that counts as big? I’ve been debugging; QueryParser: Invalid field ‘pinnedContentDirectoryID’ found, ignoring. QueryParser: Invalid field ‘contentDirectoryID’ found, ignoring. Exception cau…

DB locks and wait times

Plex Media Server

ChuckPa December 11, 2021, 6:54pm 55

@plexmei

May I please see the DEBUG log ZIP file which captures this?

Please respond back in your existing thread.

Topic		Replies	Views
Slow Query time - unable to scan or play media Plex Media Server server-linux	65	1782	February 22, 2022
Slow library performance due to increasingly growing database Plex Media Server server-linux	77	3008	May 23, 2022
Calling all users with MASSIVE libraries Plex Media Server server-linux	24	478	May 12, 2022
Slow or unresponsive Plex Debian Server Plex Media Server server-linux , server-docker	38	1125	April 21, 2022
I think something may be wrong with my Plex database, how can I be sure? Metadata & Adding Files server-mac	10	1334	November 14, 2020

DB locks and wait times

Related topics