hello dears
I have a large library of series and movies exceeding 80 terabytes, and all of them have been added to collections in plex
But I am facing a problem with the whole day, as the plex library stops responding in web interface and all platform plex media player the library stops working and I had to stop up and start plex media server until it works again. Do you guys have any solution to that problem and a facility for you logs
Plex Media Server Logs_2023-06-16_22-23-19.zip (5.0 MB)
It looks like your database is extremely fragmented or possibly overloaded by the number of items indexed (?)
How many media files do you have approximately ?
( combination of movies, episodes, music , photos )
Jun 16, 2023 22:14:58.941 [139660822555448] WARN - [Req#5616d8] SLOW QUERY: It took 1290.000000 ms to retrieve 30 items.
Jun 16, 2023 22:14:58.975 [139661078289208] DEBUG - Auth: authenticated user 17202305 as ALFA
I can see you’re running an XPEnology configuration.
How much memory do you have installed in the system for PMS?
Also want to ask how good your ssh command line skills are?
1 Like
thanks for help
i have 32000 movies 1950 tv series no music no photo
yes im using xpenlogy
Before that I was using unraid os With a hard ssd to save Plex files and database, and I also had the same problem with databases, that it had a delay
i have Memory 32GB and dual CPU
Use ssh command line well
I’m concerned your DB has gotten so large the single-threaded DB operations can’t complete it time and things get backed up.
I recommend you give this a shot first.
It does a level of DB optimization which PMS cannot while it’s running.
Also, if there are dead records in your database, it will remove them too.
Run it as ‘sudo’ (root user) so it has permission to read/write the DBs.
Instructions are in the README.md
Ask if you have questions
Let’s see how it does after this.
Please do realize just how much media you have with how problematic it will be on your CPUs (the per-core speed is not very high)
1 Like
Thank you very much for your help
I have followed the enclosed instructions accurately
Enter command # -or- command name (4 char min) : auto
Automatic Check,Repair,Index started.
Checking the PMS databases
Check complete. PMS main database is OK.
Check complete. PMS blobs database is OK.
Exporting current databases using timestamp: 2023-06-17_16.28.52
Exporting Main DB
Exporting Blobs DB
Successfully exported the main and blobs databases. Proceeding to import into new databases.
Importing Main DB.
Importing Blobs DB.
Successfully imported databases.
Verifying databases integrity after importing.
Verification complete. PMS main database is OK.
Verification complete. PMS blobs database is OK.
Saving current databases with '-BACKUP-2023-06-17_16.28.52'
Making repaired databases active
Repair complete. Please check your library settings and contents for completeness.
Recommend: Scan Files and Refresh all metadata for each library section.
Backing up of databases
Backup current databases with '-BACKUP-2023-06-17_16.47.42' timestamp.
Reindexing main database
Reindexing main database successful.
Reindexing blobs database
Reindexing blobs database successful.
Reindex complete.
Automatic Check, Repair/optimize, & Index successful.
And run Plex again after completing all the steps
I will follow it up today
To note, has the problem been resolved or is it still there?
Thank you
If you look at “Plex Media Server.log” and do not see “SLOW QUERY”
then there is a good chance the problem has been resolved.
My little tool cannot definitively say it has fixed this type of problem.
1 Like
Unfortunately, the problem of SLOW QUERY appears from time to time after executing the script as well
Line 1684: Jun 18, 2023 04:43:36.524 [140344555969336] WARN - [Req#2a4611] SLOW QUERY: It took 210.000000 ms to retrieve 50 items.
Line 1762: Jun 18, 2023 04:43:36.684 [140344532417336] WARN - [Req#2a4528] SLOW QUERY: It took 640.000000 ms to retrieve 10 items.
Line 1769: Jun 18, 2023 04:43:36.739 [140344564878136] WARN - [Req#2a461c] SLOW QUERY: It took 240.000000 ms to retrieve 50 items.
Line 1808: Jun 18, 2023 04:43:36.768 [140344532417336] WARN - [Req#2a4528] SLOW QUERY: It took 220.000000 ms to retrieve 4 items.
Line 2099: Jun 18, 2023 04:43:38.503 [140344555969336] WARN - [Req#2a464d] SLOW QUERY: It took 380.000000 ms to retrieve 24 items.
Line 2168: Jun 18, 2023 04:43:38.559 [140344558078776] WARN - [Req#2a46a0] SLOW QUERY: It took 340.000000 ms to retrieve 50 items.
Line 2174: Jun 18, 2023 04:43:38.562 [140344596122424] WARN - [Req#2a469f] SLOW QUERY: It took 370.000000 ms to retrieve 50 items.
Line 2450: Jun 18, 2023 04:43:38.888 [140344564878136] WARN - [Req#2a46a2] SLOW QUERY: It took 270.000000 ms to retrieve 50 items.
Line 2454: Jun 18, 2023 04:43:38.921 [140344493718328] WARN - [Req#2a46a4] SLOW QUERY: It took 310.000000 ms to retrieve 50 items.
Line 2456: Jun 18, 2023 04:43:38.976 [140344562768696] WARN - [Req#2a46a1] SLOW QUERY: It took 430.000000 ms to retrieve 50 items.
Line 2988: Jun 18, 2023 04:43:40.754 [140344596122424] WARN - [Req#2a472e/Req#2a4730] SLOW QUERY: It took 260.000000 ms to retrieve 1 items.
Line 3057: Jun 18, 2023 04:43:41.891 [140344553859896] WARN - [Req#2a4738/Req#2a475c] SLOW QUERY: It took 260.000000 ms to retrieve 76 items.
Line 3246: Jun 18, 2023 04:43:42.997 [140344553859896] WARN - [Req#2a47c2/Req#2a47c9] SLOW QUERY: It took 310.000000 ms to retrieve 34 items.
Line 3251: Jun 18, 2023 04:43:43.026 [140344532417336] WARN - [Req#2a47c4/Req#2a47cb] SLOW QUERY: It took 400.000000 ms to retrieve 88 items.
Line 3289: Jun 18, 2023 04:43:43.350 [140344564878136] WARN - [Req#2a47d1/Req#2a4809] SLOW QUERY: It took 380.000000 ms to retrieve 85 items.
Do you suggest any other solutions to solve my problem?
thanks
In total, how many media files do you have ?
(1950 tv series can get very large . 1950 * 4 seasons * 24 / season = 187,200 files)
I’m afraid you might be running out of CPU power (per core) to get the job done.
https://www.cpubenchmark.net/cpu.php?cpu=AMD+Opteron+4334&id=2733
3900 passmarks / 6 cores per CPU package = 650 passmarks per core.
That’s below the 700 passmark minimum to run PMS.
Now add a large database and things are going to start stalling out.
It’s a 2012 CPU
I have installed server plex on another machine
I also had the same problem
slowquery
CPU: Dual CPU E5-2680 V4
Ram: 64GB
HDD: Samsung Evo 870 1TB
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
