Hi all
an issue has cropped up recently wherein I have to reboot my syno from time to time, due to Plex being unwilling to play nice. It’s been several updates, but I can’t seem to be rid of the issue.
The latest log is attached, based on what I found in it I have:
- Disabled sync for all users.
- Removed all folders in the tmp transcode folder
Looks like it complains a bit over my TV as well, due to being unable to find a profile for it. I’m about to invest in a nVidia shield, so I expect that be resolved in due time.
Can anyone find a reason for these crashes?
Let’s start with the easy stuff:
Your CPU isn’t the fastest so this type of slowness (Database) fragmentation is really going to be felt and cause it to not play well.
Jun 05, 2018 22:59:09.447 [0x7fee5ebff700] WARN - SLOW QUERY: It took 400.000000 ms to retrieve 7 items.
The solution here is to hover over Libraries, expose the ellipsis, and “Optimize Database” then restart PMS
Everything else I see is a cascade failure of that root error.
Jun 01, 2018 15:01:06.596 [0x7fadde911700] WARN - SLOW QUERY: It took 2630.000000 ms to retrieve 1 items.
Jun 01, 2018 15:01:19.399 [0x7fadd6bff700] ERROR - QueryParser: Invalid field 'onlyTransient' found, ignoring.
Jun 01, 2018 15:01:22.083 [0x7fadd73ff700] INFO - AutoUpdate: no updates available
Jun 01, 2018 15:02:07.019 [0x7fadd6bff700] ERROR - LPE: unknown item 61437.
Jun 01, 2018 15:02:07.019 [0x7fadd6bff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F61437 in sync item 20604604
Jun 01, 2018 15:02:07.019 [0x7fadd6bff700] WARN - Sync: sync item 20604604 has an empty sync set query, assuming sync item is no longer valid
Jun 01, 2018 15:02:07.021 [0x7fadd6bff700] ERROR - LPE: unknown item 60487.
Jun 01, 2018 15:02:07.021 [0x7fadd6bff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F60487 in sync item 20604620
Jun 01, 2018 15:02:07.021 [0x7fadd6bff700] WARN - Sync: sync item 20604620 has an empty sync set query, assuming sync item is no longer valid
Jun 01, 2018 15:02:07.024 [0x7fadd6bff700] ERROR - LPE: unknown item 58432.
Jun 01, 2018 15:02:07.024 [0x7fadd6bff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F58432 in sync item 20604630
Jun 01, 2018 15:02:07.024 [0x7fadd6bff700] WARN - Sync: sync item 20604630 has an empty sync set query, assuming sync item is no longer valid
Jun 01, 2018 15:02:36.176 [0x7fadda3ff700] ERROR - LPE: unknown item 61437.
Jun 01, 2018 15:02:36.176 [0x7fadda3ff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F61437 in sync item 20604604
Oh, sorry, I should clarify. Xpenology. 
@ChuckPA said:
Let’s start with the easy stuff:
Your CPU isn’t the fastest so this type of slowness (Database) fragmentation is really going to be felt and cause it to not play well.
Jun 05, 2018 22:59:09.447 [0x7fee5ebff700] WARN - SLOW QUERY: It took 400.000000 ms to retrieve 7 items.
The solution here is to hover over Libraries, expose the ellipsis, and “Optimize Database” then restart PMS
Everything else I see is a cascade failure of that root error.
Jun 01, 2018 15:01:06.596 [0x7fadde911700] WARN - SLOW QUERY: It took 2630.000000 ms to retrieve 1 items.
Jun 01, 2018 15:01:19.399 [0x7fadd6bff700] ERROR - QueryParser: Invalid field 'onlyTransient' found, ignoring.
Jun 01, 2018 15:01:22.083 [0x7fadd73ff700] INFO - AutoUpdate: no updates available
Jun 01, 2018 15:02:07.019 [0x7fadd6bff700] ERROR - LPE: unknown item 61437.
Jun 01, 2018 15:02:07.019 [0x7fadd6bff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F61437 in sync item 20604604
Jun 01, 2018 15:02:07.019 [0x7fadd6bff700] WARN - Sync: sync item 20604604 has an empty sync set query, assuming sync item is no longer valid
Jun 01, 2018 15:02:07.021 [0x7fadd6bff700] ERROR - LPE: unknown item 60487.
Jun 01, 2018 15:02:07.021 [0x7fadd6bff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F60487 in sync item 20604620
Jun 01, 2018 15:02:07.021 [0x7fadd6bff700] WARN - Sync: sync item 20604620 has an empty sync set query, assuming sync item is no longer valid
Jun 01, 2018 15:02:07.024 [0x7fadd6bff700] ERROR - LPE: unknown item 58432.
Jun 01, 2018 15:02:07.024 [0x7fadd6bff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F58432 in sync item 20604630
Jun 01, 2018 15:02:07.024 [0x7fadd6bff700] WARN - Sync: sync item 20604630 has an empty sync set query, assuming sync item is no longer valid
Jun 01, 2018 15:02:36.176 [0x7fadda3ff700] ERROR - LPE: unknown item 61437.
Jun 01, 2018 15:02:36.176 [0x7fadda3ff700] ERROR - Sync: failed to generate query for path library://1ff66d20-e69f-4a20-abdf-9e7ab6f55c0b/item/%2Flibrary%2Fmetadata%2F61437 in sync item 20604604
Optimize database is set as a schedueled task and I run it myself frequently. CPU is plenty fast, being an octocore 2.4ghz.
it’s still an Atom C-series. It’s not fast by definition. It’s a bit quicker than the C2538 in the Synology DSx15 models but not by much.
That said, how big is the DB and how many Sync items do you have? According to your logs, you have quite a few which have become orphaned . You might want to consider reviewing what is in the sync list .
The other activity happening is a considerable amount of scanner activity including image generation. That will bury any Atom CPU
@ChuckPA said:
it’s still an Atom C-series. It’s not fast by definition. It’s a bit quicker than the C2538 in the Synology DSx15 models but not by much.
That said, how big is the DB and how many Sync items do you have? According to your logs, you have quite a few which have become orphaned . You might want to consider reviewing what is in the sync list .
The other activity happening is a considerable amount of scanner activity including image generation. That will bury any Atom CPU
It hasn’t been a problem before. And frankly, this CPU handles six simultaneous streams without even breaking a sweat. It’s pretty great. I’ve removed all sync items now, and disabled sync for all accounts, it has yet to fail again.
But you suggest disabling thumbnail generation?
Before you take action on my suggestion, may I have the information I requested about how much space Library is using?
Some users have as much as a couple Terabytes in use with 90% of that coming from chapter thumbnails. This is why I ask.
The ratio: GigabytesUsed / NumberOfVideoItems is the concern. When you have as much or more space used for your BIF files (the thumbnails) as you do for the video itself then there is an issue.
133GB presently. I disabled thumbnail generation, unsure if that cleans up automatically or not?
