UPDATE: Restoring the DB to a snapshot that I created immediately after restoring onto a new installation, when playlists were correct, doesn’t work to re-set the playlists.
I can always restore from the Linux snapshot I made immediately before wiping and re-installing MacOS, which does work to re-set the playlists, but it’s obviously not ideal b/c that restore requires me re-scanning my watched folders (because the paths change from Linux to Mac). The re-scan takes forever and it’s hard on the drives so it’s not something that’s feasible to do weekly.
This tells me something is happening to the way Roon is processing a fresh DB after the playlists are wiped out (for lack of a better way to explain my guess) on the Mac version of RoonCore. As previously mentioned I’ve run for years on a NAS without this happening (basically the same DB) and ran on Linux for months with no issue. It’s just MacOS with my DB.