Hi there!
I'm trying to migrate from H2 to postgres database following the guide but i'm getting an error:
Position: 253 Call getNextException to see other errors in the batch.
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:837)
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1546)
at clojure.java.jdbc$execute_batch.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$execute_batch.invoke(jdbc.clj:591)
at clojure.java.jdbc$db_do_execute_prepared_statement$fn__19176.invoke(jdbc.clj:1057)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:860)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_do_execute_prepared_statement.invokeStatic(jdbc.clj:1056)
at clojure.java.jdbc$db_do_execute_prepared_statement.invoke(jdbc.clj:1042)
at clojure.java.jdbc$db_do_prepared.invokeStatic(jdbc.clj:1080)
at clojure.java.jdbc$db_do_prepared.invoke(jdbc.clj:1060)
at clojure.java.jdbc$insert_cols_BANG_.invokeStatic(jdbc.clj:1594)
at clojure.java.jdbc$insert_cols_BANG_.invoke(jdbc.clj:1585)
at clojure.java.jdbc$insert_multi_BANG_.invokeStatic(jdbc.clj:1651)
at clojure.java.jdbc$insert_multi_BANG_.invoke(jdbc.clj:1619)
at metabase.cmd.load_from_h2$insert_chunk_BANG_.invokeStatic(load_from_h2.clj:148)
at metabase.cmd.load_from_h2$insert_chunk_BANG_.invoke(load_from_h2.clj:143)
at metabase.cmd.load_from_h2$insert_entity_BANG_.invokeStatic(load_from_h2.clj:159)
at metabase.cmd.load_from_h2$insert_entity_BANG_.invoke(load_from_h2.clj:153)
at metabase.cmd.load_from_h2$load_data_BANG_.invokeStatic(load_from_h2.clj:167)
at metabase.cmd.load_from_h2$load_data_BANG_.invoke(load_from_h2.clj:162)
at metabase.cmd.load_from_h2$load_from_h2_BANG_$fn__73967.invoke(load_from_h2.clj:259)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:852)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:247)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:236)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:41)
at metabase.cmd$load_from_h2.invoke(cmd.clj:34)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:665)
at clojure.core$apply.invoke(core.clj:660)
at metabase.cmd$run_cmd$fn__73480.invoke(cmd.clj:168)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:168)
at metabase.cmd$run_cmd.invoke(cmd.clj:164)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.core$run_cmd.invokeStatic(core.clj:150)
at metabase.core$run_cmd.invoke(core.clj:148)
at metabase.core$_main.invokeStatic(core.clj:172)
at metabase.core$_main.doInvoke(core.clj:167)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: column "refingerprint" of relation "metabase_database" does not exist
Position: 253
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2497)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2233)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:834)
... 48 more
Command failed with exception: Batch entry 0 INSERT INTO metabase_database ( "description", "cache_field_values_schedule", "timezone", "auto_run_queries", "metadata_sync_schedule", "name", "caveats", "is_full_sync", "updated_at", "details", "is_sample", "id", "is_on_demand", "options", "engine", "refingerprint", "created_at", "points_of_interest" ) VALUES ( NULL, '0 0 0 * * ? *', 'UTC', 'TRUE', '0 0 4 * * ? *', 'XXXXXX', NULL, 'FALSE', '2019-05-28 13:47:31.718+00', '{"host":"XXXXXX","port":3306,"dbname":"XXXXXX","user":"XXXXX","password":"XXXXXX","tunnel-port":22,"let-user-control-scheduling":true,"ssl":false}', 'FALSE', 2, 'FALSE', NULL, 'mysql', NULL, '2019-05-28 13:47:31.313+00', NULL ) was aborted: ERROR: column "refingerprint" of relation "metabase_database" does not exist
Position: 253 Call getNextException to see other errors in the batch.
any ideas why this is happening?