Roon database corruption and backup restoration issues after recent update (ref#0CR86X)

Support
1

What’s happening?

· Something else

How can we help?

· None of the above

Other options

· My Roon software won't start up

Describe the issue

Roon has been running for years very well within a docker container on my Synology NAS. From sometime in December 2023 I have started to get corrupt database every so often but a backup has always recovered the situation.

Two weeks ago (approximately) a Roon update came through and I accepted this as usual and the update process advised that the database needed an upgrade. However, this ended with a message that the library couldn't be loaded and the "Help Center was there to Help" (or some such). Following directions I recovered Roon by moving the RoonServer directory and having it rebuild. This at least got me back to the screen where I could restore a back. But the last 5 backups that I have tried are apparently all corrupt, or at least completely disable Roon requiring the RoonServer Directory treatment.

I am rebuilding the database right now but I have lost all playlists and other settings.

I have two questions:
1. Was there a problem with the install or an incompatibility between old backups and the new version to the extend that old backups not upgraded as a part of the install process are invalid (now)?
2. Is there any way of restoring the backup as I have tried everything I know how to do and found no articles (quickly) that note the same issue?

Describe your network setup

Synology NAS DSM 7 using Steef de Bruijn's container image. Database is mirrored on two 1TB SSDs.

Come to think of it, at least for the more frequent database failures I have experienced, this might be the issue as I had an SSD failure and was lucky to have enough to recover and then implemented mirroring across two SSDs to save for any future outage. Since then I have had more errors than ever before. Only writing this now gave me this thought.

2

@Slade_Swan just so you know, Roon does not support any installations of Roon on Docker, so you might not get official support from them on this ticket.

1 Like
3

Thanks. That may be the case but my question is largely agnostic of the particular install, at least as I see it. I have lost playlists and it would be nice to get them back if possible. If the upgrade of the database fails for any reason it would seem as if the previous backups from previous versions of the software are unusable (where that version required a database upgrade). Of course I might be completely wrong here however, there is no database upgrade process for a previous back up and reinstalling the roon_server per instructions (albeit from other install types) installs the current release. So if my hypothesis is correct you’re left with inoperable backups.

4

Hi @Slade_Swan ,

Do you by any chance have the Logs from the time of failure? You can try to check for those for clues to discover the corruption type, but it won’t really help with restoring a partial backup, unfortunately there is no way to do so.

Yes, SSD failure is a possible cause of database corruption. It’s possible the failing drive also is causing issues with the stability of the other backups.