peterk
October 13, 2020, 6:53am
#1
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?
flamber
October 13, 2020, 9:39am
#2
Hi @peterk
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:
https://www.metabase.com/docs/latest/operations-guide/running-the-metabase-mac-app.html#the-application-database
And then when you have recovered, then migrate away from H2:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
Then you can setup Docker to refer to the new application database.
peterk
October 13, 2020, 11:04am
#3
@flamber I can’t find metabase.db.h2.db or metabase.db.mv.db anywhere. Also there is not /Metabase in ~/Library/Application Support/
flamber
October 13, 2020, 11:10am
#4
@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.