H2 migration to postgres fails

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?

Hi @sebanzer
It looks like you are migration and upgrading at the same time. Make sure you migrate using the same version as noted in the documentation:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html#notes

Hi @flamber !

First of all thanks for your reply! I'm running metabase on docker and don't think i'm running a upgrade...
But i'll check! thanks for the hint!!!

Greetings
Sebastian