Bad Performance & Freezing for New PMS Installation

Plex Media Server Desktops & Laptops
1

Hey Guys -

In order to alleviate resource usage on my primary workstation, I rebuilt my Plex Server on different hardware about a month ago. Since then, performance has been really bad. Loading Plex dashboards on devices often takes a long time or times out altogether, freezing occurs during playback, and media takes up to 20 seconds to start initial playback. The thing is, none of this is consistent as things are acceptable some of the time. I never had these issues on my old Plex Server which had much better resources, but when the issues occur with the current server, no resources are maxed and often no playback is occurring on any devices.

I’m posting to try to find out the exact culprit so I’ll. Below are some details followed by questions.

Current Plex Media Server

  • OS: Windows Server 2016
  • CPU: AMD A8-5600k CPU @ 3.60Ghz
  • Motherboard: FM2A88X-ITX+
  • RAM: 4gb
  • OS & Plex installed to SSD
  • Plex Data Dir resides on separate 300gb disk
  • Library content (~35tb) located in disk pool accessed over 1gbps connection - No firewall is enabled
  • Smart switch resides between server and disk pool
  • Server Version#: 1.14.1.5488
  • Player Version#: 3.77.4 (Web) / RasPlex / iOS 12 (iPad Pro) / Roku

Notes

  • PC semi-dedicated to Plex. Also hosts a few other things but not too much
  • CPU averages ~15% when transcoding 1 title. Can be up to 65% depending on of scanning is running and how many playbacks are transcoding / RAM usage hovers ~85%
  • Have debugging enabled, but when issues occur; I don’t see errors in logs (if anything at all) during the time it happens
  • Other log errors mention database being locked & taking a second to access db mostly.
  • Plex Data directory is ~50gb. I optimize the DB weekly via maintenance tasks and since initial build a month ago have not removed any libraries or much media
  • I have any tasks like making thumbnails or video preview disabled / set to never
  • Main differences between 1st Plex server I had (no issues) and current one are that it’s CPU had twice the passmark score, 32gb RAM, and the media was local instead of over network. I expected a little additional lag in starting playback due to this, but it doesn’t explain it taking forever sometimes. No substantial traffic is coming through smart switch when issues occur

Questions
My main concern are the issues occurring when nothing is playing. I understand additional resources are required for multiple transcodes, but that isn’t the issue here.

  1. Based on the above information, would RAM or disk speed for Plex data dir clearly be the issue? I can move the Plex data dir to the OS’s SSD if it would be a potential solution although would take very long time due to # of files
  2. Are the resources of the PC being used acceptable? The CPU rates only 4344 passmark, but is never maxed. I can add 4gb more RAM, but before ordering wanted to make sure it had a good chance of being culprit
  3. I have other space PCs I use for things like ESX hosts at home I can use instead, but they aren’t much better CPU-wise. If the PC is the issue,

Sure that’s enough (or too much) info. Happy to submit more details if needed. Any suggestions are appreciated.

Thanks

2

A totally separate disk, or just a different partition? If a partition, the same SSD as the OS? If a disk, 300Gb is pretty small so is that an older drive?

What type of pool? We’ve seen slowness in some cases. We would need to see your PMS logs during the events you describe to look into where the slowness might be.

3

Thanks for the reply…

The 300gb disk is separate - and yes, a bit older. I looked up the specs and realized it was actually 500gb (duh) and is a ST500LM021 which is a 7200 RPM with 32mb of cache. If it was just a partition of the SSD, I wouldn’t consider moving it over :).

As far as the pool, it’s a 43.5tb 12-disk (11 HDD + 1 SSD for caching) poll run by Stablebit DrivePool. If it’s contributing to the issue at all, I’d imagine its since it’s now accessed over network instead of local to PMS. Still, there’s only a smart switch in between the two systems and each have a 1gbps connect which isn’t even stressed.

