Yes I understand that most users don't have this issue. As mentioned I think there have to be some uses of the database/library functions that aren't commonly used, at least to the level that I and others who have similar problems have used them.
And if you are only streaming or have a very small local library, you are not likely to have a significant amount of unidentified albums, which Roon seems to be constantly trying to remedy, but with futility.
Anyway, I'm glad that Roon works well for many. And it works well for me 80% of the time. It just so happens that other 20% seems to be when I really want to listen, and thus, 2 servers, severely reducing the likelihood of both servers being borked at the same time. Plus I just enjoy building these machines.
But to be clear, there is nothing weird about my network, or the machines the cores are running on. One is a clean Ubuntu server install with nothing else running. The other is currently a Win10 machine that has very little else running (i.e. I'll pop a browser to use the chromecast display function and show the artist photo).
As above, my complaint is more about the forum than it is the product.