I also had a corrupted database (see this closed thread) and the corruption also reappeared by restoring from a backup onto a different and fresh machine (M1 MacBook). Well, the first hours the machine does not show any issues, but then I get this corruption message. It happens during analyzing the changed files.
Because I manage my Music in iTunes, It was easy to start a fresh Setup, which works well since days. Interestingly, I now have 96% free on Rock’s 114 GB system volume instead of 75% with nearly the same Data. With the new setup, I’ve currently fewer Tags, less identified albums and less custom artist pictures. I don’t think, that such metadata will make the database so huge.
Today I’ve tried restoring my old backup with the latest Roon version with the same results: some hours after restoring, the database is corrupt again.
So, I’m glad that I haven’t trusted Roon’s proprietary Database and continued storing as much metadata as possible into the files.