Server Version#: 1.41.0.8994
Player Version#:All
This has been driving me up a wall the past week and a half. Three or so weeks ago I migrated my plex media server to a new server, more cores, more RAM, etc. The first week it worked perfectly, and then as of this past weekend (Oct 6th or so) and if I recall a Plex server update, my home tab on any streaming device I use (web, firetv, roku, etc) lags significantly and most of the time will not load my continue watching. Combined with this I get frequent failures to load entire libraries (but will work other time randomly), as well as the recommended in most libraries now fails to load.
As I said all of this was working fine not only before my migration, but for at least a good week or more post migration. I’ve refreshed metadata on all libraries several times, I’ve run a database optimization several times. I’ve cleared out the cache and had it rebuild, I’ve even gone through and have run a DB repair found here.
Logs indicate that database transactions are being held to long suddenly and I’m not sure as to why (VM is running on 4 2.7TB 15k RPM SAS drives in a RAID5). I’ve also noticed something strange on my NAS where all my media is stored, in that every episode file now also has a .xml and .metathumb file associated with it in the same folder, as well as a “folder” jpg file in each season. None of these files were there before.
Oct 18, 2024 15:28:16.105 [4364] INFO - Running migrations. (EPG 1)
Oct 18, 2024 15:28:16.236 [4100] ERROR - DVR:Device: Error refreshing existing device device://tv.plex.grabbers.hdhomerun/1325DF15, marking as dead.
Oct 18, 2024 15:28:16.847 [5016] WARN - [Req#f9] SLOW QUERY: It took 468.750000 ms to retrieve 2 items.
Oct 18, 2024 15:28:17.000 [3644] WARN - [Req#119] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:17.000 [3644] WARN - [Req#119] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:17.177 [1488] WARN - [Req#118] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:17.177 [1488] WARN - [Req#118] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:17.471 [4568] WARN - [Req#11d] SLOW QUERY: It took 1156.250000 ms to retrieve 13 items.
Oct 18, 2024 15:28:17.650 [4568] INFO - [Req#12d] AutoUpdate: no updates available
Oct 18, 2024 15:28:19.065 [3644] WARN - [Req#119] SLOW QUERY: It took 2984.375000 ms to retrieve 50 items.
Oct 18, 2024 15:28:19.102 [1488] WARN - [Req#118] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:19.102 [1488] WARN - [Req#118] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:19.273 [11236] WARN - MPM: ignoring preferred-interface pref due to no matching valid address
Oct 18, 2024 15:28:22.061 [1488] WARN - [Req#118] SLOW QUERY: It took 2578.125000 ms to retrieve 50 items.
Oct 18, 2024 15:28:30.875 [1488] WARN - [Req#180] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:30.876 [1488] WARN - [Req#180] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:31.319 [1488] INFO - [Req#183] AutoUpdate: no updates available
Oct 18, 2024 15:28:41.063 [9008] WARN - Held transaction for too long (D:\gha\plex-media-server\plex-media-server\Statistics\StatisticsManager.cpp:294): 0.281250 seconds
Oct 18, 2024 15:28:46.986 [5996] WARN - [Req#19b] QueryParser: Invalid field 'sectionID' found, ignoring.
Oct 18, 2024 15:28:46.986 [5996] WARN - [Req#19b] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:46.986 [5996] WARN - [Req#19b] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:47.023 [4568] WARN - [Req#198] QueryParser: Invalid field 'sectionID' found, ignoring.
Oct 18, 2024 15:28:47.024 [4568] WARN - [Req#198] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:47.024 [4568] WARN - [Req#198] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:47.040 [8200] ERROR - [Req#1a7] Unknown metadata type: folder
Oct 18, 2024 15:28:47.040 [6108] ERROR - [Req#1a8] Unknown metadata type: folder
Oct 18, 2024 15:28:47.041 [8200] WARN - [Req#1a7] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:47.041 [8200] WARN - [Req#1a7] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:47.041 [6108] WARN - [Req#1a8] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:47.042 [6108] WARN - [Req#1a8] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:48.267 [5996] WARN - [Req#19b] SLOW QUERY: It took 1156.250000 ms to retrieve 50 items.
Oct 18, 2024 15:28:48.900 [6080] WARN - [Req#1b6/Req#1b7] SLOW QUERY: It took 265.625000 ms to retrieve 36 items.
Oct 18, 2024 15:28:48.952 [4568] WARN - [Req#198] QueryParser: Invalid field 'sectionID' found, ignoring.
Oct 18, 2024 15:28:48.952 [4568] WARN - [Req#198] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:48.952 [4568] WARN - [Req#198] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:49.031 [8200] WARN - [Req#1a7] SLOW QUERY: It took 1015.625000 ms to retrieve 24 items.
Oct 18, 2024 15:28:49.273 [6108] WARN - [Req#1a8] SLOW QUERY: It took 265.625000 ms to retrieve 24 items.
Oct 18, 2024 15:28:49.413 [6108] WARN - [Req#1c7/Req#1c8] SLOW QUERY: It took 578.125000 ms to retrieve 70 items.
Oct 18, 2024 15:28:49.438 [8528] INFO - [Req#1bc] AutoUpdate: no updates available
Oct 18, 2024 15:28:49.625 [5996] WARN - [Req#1d3/Req#1d6] SLOW QUERY: It took 343.750000 ms to retrieve 50 items.
Oct 18, 2024 15:28:50.232 [8200] WARN - [Req#1ee] SLOW QUERY: It took 843.750000 ms to retrieve 89 items.
Oct 18, 2024 15:28:50.324 [8528] WARN - [Req#1f9/Req#203] SLOW QUERY: It took 390.625000 ms to retrieve 26 items.
Oct 18, 2024 15:28:50.495 [6108] WARN - [Req#20b] QueryParser: Invalid field 'sectionID' found, ignoring.
Oct 18, 2024 15:28:50.495 [6108] WARN - [Req#20b] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:50.496 [6108] WARN - [Req#20b] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:50.977 [8528] WARN - [Req#20c] QueryParser: Invalid field 'sectionID' found, ignoring.
Oct 18, 2024 15:28:50.977 [8528] WARN - [Req#20c] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:50.978 [8528] WARN - [Req#20c] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:51.164 [8200] WARN - [Req#214/Req#216] SLOW QUERY: It took 468.750000 ms to retrieve 32 items.
Oct 18, 2024 15:28:51.400 [8200] WARN - [Req#21c/Req#21e] SLOW QUERY: It took 281.250000 ms to retrieve 1 items.
Oct 18, 2024 15:28:51.474 [4568] WARN - [Req#198] SLOW QUERY: It took 2718.750000 ms to retrieve 50 items.
Oct 18, 2024 15:28:51.546 [8200] WARN - [Req#21c/Req#21e] SLOW QUERY: It took 1031.250000 ms to retrieve 71 items.
Oct 18, 2024 15:28:51.565 [4568] WARN - [Req#198] SLOW QUERY: It took 359.375000 ms to retrieve 21 items.
Oct 18, 2024 15:28:51.828 [5996] WARN - [Req#221/Req#222] SLOW QUERY: It took 546.875000 ms to retrieve 1 items.
Oct 18, 2024 15:28:53.264 [5984] WARN - [Req#238/Req#239] SLOW QUERY: It took 234.375000 ms to retrieve 1 items.
Oct 18, 2024 15:28:53.381 [6108] WARN - [Req#20b] SLOW QUERY: It took 2156.250000 ms to retrieve 50 items.
Oct 18, 2024 15:28:53.485 [6108] WARN - [Req#20b] SLOW QUERY: It took 312.500000 ms to retrieve 17 items.
Oct 18, 2024 15:28:53.634 [6108] WARN - [Req#20b] SLOW QUERY: It took 203.125000 ms to retrieve 16 items.
Oct 18, 2024 15:28:53.651 [5996] WARN - [Req#23e/Req#240] SLOW QUERY: It took 218.750000 ms to retrieve 45 items.
Oct 18, 2024 15:28:54.063 [8200] WARN - [Req#24f/Req#252] SLOW QUERY: It took 359.375000 ms to retrieve 14 items.
Oct 18, 2024 15:28:54.566 [5984] WARN - [Req#263/Req#268] QueryParser: Invalid field 'having' found, ignoring.
Oct 18, 2024 15:28:54.725 [6728] WARN - [Req#264/Req#26c] SLOW QUERY: It took 234.375000 ms to retrieve 5 items.
Oct 18, 2024 15:28:54.792 [5996] WARN - [Req#26b/Req#26e] SLOW QUERY: It took 359.375000 ms to retrieve 18 items.
Oct 18, 2024 15:28:54.941 [5996] WARN - [Req#26b/Req#26e] SLOW QUERY: It took 625.000000 ms to retrieve 49 items.
Oct 18, 2024 15:28:54.956 [6728] WARN - [Req#264/Req#26c] SLOW QUERY: It took 265.625000 ms to retrieve 5 items.
Oct 18, 2024 15:28:55.035 [8200] WARN - [Req#267/Req#26d] SLOW QUERY: It took 281.250000 ms to retrieve 5 items.
Oct 18, 2024 15:28:55.061 [5996] WARN - [Req#26b/Req#26e] SLOW QUERY: It took 578.125000 ms to retrieve 54 items.
Oct 18, 2024 15:28:55.061 [6728] WARN - [Req#264/Req#26c] SLOW QUERY: It took 281.250000 ms to retrieve 19 items.
Oct 18, 2024 15:28:55.065 [8528] WARN - [Req#20c] QueryParser: Invalid field 'sectionID' found, ignoring.
Oct 18, 2024 15:28:55.065 [8528] WARN - [Req#20c] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:55.065 [8528] WARN - [Req#20c] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:55.156 [5996] WARN - [Req#26b/Req#26e] SLOW QUERY: It took 390.625000 ms to retrieve 46 items.
Oct 18, 2024 15:28:55.644 [8200] WARN - [Req#271] QueryParser: Invalid field 'sectionID' found, ignoring.
Oct 18, 2024 15:28:55.644 [8200] WARN - [Req#271] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:55.644 [8200] WARN - [Req#271] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Oct 18, 2024 15:28:55.732 [6728] WARN - [Req#273/Req#274] QueryParser: Invalid field 'having' found, ignoring.
Oct 18, 2024 15:28:55.791 [5996] WARN - [Req#277/Req#278] QueryParser: Invalid field 'having' found, ignoring.
Oct 18, 2024 15:28:56.024 [5984] WARN - [Req#263/Req#268] SLOW QUERY: It took 218.750000 ms to retrieve 7 items.
Oct 18, 2024 15:28:56.142 [5984] WARN - [Req#263/Req#268] SLOW QUERY: It took 250.000000 ms to retrieve 5 items.
Oct 18, 2024 15:28:56.229 [5984] WARN - [Req#263/Req#268] SLOW QUERY: It took 406.250000 ms to retrieve 31 items.
Oct 18, 2024 15:28:56.961 [5984] WARN - [Req#223/Req#280] SLOW QUERY: It took 531.250000 ms to retrieve 46 items.
Oct 18, 2024 15:28:57.012 [5984] WARN - [Req#223/Req#280] SLOW QUERY: It took 265.625000 ms to retrieve 37 items.
Oct 18, 2024 15:28:57.074 [5996] WARN - [Req#277/Req#278] SLOW QUERY: It took 250.000000 ms to retrieve 42 items.
Oct 18, 2024 15:28:57.123 [6728] WARN - [Req#273/Req#274] SLOW QUERY: It took 265.625000 ms to retrieve 5 items.
Oct 18, 2024 15:28:57.248 [5996] WARN - [Req#277/Req#278] SLOW QUERY: It took 406.250000 ms to retrieve 25 items.
Oct 18, 2024 15:28:57.605 [8200] WARN - [Req#271] SLOW QUERY: It took 2468.750000 ms to retrieve 50 items.
Oct 18, 2024 15:28:57.625 [8200] WARN - [Req#271] SLOW QUERY: It took 203.125000 ms to retrieve 16 items.
