WARN - Slow Query - 0 results

[FordGuy61]

Other posts I’ve seen WRT Slow Query mention a fragmented database.

The fix seems to be:

1. Stop all Scanning
2. Optimize database
3. Rescan ONE library section at a time until all have caught back up
4. Optimize database between each library section scan

Here’s a post from the Synology section. The OP was having trouble transcoding TrueHD audio, and also had many Slow Query entries in the log. Some of the discussion (iNotify) seems Linux specific, but the rest would apply to any platform.

Point #4 is the relevant part.

TrueHD doesn't decode?

Thanks for the logs. We have a few things to fix. You have more than 8192 diretories you’re trying to monitor. Linux’s default table size isn’t big enough. We need to increase that. Thanks to Synology getting “sneaky” we now must modify their stuff. As root (sudo sh command) change lines 16 & 17 of /etc/init/s2s_daemon.conf, save the changes, then restart DSM. You will need check this after each DSM update to make certain they didn’t undo you enhancement. 16: env MaxWatches=32…