Basically it takes 10 minutes to add one episode during partial scan because of the time spent retrieving items. I installed a fresh server on a separate computer just to see the logs and those lines are not there there is no Retrieve Items five times.
So it’d be awesome if anyone has a solution for this. I’ve searched posts and all the others have SLOW Query and Warnings, I do not. I made two posts in media server section to no response except a guy who had the same problem, so why not try here!?
Nov 11, 2018 22:03:35.816 [0x14ba565d1800] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.13.0, threadsafe=1
Nov 11, 2018 22:03:36.100 [0x14ba565d1800] DEBUG - It took 50.000000 ms to retrieve 2495 items.
Nov 11, 2018 22:05:49.685 [0x14ba565d1800] DEBUG - It took 40.000000 ms to retrieve 2495 items.
Nov 11, 2018 22:07:56.052 [0x14ba565d1800] DEBUG - It took 30.000000 ms to retrieve 2495 items.
Nov 11, 2018 22:09:58.726 [0x14ba565d1800] DEBUG - It took 40.000000 ms to retrieve 2495 items.
Nov 11, 2018 22:11:56.825 [0x14ba565d1800] DEBUG - It took 30.000000 ms to retrieve 2495 items.
Nov 11, 2018 22:13:50.858 [0x14ba565d1800] DEBUG - Scanning TV Shows using en(Plex Series Scanner) with 6 current media items and 1 section locations in the database…
Thanks for the response!
I tried this but it doesnt seem to be working when I have Run A Partial only selected. I do that and change a file and no scan. I checked out the support page and it has both flagged.
Edit: Also the files I’m changing are local and its running in a docker in Unraid
I am not getting SLOW query just the ones I showed, normal 40 ms scans but pauses in between. I will try to repair database just in case though since its been building for about 5 years?
You actually need both of those settings enabled for this to work. Those 5 retrieves took a total of 190 ms. I doubt those are the issue. Running a partial scan will also try to match previously unmatched entries. If you have a lot of these, then it can slow down the scan. Make sure everything is matched. If they can’t be matched, manually match and set the agent to personal media, this way it won’t try to match them again in the future.
I matched the unmatched ones in all TV sections but I did refresh some that are still going so maybe it’s not done yet…
So it still ran this one slow due to pauses in between those retrieves.
Nov 28, 2018 17:12:00.833 [0x152d2daf2700] INFO - Plex Media Scanner v1.14.0.5470-9d51fdfaa - Docker Docker Container x86_64 - build: linux-ubuntu-x86_64 - GMT -05:00
Nov 28, 2018 17:12:00.833 [0x152d2daf2700] INFO - Linux version: 4.14.40-unRAID, language: C
Nov 28, 2018 17:12:00.833 [0x152d2daf2700] INFO - Processor Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz
Nov 28, 2018 17:12:00.834 [0x152d2daf2700] INFO - /usr/lib/plexmediaserver/Plex Media Scanner --scan --refresh --section 6 --directory /data/Media/Television/Golden Kamuy/Season 02
Nov 28, 2018 17:12:00.844 [0x152d3887b800] DEBUG - Opening 20 database sessions to library (com.plexapp.plugins.library), SQLite 3.13.0, threadsafe=1
Nov 28, 2018 17:12:01.079 [0x152d3887b800] DEBUG - It took 50.000000 ms to retrieve 2533 items.
Nov 28, 2018 17:14:28.428 [0x152d3887b800] DEBUG - It took 40.000000 ms to retrieve 2533 items.
Nov 28, 2018 17:16:26.569 [0x152d3887b800] DEBUG - It took 40.000000 ms to retrieve 2533 items.
Nov 28, 2018 17:18:24.152 [0x152d3887b800] DEBUG - It took 40.000000 ms to retrieve 2533 items.
Nov 28, 2018 17:20:15.752 [0x152d3887b800] DEBUG - It took 20.000000 ms to retrieve 2533 items.
Nov 28, 2018 17:22:22.644 [0x152d3887b800] DEBUG - It took 40.000000 ms to retrieve 2533 items.
Nov 28, 2018 17:24:26.967 [0x152d3887b800] DEBUG - Scanning TV Shows using en(Plex Series Scanner) with 8 current media items and 1 section locations in the database…
Nov 28, 2018 17:24:27.191 [0x152d277ff700] DEBUG - HTTP requesting GET http://127.0.0.1:32400/:/metadata/notify/cullTimeline?librarySectionID=6&sinceTime=1543442666
Nov 28, 2018 17:24:27.496 [0x152d277ff700] DEBUG - HTTP 200 response from GET http://127.0.0.1:32400/:/metadata/notify/cullTimeline?librarySectionID=6&sinceTime=1543442666
Nov 28, 2018 17:24:27.642 [0x152d3887b800] DEBUG - Performing a scan with ‘Plex Series Scanner’ (language: en virtual: 0).
Nov 28, 2018 17:24:27.642 [0x152d3887b800] DEBUG - * Scanning /data/Media/Television/Golden Kamuy/Season 02
Nov 28, 2018 17:24:27.707 [0x152d3887b800] DEBUG - * Scanning directory /data/Media/Television/Golden Kamuy/Season 02 (parent: yes)
Nov 28, 2018 17:24:27.708 [0x152d3887b800] DEBUG - Adding file for scanner: “/data/Media/Television/Golden Kamuy/Season 02/Golden Kamuy - s2e05 - Inside the Belly [HDTV-1080p] [x264 AAC] [ 2.0 Audio] [8bit].mkv”
Having multiple libraries is not a problem. I see that there are several things playing at the time the update got triggered. I don’t see why the scanner paused, just thought maybe you had that setting enabled which would have explained the pause. It was just waiting for resources to free up. I’m still looking.