To note, after posting I tried copying over my Plex data folder to the SSD. It ended up being ~50gb and 1.2 million files. Unfortunately, the system crashed during the copy - probably because I kept Plex running during the copy as system hasn’t ever crashed before. Would just rebuild data dir from scratch, but with my library that takes 3-4 days.

Any suggestions? Thanks

4

Yeah, not a good idea to move files that are actively open. Shut down PMS and finish the move or move everything back.

Stablebit is pretty stable :smile: and should work fine.

Not sure what a smart switch is. Do you mean a managed switch? Have you done a speed test from the drivepool to your computer to make sure it’s been configured properly through the switch?

5

Good Morning -

I’m going to try to move the Plex Data dir to the SSD today again so will see what happens. Concerning the Smart Switch, they are fairly new. Basically, it’s a semi-managed switch which offers much more control than a standard switch, but without the cost of a fully managed one. Mine is a TL-SG108E 4.0.

Since my last reply, I’ve looked into a few more things. Below is some additional info:

  • Tested various IGMP Sniffing settings in switch as I initially had enabled. No settings made a difference
  • Collected more detailed info. I analyzed a single “Plex Media Server.log” file which covered a 58 minute period. Within that file, I gathered the following stats:
    • 539 Total Errors in log
    • Of the 539, 9 were unique. Below is a each with the number of times it appeared:
      • x71 [1252] ERROR - EventSource: Retrying in 15 seconds.
      • x63 [10328] ERROR - EventSource: Retrying in 15 seconds.
      • x113 [2160] ERROR - Error issuing curl_easy_perform(handle): 56
      • x113 [2160] ERROR - SSDP: Error parsing device schema for http://192.168.0.250:8200/rootDesc.xml (See note below)
      • x2 [0084] ERROR - [Transcoder] [mp4 @ 04892a40] Application provided duration: -16 / timestamp: XXXXX is out of range for mov/mp4 format
      • x14 [4252] ERROR - [Transcoder] [mp4 @ 04892a40] Application provided duration: -16 / timestamp
      • x12 [12020] ERROR - [Transcoder] [mp4 @ 04892a40] Application provided duration: -16 / timestamp:
      • x8 [11928] ERROR - [Transcoder] [mp4 @ 04892a40] Application provided duration: -16 / timestamp:
      • x6 [10828] ERROR - [Transcoder] [mp4 @ 04892a40] Application provided duration: -16 / timestamp:
        Note: 192.168.0.250 listed in the error above is a Netgear WNDR4500 router set to AP mode. It is not my primary router. The only reason I have it is because I use Amazon Cloud Cams at home which due to a bug cannot connect to my Linksys 1900ACS running LEDE. The error with it’s IP seems related to uPNP and/or DLNA however I have my remote port (32400) manually forwarded on my primary router and in Plex’s config have option checked that I manually do so. I also have DLNA disabled in Plex. As the WNDR4500 is in AP mode instead of router mode, it has no active firewall or uPNP so not sure why it occurs.

Hope this provides clues. Thanks

6

Those error are not related. I don’t see hoe IGMP sniffing would help in this case. I’m leaning toward something being mis-configured in your switch.

If possible, I would try connecting to a dumb switch just to compare.

7

Thanks for the reply…

I highly doubt its related to the switch as to test I stood up a separate system (similar hardware) on Ubuntu, installed Plex, and added the same config + libraries and it’s seemingly working perfectly. It goes through the smart switch as well as one additional one currently.

Error Comparison
For the heck of it, I let Plex run on both servers in the Console view for 30 minutes showing only errors when each was doing similar tasks. Below is the output for each:

Test Ubuntu Plex Server (No Issues)
The below 3 lines appear every 30 seconds - that’s it. I’ve provided descriptions about the lines above.

[0x7fed4a3da700] Error — Error issuing curl_easy_perform(handle): 56
[0x7fed4a3da700] Warning — HTTP error requesting GET http://192.168.0.250:8200/rootDesc.xml (0, No error) (Recv failure: Connection reset by peer)
[0x7fed4a3da700] Error — SSDP: Error parsing device schema for http://192.168.0.250:8200/rootDesc.xml

