This is the third issue my Roon installation since January. 2 of these were immediately after a major update. I’m starting to get nervous about applying updates now. I cannot see why my setup should be prone to these sorts of issues.
You might want to give some more details about this to the support team. It almost sounds as though Roon loses contact with the storage device on occasion.
Also, when you say “Roon Rock database now 96% of 232gb”, do you mean that in the Roon Database and Settings section of the web UI it now reads: “4% of 232 GB available”? Because “96% of 232 GB available” is perfectly normal.