Hi @Dale_Rowney,
Thanks for the reply, I’m glad to hear things are still generally more stable than before!
The white entries are normal informational output (the column headers and the file paths the command printed). Only files with out-of-range dates were the concern, and removing the red ones was correct. You do not need to remove the white ones.
Beyond that, we took another deeper look at another fresh Roon Server diagnostic report, and see a slight difference in analysis versus what we’ve observed before.
The dominant finding: 84% of all diagnostic volume (what we analyze) about 959,000 lines, is the library query engine repeatedly re-sorting the same handful of albums
The albums caught in this loop are almost all very low internal IDs, likely the first albums in the database. This is a tight, CPU-bound thrash loop in Roon’s indexing layer that fires hard every time the server starts, then settles. The endmutation operations are taking 6–13 seconds each, where they should take milliseconds. This is what we saw as “Roon working at 95% capacity in the background,” and it’s the mechanism behind the eventual freeze.
The difficulty here is that we’re unable to see which specific albums are causing all the background work, although they do appear to be potential bootleg albums.
That said, Bootleg folders like Warren Haynes & The Midnight Blues Band - (1991)(26-9-1991) Wetlands,New York City,New York are exactly the over-long, near-duplicate names that bloat the indexes that are looping.
Shortening/standardizing those folder names is plausibly therapeutic, not cosmetic, and would very likely continue to help you overall.
This is the same underlying problem, not a separate one. It’s the artwork/album index serving stale cached associations because the index is perpetually mid-rebuild and never reaches a settled state. It corrects on click because clicking forces a fresh read. If the rebuild loop is resolved, this resolves with it. It is not a sign of further corruption.
Thanks for sticking with us for this long, Dale!