Migrating from H2 to PostgreSQL in 0.24.1

Hi, i was using the 0.23.1 version, within docker using a local h2 db.

It is working, so i stop the containter and try to do the migration i got this error:

05-24 16:41:04 INFO metabase.util :: Loading Metabase…
05-24 16:41:04 INFO util.encryption :: DB details encryption is DISABLED for this Metabase instance. :unlock:
05-24 16:41:14 INFO metabase.db :: Verifying postgres Database Connection …
05-24 16:41:14 DEBUG metabase.driver :: Registered driver :postgres :truck:
05-24 16:41:14 INFO metabase.db :: Verify Database Connection … :white_check_mark:
05-24 16:41:14 INFO metabase.db :: Running Database Migrations…
05-24 16:41:14 INFO metabase.db :: Setting up Liquibase…
05-24 16:41:15 INFO metabase.db :: Liquibase is ready.
05-24 16:41:15 INFO metabase.db :: Checking if Database has unrun migrations…
05-24 16:41:36 INFO metabase.db :: Database Migrations Current … :white_check_mark:
com.mchange.v2.cfg.DelayedLogItem [ level -> FINE, text -> “The configuration file for resource identifier ‘hocon:/reference,/application,/c3p0,/’ could not be found. Skipping.”, exception -> null]
Temporarily disabling DB constraints…
[OK]
org.h2.jdbc.JdbcSQLException: Table “METABASE_DATABASE” not found; SQL statement:
SELECT * FROM metabase_database [42102-193]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.command.Parser.readTableOrView(Parser.java:5389)
at org.h2.command.Parser.readTableFilter(Parser.java:1257)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1897)
at org.h2.command.Parser.parseSelectSimple(Parser.java:2045)
at org.h2.command.Parser.parseSelectSub(Parser.java:1891)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1709)
at org.h2.command.Parser.parseSelect(Parser.java:1697)
at org.h2.command.Parser.parsePrepared(Parser.java:445)
at org.h2.command.Parser.parse(Parser.java:317)
at org.h2.command.Parser.parse(Parser.java:289)
at org.h2.command.Parser.prepareCommand(Parser.java:254)
at org.h2.engine.Session.prepareLocal(Session.java:561)
at org.h2.engine.Session.prepareCommand(Session.java:502)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1203)
at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:73)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:287)
at clojure.java.jdbc$prepare_statement.invokeStatic(jdbc.clj:495)
at clojure.java.jdbc$prepare_statement.invoke(jdbc.clj:454)
at clojure.java.jdbc$db_query_with_resultset.invokeStatic(jdbc.clj:846)
at clojure.java.jdbc$db_query_with_resultset.invoke(jdbc.clj:818)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:874)
at clojure.java.jdbc$query.invoke(jdbc.clj:854)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:867)
at clojure.java.jdbc$query.invoke(jdbc.clj:854)
at metabase.cmd.load_from_h2$load_data_BANG_.invokeStatic(load_from_h2.clj:145)
at metabase.cmd.load_from_h2$load_data_BANG_.invoke(load_from_h2.clj:142)
at metabase.cmd.load_from_h2$load_from_h2_BANG_$fn__35286.invoke(load_from_h2.clj:217)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:613)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:629)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:214)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:207)
at clojure.lang.Var.invoke(Var.java:379)
at metabase.core$load_from_h2.invokeStatic(core.clj:209)
at metabase.core$load_from_h2.invoke(core.clj:202)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:646)
at clojure.core$apply.invoke(core.clj:641)
at metabase.core$run_cmd$fn__36058.invoke(core.clj:263)
at metabase.core$run_cmd.invokeStatic(core.clj:263)
at metabase.core$run_cmd.doInvoke(core.clj:262)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:648)
at clojure.core$apply.invoke(core.clj:641)
at metabase.core$_main.invokeStatic(core.clj:277)
at metabase.core$_main.doInvoke(core.clj:273)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
Command failed with exception: Table “METABASE_DATABASE” not found; SQL statement:
SELECT * FROM metabase_database [42102-193]

I made it on 0.24.2 and it worked!

1 Like