October 13, 2020, 6:53am
I think I closed my laptop while the app was opening and corrupted Metabase db. version is 36.7.
I’m moving to Docker, can I save the reports (definitions) from mac app? can anything be saved?
https://www.metabase.com/docs/latest/troubleshooting-guide/application-database.html talks about some Java commands to try to fix db, is this relevant to mac app?
October 13, 2020, 9:39am
Yes, the recovery of H2 is the same, but I would recommend that you recover using the JAR, so get the H2 file from the Mac App location:
And then when you have recovered, then migrate away from H2:
Then you can setup Docker to refer to the new application database.
October 13, 2020, 11:04am
@flamber I can’t find metabase.db.h2.db or metabase.db.mv.db anywhere. Also there is not /Metabase in ~/Library/Application Support/
October 13, 2020, 11:10am
@peterk Can you search for
metabase.db.mv.db - it should be somewhere in your home directory.
Otherwise you shouldn’t see that error upon startup.
Some people were having problems with a hanging process, which locks the H2 database file, but the error is usually different. Anyways, a normal restart of the computer usually resolved the problem for them.