Plex Server on Windows Server 2016 (Issues this post is about)
To save space, I’ve only included the unique errors below which shrank it from 417 to 245. To note, it also includes the 3 lines above every 30 seconds

[5700] Error — Error issuing curl_easy_perform(handle): 56
[5700] Error — SSDP: Error parsing device schema for http://192.168.0.250:8200/rootDesc.xml
[6564] Error — LPE: unknown item 117001.
[6564] Error — Sync: failed to generate query for path library://f5925fa3-c94a-465d-80d0-2c5ee9fbf8a9/item/%2Flibrary%2Fmetadata%2F117001 in sync item 33358712
[6564] Error — Sync: skipping items for sync list 27268773, sync item 33358712: unable to generate sync set query
[6564] Error — LPE: unknown item 118917.
[6564] Error — Sync: failed to generate query for path library://f5925fa3-c94a-465d-80d0-2c5ee9fbf8a9/item/%2Flibrary%2Fmetadata%2F118917 in sync item 33358724
[6564] Error — Sync: skipping items for sync list 27268773, sync item 33358724: unable to generate sync set query
[6564] Error — LPE: unknown item 115038.
[6564] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F115038 in sync item 32777062
[6564] Error — LPE: unknown item 115128.
[6564] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F115128 in sync item 32777080
[6564] Error — LPE: unknown item 111785.
[6564] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F111785 in sync item 32777109
[6564] Error — LPE: unknown item 116753.
[6564] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F116753 in sync item 33067349
[7416] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=1): Cannot begin transaction. database is locked
[11664] Error — Error issuing curl_easy_perform(handle): 28
[11664] Error — Error parsing content.
[11664] Error — Error parsing XML response for update.
[11964] Error — Error issuing curl_easy_perform(handle): 28
[11964] Error — Error parsing content.
[11964] Error — Error parsing XML response for update.
[11328] Error — Error issuing curl_easy_perform(handle): 28
[11328] Error — Error parsing content.
[11328] Error — Error parsing XML response for update.
[9988] Error — Error issuing curl_easy_perform(handle): 28
[9988] Error — Error parsing content.
[9988] Error — Error parsing XML response for update.
[11140] Error — Error issuing curl_easy_perform(handle): 28
[11140] Error — Error parsing content.
[11140] Error — Error parsing XML response for update.
[6540] Error — Error issuing curl_easy_perform(handle): 28
[6540] Error — Error parsing content.
[6540] Error — Error parsing XML response for update.
[9484] Error — Exception loading item ‘Zero Days’ from bundle: sqlite3_statement_backend::loadOne: database is locked
[5616] Error — Error issuing curl_easy_perform(handle): 28
[5616] Error — Error parsing content.
[5616] Error — Error parsing XML response for update.
[11652] Error — Error issuing curl_easy_perform(handle): 28
[11652] Error — Error parsing content.
[11652] Error — Error parsing XML response for update.
[9916] Error — Error issuing curl_easy_perform(handle): 28
[9916] Error — Error parsing content.
[9916] Error — Error parsing XML response for update.
[11880] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=1): Cannot begin transaction. database is locked
[2876] Error — Error issuing curl_easy_perform(handle): 28
[2876] Error — Error parsing content.
[2876] Error — Error parsing XML response for update.
[11880] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=2): Cannot begin transaction. database is locked
[10120] Error — Error issuing curl_easy_perform(handle): 28
[10120] Error — Error parsing content.
[10120] Error — Error parsing XML response for update.
[11880] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=3): Cannot begin transaction. database is locked
[11880] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=4): Cannot begin transaction. database is locked
[5412] Error — Error issuing curl_easy_perform(handle): 28
[5412] Error — Error parsing content.
[5412] Error — Error parsing XML response for update.
[9484] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:5719) (tries=1): Cannot begin transaction. database is locked
[11100] Error — Exception loading item ‘Zero Days’ from bundle: sqlite3_statement_backend::loadOne: database is locked
[4400] Error — Error issuing curl_easy_perform(handle): 28
[4400] Error — Error parsing content.
[4400] Error — Error parsing XML response for update.
[9672] Error — Failed to begin transaction (…\Library\MediaStreamSetting.cpp:24) (tries=1): Cannot begin transaction. database is locked
[9672] Error — Failed to begin transaction (…\Library\MediaStreamSetting.cpp:24) (tries=2): Cannot begin transaction. database is locked
[12052] Error — Error issuing curl_easy_perform(handle): 28
[12052] Error — Error parsing content.
[12052] Error — Error parsing XML response for update.
[9672] Error — Failed to begin transaction (…\Library\MediaStreamSetting.cpp:24) (tries=3): Cannot begin transaction. database is locked
[10212] Error — Error issuing curl_easy_perform(handle): 28
[10212] Error — Error parsing content.
[10212] Error — Error parsing XML response for update.
[10940] Error — Error issuing curl_easy_perform(handle): 28
[10940] Error — Error parsing content.
[10940] Error — Error parsing XML response for update.
[9672] Error — Failed to begin transaction (…\Library\MediaStreamSetting.cpp:24) (tries=4): Cannot begin transaction. database is locked
[9744] Error — Error issuing curl_easy_perform(handle): 28
[9744] Error — Error parsing content.
[9744] Error — Error parsing XML response for update.
[9672] Error — Failed to begin transaction (…\Library\MediaStreamSetting.cpp:24) (tries=5): Cannot begin transaction. database is locked
[11100] Error — Error issuing curl_easy_perform(handle): 28
[11100] Error — Error parsing content.
[11100] Error — Error parsing XML response for update.
[5760] Error — Error issuing curl_easy_perform(handle): 28
[5760] Error — Error parsing content.
[5760] Error — Error parsing XML response for update.
[1860] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=1): Cannot begin transaction. database is locked
[1860] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=2): Cannot begin transaction. database is locked
[1860] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:7409) (tries=3): Cannot begin transaction. database is locked
[9672] Error — Error issuing curl_easy_perform(handle): 28
[9672] Error — Error parsing content.
[9672] Error — Error parsing XML response for update.
[11340] Error — Error issuing curl_easy_perform(handle): 28
[11340] Error — Error parsing content.
[11340] Error — Error parsing XML response for update.
[11424] Error — Error issuing curl_easy_perform(handle): 28
[11424] Error — Error parsing content.
[11424] Error — Error parsing XML response for update.
[10144] Error — Error issuing curl_easy_perform(handle): 28
[10144] Error — Error parsing content.
[10144] Error — Error parsing XML response for update.
[11144] Error — Error issuing curl_easy_perform(handle): 28
[11144] Error — Error parsing content.
[11144] Error — Error parsing XML response for update.
[4116] Error — Error issuing curl_easy_perform(handle): 28
[10868] Error — Error issuing curl_easy_perform(handle): 28
[4116] Error — Error parsing content.
[10868] Error — Error parsing content.
[10868] Error — Error parsing XML response for update.
[4116] Error — Error parsing XML response for update.
[11540] Error — Error issuing curl_easy_perform(handle): 28
[11540] Error — Error parsing content.
[11540] Error — Error parsing XML response for update.
[10172] Error — Error issuing curl_easy_perform(handle): 28
[10172] Error — Error parsing content.
[10172] Error — Error parsing XML response for update.
[12268] Error — Error issuing curl_easy_perform(handle): 28
[12268] Error — Error parsing content.
[12268] Error — Error parsing XML response for update.
[11728] Error — Error issuing curl_easy_perform(handle): 28
[11728] Error — Error parsing content.
[11728] Error — Error parsing XML response for update.
[11428] Error — Error issuing curl_easy_perform(handle): 28
[0300] Error — Error issuing curl_easy_perform(handle): 28
[0300] Error — Error parsing content.
[11428] Error — Error parsing content.
[11428] Error — Error parsing XML response for update.
[0300] Error — Error parsing XML response for update.
[4152] Error — Error issuing curl_easy_perform(handle): 28
[4152] Error — Error parsing content.
[4152] Error — Error parsing XML response for update.
[11312] Error — Error issuing curl_easy_perform(handle): 28
[11312] Error — Error parsing content.
[11312] Error — Error parsing XML response for update.
[5284] Error — Error issuing curl_easy_perform(handle): 28
[5284] Error — Error parsing content.
[5284] Error — Error parsing XML response for update.
[3004] Error — Error issuing curl_easy_perform(handle): 28
[3004] Error — Error parsing content.
[3004] Error — Error parsing XML response for update.
[11312] Error — Failed to begin transaction (…\Library\MediaStreamSetting.cpp:24) (tries=1): Cannot begin transaction. database is locked
[11716] Error — Failed to begin transaction (…\Library\MetadataItem.cpp:931) (tries=1): Cannot begin transaction. database is locked
[11100] Error — Failed to begin transaction (…\Library\MediaStreamSetting.cpp:24) (tries=1): Cannot begin transaction. database is locked
[5232] Error — Exception loading item ‘The Pirate Bay: Away from Keyboard’ from bundle: sqlite3_statement_backend::loadOne: database is locked
[6520] Error — Exception loading item ‘Fear and Loathing in Las Vegas’ from bundle: sqlite3_statement_backend::loadOne: database is locked
[7416] Error — Exception loading item ‘What We Do in the Shadows’ from bundle: sqlite3_statement_backend::loadOne: database is locked
[10148] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[2876] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[9916] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[11140] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[5616] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[4116] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[5232] Error — Exception loading item ‘A Bronx Tale’ from bundle: sqlite3_statement_backend::loadOne: database is locked
[10144] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[7416] Error — Exception loading item ‘The Flowers of War’ from bundle: sqlite3_statement_backend::loadOne: database is locked
[11540] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[12152] Error — EventSource: Retrying in 15 seconds.
[6964] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=1): Cannot begin transaction. database is locked
[6964] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=2): Cannot begin transaction. database is locked
[6964] Error — LPE: unknown item 117001.
[6964] Error — Sync: failed to generate query for path library://f5925fa3-c94a-465d-80d0-2c5ee9fbf8a9/item/%2Flibrary%2Fmetadata%2F117001 in sync item 33358712
[6964] Error — Sync: skipping items for sync list 27268773, sync item 33358712: unable to generate sync set query
[6964] Error — LPE: unknown item 118917.
[6964] Error — Sync: failed to generate query for path library://f5925fa3-c94a-465d-80d0-2c5ee9fbf8a9/item/%2Flibrary%2Fmetadata%2F118917 in sync item 33358724
[6964] Error — Sync: skipping items for sync list 27268773, sync item 33358724: unable to generate sync set query
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=1): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=2): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=3): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=4): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=5): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=6): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=7): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=8): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=9): Cannot begin transaction. database is locked
[11676] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=10): Cannot begin transaction. database is locked
[11676] Error — Thread: Uncaught exception running async task which was spawned by thread 9472: Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=1): Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=2): Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=3): Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=4): Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=5): Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=6): Cannot begin transaction. database is locked
[6520] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=7): Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=8): Cannot begin transaction. database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=9): Cannot begin transaction. database is locked
[4152] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[11960] Error — Failed to begin transaction (…\Statistics\StatisticsBandwidth.cpp:29) (tries=10): Cannot begin transaction. database is locked
[11960] Error — Thread: Uncaught exception running async task which was spawned by thread 12152: Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=1): Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=2): Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=3): Cannot begin transaction. database is locked
[11428] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=4): Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=5): Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=6): Cannot begin transaction. database is locked
[2204] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=7): Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=8): Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=9): Cannot begin transaction. database is locked
[5568] Error — Failed to begin transaction (…\Sync\SyncItemGenerator.cpp:97) (tries=10): Cannot begin transaction. database is locked
[5568] Error — Sync: failed to get metadata item IDs during generate for sync list 30813811, sync item 33124921, path /library/metadata/102271/children: Cannot begin transaction. database is locked
[11964] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=1): Cannot begin transaction. database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=2): Cannot begin transaction. database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=3): Cannot begin transaction. database is locked
[10940] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=4): Cannot begin transaction. database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=5): Cannot begin transaction. database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=6): Cannot begin transaction. database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=7): Cannot begin transaction. database is locked
[10140] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=8): Cannot begin transaction. database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=9): Cannot begin transaction. database is locked
[1968] Error — Failed to begin transaction (…\Library\MetadataCollection.cpp:173) (tries=10): Cannot begin transaction. database is locked
[1968] Error — Thread: Uncaught exception running async task which was spawned by thread 1404: Cannot begin transaction. database is locked
[5412] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[5568] Error — Sync: failed to get metadata item IDs during generate for sync list 25067921, sync item 33496163, path /library/metadata/128623/children: Cannot begin transaction. database is locked
[11652] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[9744] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[5568] Error — Sync: failed to get metadata item IDs during generate for sync list 25067921, sync item 33496167, path /library/metadata/128610/children: Cannot begin transaction. database is locked
[11880] Error — Soci Exception handled: sqlite3_statement_backend::loadOne: database is locked
[5568] Error — Sync: failed to get metadata item IDs during generate for sync list 27268773, sync item 33228580, path /library/metadata/83397: Cannot begin transaction. database is locked
[5568] Error — LPE: unknown item 117001.
[5568] Error — Sync: failed to generate query for path library://f5925fa3-c94a-465d-80d0-2c5ee9fbf8a9/item/%2Flibrary%2Fmetadata%2F117001 in sync item 33358712
[5568] Error — Sync: skipping items for sync list 27268773, sync item 33358712: unable to generate sync set query
[5568] Error — LPE: unknown item 118917.
[5568] Error — Sync: failed to generate query for path library://f5925fa3-c94a-465d-80d0-2c5ee9fbf8a9/item/%2Flibrary%2Fmetadata%2F118917 in sync item 33358724
[5568] Error — Sync: skipping items for sync list 27268773, sync item 33358724: unable to generate sync set query
[5568] Error — LPE: unknown item 115038.
[5568] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F115038 in sync item 32777062
[5568] Error — Sync: skipping items for sync list 30643921, sync item 32777062: unable to generate sync set query
[5568] Error — Sync: empty sync set, unable to update status for sync list 30643921, sync item 32777062
[5568] Error — LPE: unknown item 115128.
[5568] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F115128 in sync item 32777080
[5568] Error — Sync: skipping items for sync list 30643921, sync item 32777080: unable to generate sync set query
[5568] Error — Sync: empty sync set, unable to update status for sync list 30643921, sync item 32777080
[5568] Error — LPE: unknown item 111785.
[5568] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F111785 in sync item 32777109
[5568] Error — Sync: skipping items for sync list 30643921, sync item 32777109: unable to generate sync set query
[5568] Error — Sync: empty sync set, unable to update status for sync list 30643921, sync item 32777109
[5568] Error — LPE: unknown item 116753.
[5568] Error — Sync: failed to generate query for path library://cd8598c1-7fc0-4916-87d7-c3d369880fa1/item/%2Flibrary%2Fmetadata%2F116753 in sync item 33067349
[5568] Error — Sync: skipping items for sync list 30643921, sync item 33067349: unable to generate sync set query
[5568] Error — Sync: empty sync set, unable to update status for sync list 30643921, sync item 33067349

Hopefully, this will provide another clue. Thanks!

8

Most of those errors relate to the Plex database. Very likely from when you tried to move the appdata with PMS running something got messed up. Have you tried the steps to repair the database? https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.