Error in Migrating from H2 to MYSQL

kezzat · August 15, 2023, 1:03pm

Hello there,
I have Metabase v0.44.0 running locally on windows 10 with H2 database, I'm trying to migrate the database from H2 to MYSQL WB v8.0.34, after that I'm looking to upgrade the MetaBase version.

So the steps I've taken are:

Downloaded MYSQL and Created an empty database

CREATE DATABASE metabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Solved MYSQL v8 password authentication bug with this command

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password.';

Ran the migration script

java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://localhost:3306/metabase?user=root&password=password." -jar metabase.jar load-from-h2 metabase.db

Those steps the farthest i could get, metabase sql database contains all tables but there is an error in the migration process, and i cant start metabase with sql, the logs will be bellow.

Migration logs:

C:\Users\Khaled Ezzat\Downloads\saleh_elhadidy>java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://localhost:3306/metabase?user=root&password=password" -jar metabase.jar load-from-h2 metabase.db
Warning: protocol #'java-time.core/Amount is overwriting function abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time.core, being replaced by: #'java-time.core/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time, being replaced by: #'java-time/abs
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2023-08-15 14:49:00,141 INFO metabase.util :: Maximum memory available to JVM: 4.0 GB
2023-08-15 14:49:01,777 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
WARNING: abs already refers to: #'clojure.core/abs in namespace: taoensso.encore, being replaced by: #'taoensso.encore/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.math, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.test, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.distribution, being replaced by: #'kixi.stats.math/abs
2023-08-15 14:49:06,531 INFO driver.impl :: Registered abstract driver :sql
2023-08-15 14:49:06,534 INFO metabase.util :: ? Load driver :sql took 52.1 ms
2023-08-15 14:49:06,539 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2023-08-15 14:49:06,542 INFO metabase.util :: Load driver :sql-jdbc took 62.0 ms
2023-08-15 14:49:06,542 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2023-08-15 14:49:06,561 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2023-08-15 14:49:06,574 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2023-08-15 14:49:07,585 INFO metabase.core ::
Metabase v0.44.0 (d3700f5 release-x.44.x)

Copyright ⌐ 2023 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2023-08-15 14:49:07,618 INFO cmd.copy :: Set up h2 source database and run migrations...
2023-08-15 14:49:07,620 INFO db.setup :: Verifying h2 Database Connection ...
2023-08-15 14:49:08,032 INFO db.setup :: Successfully verified H2 1.4.197 (2018-03-18) application database connection.
2023-08-15 14:49:08,034 INFO db.setup :: Running Database Migrations...
2023-08-15 14:49:08,035 INFO db.setup :: Setting up Liquibase...
2023-08-15 14:49:08,219 INFO db.setup :: Liquibase is ready.
2023-08-15 14:49:08,220 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-08-15 14:49:09,038 INFO db.setup :: Database Migrations Current ...
2023-08-15 14:49:09,039 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2023-08-15 14:49:09,047 INFO db.data-migrations :: Finished running data migrations.
2023-08-15 14:49:09,048 INFO metabase.util :: Database setup took 1.4 s
2023-08-15 14:49:09,048 INFO cmd.copy :: [OK]
2023-08-15 14:49:09,049 INFO cmd.copy :: Set up mysql target database and run migrations...
2023-08-15 14:49:09,050 INFO db.setup :: Verifying mysql Database Connection ...
2023-08-15 14:49:09,129 INFO db.setup :: Successfully verified MySQL 8.0.34 application database connection.
2023-08-15 14:49:09,130 INFO db.setup :: Running Database Migrations...
2023-08-15 14:49:09,131 INFO db.setup :: Setting up Liquibase...
2023-08-15 14:49:09,144 INFO db.setup :: Liquibase is ready.
2023-08-15 14:49:09,144 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-08-15 14:49:09,537 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2023-08-15 14:49:09,598 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2023-08-15 14:49:09,702 INFO db.setup :: Database Migrations Current ...
2023-08-15 14:49:09,703 INFO metabase.util :: Database setup took 652.9 ms
2023-08-15 14:49:09,704 INFO cmd.copy :: [OK]
2023-08-15 14:49:09,705 INFO cmd.copy :: Testing if target mysql database is already populated...
2023-08-15 14:49:09,706 INFO cmd.copy :: [OK]
2023-08-15 14:49:09,707 INFO cmd.copy :: Clearing default entries created by Liquibase migrations...
2023-08-15 14:49:09,708 INFO cmd.copy :: Temporarily disabling DB constraints...
2023-08-15 14:49:09,709 INFO cmd.copy :: [OK]
2023-08-15 14:49:10,799 INFO cmd.copy :: Re-enabling DB constraints...
2023-08-15 14:49:10,800 INFO cmd.copy :: [OK]
2023-08-15 14:49:10,800 INFO cmd.copy :: [OK]
2023-08-15 14:49:10,802 INFO cmd.copy :: Temporarily disabling DB constraints...
2023-08-15 14:49:10,803 INFO cmd.copy :: [OK]
2023-08-15 14:49:10,808 INFO cmd.copy :: Copying instances of Database...
2023-08-15 14:49:10,814 INFO cmd.copy :: copied 1 instances.
2023-08-15 14:49:10,817 INFO cmd.copy :: Copying instances of User...
2023-08-15 14:49:10,830 INFO cmd.copy :: copied 43 instances.
2023-08-15 14:49:10,833 INFO cmd.copy :: Copying instances of Setting...
2023-08-15 14:49:10,838 INFO cmd.copy :: copied 23 instances.
2023-08-15 14:49:10,846 INFO cmd.copy :: Copying instances of Table...
2023-08-15 14:49:10,891 ERROR cmd.copy :: BatchUpdateException:
Message: (conn=16) Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
SQLState: 23000
Error Code: 1062

2023-08-15 14:49:10,892 INFO cmd.copy :: Re-enabling DB constraints...
2023-08-15 14:49:10,893 INFO cmd.copy :: [OK]
clojure.lang.ExceptionInfo: Error copying instances of Table {:entity "Table"}
at metabase.cmd.copy$copy_data_BANG_$fn__81696$fn__81697.invoke(copy.clj:187)
at metabase.cmd.copy$copy_data_BANG_$fn__81696.invoke(copy.clj:184)
at clojure.core$partition_all$fn__8625$fn__8626.invoke(core.clj:7332)
at clojure.java.jdbc$init_reduce_rs.invokeStatic(jdbc.clj:1205)
at clojure.java.jdbc$init_reduce_rs.invoke(jdbc.clj:1197)
at clojure.java.jdbc$reducible_result_set_STAR_$reify__28540.reduce(jdbc.clj:1227)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at clojure.java.jdbc$query_reducer$fn__28546$fn__28549.invoke(jdbc.clj:1262)
at clojure.java.jdbc$execute_query_with_params.invokeStatic(jdbc.clj:1091)
at clojure.java.jdbc$execute_query_with_params.invoke(jdbc.clj:1084)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1106)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$reducible_query$reify__28563.reduce(jdbc.clj:1357)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core$transduce.invoke(core.clj:6933)
at metabase.cmd.copy$copy_data_BANG_.invokeStatic(copy.clj:172)
at metabase.cmd.copy$copy_data_BANG_.invoke(copy.clj:164)
at metabase.cmd.copy$fn__81801$copy_BANG___81806$fn__81807$fn__81816$fn__81817$fn__81818.invoke(copy.clj:359)
at metabase.cmd.copy$do_with_disabled_db_constraints.invokeStatic(copy.clj:264)
at metabase.cmd.copy$do_with_disabled_db_constraints.invoke(copy.clj:260)
at metabase.cmd.copy$fn__81801$copy_BANG___81806$fn__81807$fn__81816$fn__81817.invoke(copy.clj:358)
at metabase.cmd.copy$do_with_connection_rollback_only.invokeStatic(copy.clj:206)
at metabase.cmd.copy$do_with_connection_rollback_only.invoke(copy.clj:204)
at metabase.cmd.copy$fn__81801$copy_BANG___81806$fn__81807$fn__81816.invoke(copy.clj:356)
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.copy$fn__81801$copy_BANG___81806$fn__81807.invoke(copy.clj:353)
at metabase.cmd.copy$fn__81801$copy_BANG___81806.invoke(copy.clj:331)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:35)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:25)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:45)
at metabase.cmd$load_from_h2.invoke(cmd.clj:39)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.cmd$run_cmd$fn__82598.invoke(cmd.clj:227)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:227)
at metabase.cmd$run_cmd.invoke(cmd.clj:218)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.core$run_cmd.invokeStatic(core.clj:160)
at metabase.core$run_cmd.invoke(core.clj:158)
at metabase.core$main.invokeStatic(core.clj:182)
at metabase.core$main.doInvoke(core.clj:177)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
Caused by: java.sql.BatchUpdateException: (conn=16) Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:327)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeBatch(ClientSidePreparedStatement.java:299)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
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.invokeStatic(jdbc.clj:1058)
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:1653)
at clojure.java.jdbc$insert_multi_BANG_.invoke(jdbc.clj:1619)
at metabase.cmd.copy$insert_chunk_BANG_.invokeStatic(copy.clj:155)
at metabase.cmd.copy$insert_chunk_BANG_.invoke(copy.clj:149)
at metabase.cmd.copy$copy_data_BANG_$fn__81696$fn__81697.invoke(copy.clj:185)
... 51 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=16) Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:70)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:323)
... 66 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.access$000(AbstractQueryProtocol.java:107)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol$1.handleResultException(AbstractQueryProtocol.java:692)
at org.mariadb.jdbc.internal.protocol.AsyncMultiRead.call(AsyncMultiRead.java:141)
at org.mariadb.jdbc.internal.protocol.AsyncMultiRead.call(AsyncMultiRead.java:67)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLException: Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at org.mariadb.jdbc.internal.protocol.AsyncMultiRead.call(AsyncMultiRead.java:132)
... 5 more
Command failed with exception: Error copying instances of Table

Running Metabase with SQL connection logs:

java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://localhost:3306/metabase?user=root&password=password" -jar metabase.jar

Logs:

C:\Users\Khaled Ezzat\Downloads\saleh_elhadidy>java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://localhost:3306/metabase?user=root&password=password" -jar metabase.jar
Warning: protocol #'java-time.core/Amount is overwriting function abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time.core, being replaced by: #'java-time.core/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: java-time, being replaced by: #'java-time/abs
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2023-08-15 14:59:44,163 INFO metabase.util :: Maximum memory available to JVM: 4.0 GB
2023-08-15 14:59:45,790 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
WARNING: abs already refers to: #'clojure.core/abs in namespace: taoensso.encore, being replaced by: #'taoensso.encore/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.math, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.test, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.distribution, being replaced by: #'kixi.stats.math/abs
2023-08-15 14:59:50,602 INFO driver.impl :: Registered abstract driver :sql
2023-08-15 14:59:50,604 INFO metabase.util :: ? Load driver :sql took 73.2 ms
2023-08-15 14:59:50,609 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2023-08-15 14:59:50,611 INFO metabase.util :: Load driver :sql-jdbc took 82.2 ms
2023-08-15 14:59:50,611 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2023-08-15 14:59:50,631 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2023-08-15 14:59:50,645 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2023-08-15 14:59:51,756 INFO metabase.core ::
Metabase v0.44.0 (d3700f5 release-x.44.x)

Copyright ⌐ 2023 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2023-08-15 14:59:51,763 INFO metabase.core :: Starting Metabase in STANDALONE mode
2023-08-15 14:59:51,789 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000}

2023-08-15 14:59:51,820 INFO metabase.core :: Starting Metabase version v0.44.0 (d3700f5 release-x.44.x) ...
2023-08-15 14:59:51,843 INFO metabase.core :: System info:
{"file.encoding" "Cp1252",
"java.runtime.name" "Java(TM) SE Runtime Environment",
"java.runtime.version" "17.0.1+12-LTS-39",
"java.vendor" "Oracle Corporation",
"java.vendor.url" "https://java.oracle.com/",
"java.version" "17.0.1",
"java.vm.name" "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version" "17.0.1+12-LTS-39",
"os.name" "Windows 10",
"os.version" "10.0",
"user.language" "en",
"user.timezone" "Africa/Cairo"}

2023-08-15 14:59:51,846 INFO metabase.plugins :: Loading plugins in C:\Users\Khaled Ezzat\Downloads\saleh_elhadidy\plugins...
2023-08-15 14:59:52,076 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2023-08-15 14:59:52,082 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql])
2023-08-15 14:59:52,089 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2023-08-15 14:59:52,090 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2023-08-15 14:59:52,091 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase BigQuery Driver"]
2023-08-15 14:59:52,096 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2023-08-15 14:59:52,097 INFO driver.impl :: Registered driver :druid
2023-08-15 14:59:52,101 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2023-08-15 14:59:52,101 INFO driver.impl :: Registered abstract driver :google
2023-08-15 14:59:52,102 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2023-08-15 14:59:52,103 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver"]
2023-08-15 14:59:52,104 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2023-08-15 14:59:52,104 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2023-08-15 14:59:52,105 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google])
2023-08-15 14:59:52,110 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2023-08-15 14:59:52,111 INFO driver.impl :: Registered driver :googleanalytics
2023-08-15 14:59:52,119 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2023-08-15 14:59:52,119 INFO driver.impl :: Registered driver :mongo
2023-08-15 14:59:52,126 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-08-15 14:59:52,127 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2023-08-15 14:59:52,127 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2023-08-15 14:59:52,131 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-common...
2023-08-15 14:59:52,132 INFO driver.impl :: Registered abstract driver :presto-common
2023-08-15 14:59:52,143 INFO plugins.dependencies :: Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
2023-08-15 14:59:52,144 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
2023-08-15 14:59:52,144 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2023-08-15 14:59:52,145 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:presto-common])
2023-08-15 14:59:52,149 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
2023-08-15 14:59:52,149 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
2023-08-15 14:59:52,149 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2023-08-15 14:59:52,151 INFO driver.impl :: Registered driver :presto (parents: [:presto-common])
2023-08-15 14:59:52,155 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2023-08-15 14:59:52,156 INFO driver.impl :: Registered driver :redshift (parents: [:postgres])
2023-08-15 14:59:52,169 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2023-08-15 14:59:52,170 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc])
2023-08-15 14:59:52,176 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2023-08-15 14:59:52,177 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc])
2023-08-15 14:59:52,177 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2023-08-15 14:59:52,177 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like])
2023-08-15 14:59:52,181 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2023-08-15 14:59:52,181 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc])
2023-08-15 14:59:52,185 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2023-08-15 14:59:52,186 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc])
2023-08-15 14:59:52,190 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-08-15 14:59:52,191 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2023-08-15 14:59:52,191 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]
2023-08-15 14:59:52,191 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2023-08-15 14:59:52,194 INFO db.setup :: Verifying mysql Database Connection ...
2023-08-15 14:59:52,273 INFO db.setup :: Successfully verified MySQL 8.0.34 application database connection.
2023-08-15 14:59:52,274 INFO db.setup :: Running Database Migrations...
2023-08-15 14:59:52,275 INFO db.setup :: Setting up Liquibase...
2023-08-15 14:59:52,378 INFO db.setup :: Liquibase is ready.
2023-08-15 14:59:52,379 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-08-15 14:59:53,064 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2023-08-15 14:59:53,135 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2023-08-15 14:59:53,246 INFO db.setup :: Database Migrations Current ...
2023-08-15 14:59:53,259 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2023-08-15 14:59:53,271 INFO db.data-migrations :: Running data migration 'migrate-click-through'...
2023-08-15 14:59:53,298 INFO db.data-migrations :: Running data migration 'migrate-remove-admin-from-group-mapping-if-needed'...
2023-08-15 14:59:53,308 ERROR metabase.core :: Metabase Initialization FAILED
clojure.lang.ExceptionInfo: Fatal error: magic Permissions Group "Administrators" has gone missing. {:name "Administrators"}
at metabase.models.permissions_group$magic_group$fn__33329.invoke(permissions_group.clj:34)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.db.connection$memoize_for_application_db$fn__20151.doInvoke(connection.clj:104)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$memoize$fn__6946.doInvoke(core.clj:6388)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.db.connection$memoize_for_application_db$fn__20153.doInvoke(connection.clj:106)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.db.data_migrations$remove_admin_group_from_mappings_by_setting_key_BANG_.invokeStatic(data_migrations.clj:192)
at metabase.db.data_migrations$remove_admin_group_from_mappings_by_setting_key_BANG_.invoke(data_migrations.clj:190)
at metabase.db.data_migrations$migrate_remove_admin_from_group_mapping_if_needed.invokeStatic(data_migrations.clj:218)
at metabase.db.data_migrations$migrate_remove_admin_from_group_mapping_if_needed.invoke(data_migrations.clj:205)
at metabase.db.data_migrations$run_migration_if_needed_BANG_$fn__81559$fn__81560.invoke(data_migrations.clj:39)
at toucan.db$do_in_transaction$fn__29053.invoke(db.clj:147)
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 toucan.db$do_in_transaction.invokeStatic(db.clj:145)
at toucan.db$do_in_transaction.invoke(db.clj:142)
at metabase.db.data_migrations$run_migration_if_needed_BANG_$fn__81559.invoke(data_migrations.clj:38)
at metabase.db.data_migrations$run_migration_if_needed_BANG_.invokeStatic(data_migrations.clj:37)
at metabase.db.data_migrations$run_migration_if_needed_BANG_.invoke(data_migrations.clj:25)
at metabase.db.data_migrations$run_all_BANG_.invokeStatic(data_migrations.clj:63)
at metabase.db.data_migrations$run_all_BANG_.invoke(data_migrations.clj:57)
at clojure.lang.Var.invoke(Var.java:380)
at metabase.db.setup$fn__35513$run_data_migrations_BANG___35518$fn__35519.invoke(setup.clj:131)
at metabase.db.setup$fn__35513$run_data_migrations_BANG___35518.invoke(setup.clj:122)
at metabase.db.setup$fn__35538$setup_db_BANG___35543$fn__35544$fn__35547$fn__35548.invoke(setup.clj:146)
at metabase.util$do_with_us_locale.invokeStatic(util.clj:716)
at metabase.util$do_with_us_locale.invoke(util.clj:702)
at metabase.db.setup$fn__35538$setup_db_BANG___35543$fn__35544$fn__35547.invoke(setup.clj:143)
at metabase.db.setup$fn__35538$setup_db_BANG___35543$fn__35544.invoke(setup.clj:142)
at metabase.db.setup$fn__35538$setup_db_BANG___35543.invoke(setup.clj:136)
at metabase.db$setup_db_BANG_$fn__35573.invoke(db.clj:65)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:60)
at metabase.db$setup_db_BANG_.invoke(db.clj:51)
at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:98)
at metabase.core$init_BANG__STAR_.invoke(core.clj:81)
at metabase.core$init_BANG_.invokeStatic(core.clj:138)
at metabase.core$init_BANG_.invoke(core.clj:133)
at metabase.core$start_normally.invokeStatic(core.clj:150)
at metabase.core$start_normally.invoke(core.clj:144)
at metabase.core$_main.invokeStatic(core.clj:183)
at metabase.core$_main.doInvoke(core.clj:177)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
2023-08-15 14:59:53,317 INFO metabase.core :: Metabase Shutting Down ...
2023-08-15 14:59:53,317 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2023-08-15 14:59:53,326 INFO metabase.core :: Metabase Shutdown COMPLETE

am i doing the steps right, am i missing anything, hope to help.

AndrewMBaines · August 16, 2023, 9:42am

Upgrade to the latest version using just H2.
Then migrate to MySQL.

I'd also change the JVM to Adoptium or similar rather than using Oracle. That's just to avoid a visit from the Oracle licensing team.

kezzat · August 29, 2023, 11:04am

Hello again, thanks a lot for help and notes @AndrewMBaines, I've upgraded to the latest version of metabase by downloading and replacing the jar file, running a migration script to MYSQL failed again.

Migration logs:

C:\Users\Khaled Ezzat\Downloads\xNotes\VM Inistances (Metabase)\Files\Metabase Update attempt>java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://localhost:3306/metabase?user=root&password=password." -jar metabase.jar load-from-h2 metabase.db
2023-08-29 12:45:44,096 INFO metabase.util :: Maximum memory available to JVM: 4.0 GB
2023-08-29 12:45:45,698 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
2023-08-29 12:45:52,920 INFO driver.impl :: Registered abstract driver :sql
2023-08-29 12:45:52,928 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2023-08-29 12:45:52,931 INFO metabase.util :: Load driver :sql-jdbc took 65.6 ms
2023-08-29 12:45:52,932 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2023-08-29 12:45:52,963 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2023-08-29 12:45:52,985 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2023-08-29 12:45:54,275 INFO metabase.core ::
Metabase v0.47.0 (682ec2d release-x.47.x)

Copyright ⌐ 2023 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2023-08-29 12:45:54,318 INFO cmd.copy :: Set up h2 source database and run migrations...
2023-08-29 12:45:54,320 INFO db.setup :: Verifying h2 Database Connection ...
2023-08-29 12:45:54,644 INFO db.setup :: Successfully verified H2 2.1.214 (2022-06-13) application database connection.
2023-08-29 12:45:54,645 INFO db.setup :: Running Database Migrations...
2023-08-29 12:45:54,647 INFO db.setup :: Setting up Liquibase...
2023-08-29 12:45:54,796 INFO db.setup :: Liquibase is ready.
2023-08-29 12:45:54,796 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-08-29 12:45:55,549 INFO db.setup :: Database Migrations Current ...
2023-08-29 12:45:55,549 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2023-08-29 12:45:55,891 INFO db.data-migrations :: Finished running data migrations.
2023-08-29 12:45:55,892 INFO metabase.util :: Database setup took 1.6 s
2023-08-29 12:45:55,892 INFO cmd.copy :: [OK]
2023-08-29 12:45:55,893 INFO cmd.copy :: Set up mysql target database and run migrations...
2023-08-29 12:45:55,893 INFO db.setup :: Verifying mysql Database Connection ...
2023-08-29 12:45:55,974 INFO db.setup :: Successfully verified MySQL 8.0.34 application database connection.
2023-08-29 12:45:55,974 INFO db.setup :: Running Database Migrations...
2023-08-29 12:45:55,975 INFO db.setup :: Setting up Liquibase...
2023-08-29 12:45:55,982 INFO db.setup :: Liquibase is ready.
2023-08-29 12:45:55,982 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-08-29 12:45:56,584 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2023-08-29 12:45:56,686 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2023-08-29 12:46:27,548 INFO impl.StdSchedulerFactory :: Using default implementation for ThreadExecutor
2023-08-29 12:46:27,556 INFO core.SchedulerSignalerImpl :: Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2023-08-29 12:46:27,556 INFO core.QuartzScheduler :: Quartz Scheduler v.2.3.2 created.
2023-08-29 12:46:27,557 INFO jdbcjobstore.JobStoreTX :: Using db table-based data access locking (synchronization).
2023-08-29 12:46:27,558 INFO jdbcjobstore.JobStoreTX :: JobStoreTX initialized.
2023-08-29 12:46:27,559 INFO core.QuartzScheduler :: Scheduler meta-data: Quartz Scheduler (v2.3.2) 'MetabaseScheduler' with instanceId 'DESKTOP-4HPCJHL1693305987550'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is clustered.

2023-08-29 12:46:27,559 INFO impl.StdSchedulerFactory :: Quartz scheduler 'MetabaseScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2023-08-29 12:46:27,559 INFO impl.StdSchedulerFactory :: Quartz scheduler version: 2.3.2
2023-08-29 12:46:27,578 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler_$DESKTOP-4HPCJHL1693305987550 started.
2023-08-29 12:46:27,591 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler$DESKTOP-4HPCJHL1693305987550 shutting down.
2023-08-29 12:46:27,591 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler$DESKTOP-4HPCJHL1693305987550 paused.
2023-08-29 12:46:27,593 INFO core.QuartzScheduler :: Scheduler MetabaseScheduler$_DESKTOP-4HPCJHL1693305987550 shutdown complete.
2023-08-29 12:46:28,928 INFO db.custom-migrations :: No forward migration for DowngradeDashboardTab
2023-08-29 12:46:29,702 INFO db.setup :: Database Migrations Current ...
2023-08-29 12:46:29,703 INFO metabase.util :: Database setup took 33.8 s
2023-08-29 12:46:29,704 INFO cmd.copy :: [OK]
2023-08-29 12:46:29,705 INFO cmd.copy :: Testing if target mysql database is already populated...
2023-08-29 12:46:29,712 INFO cmd.copy :: [OK]
2023-08-29 12:46:29,713 INFO cmd.copy :: Clearing default entries created by Liquibase migrations...
2023-08-29 12:46:29,715 INFO cmd.copy :: Temporarily disabling DB constraints...
2023-08-29 12:46:29,716 INFO cmd.copy :: [OK]
2023-08-29 12:46:31,760 INFO cmd.copy :: Re-enabling DB constraints...
2023-08-29 12:46:31,762 INFO cmd.copy :: [OK]
2023-08-29 12:46:31,763 INFO cmd.copy :: [OK]
2023-08-29 12:46:31,771 INFO cmd.copy :: Temporarily disabling DB constraints...
2023-08-29 12:46:31,772 INFO cmd.copy :: [OK]
2023-08-29 12:46:31,779 INFO cmd.copy :: Copying instances of Database...
2023-08-29 12:46:31,786 INFO cmd.copy :: copied 1 instances.
2023-08-29 12:46:31,789 INFO cmd.copy :: Copying instances of User...
2023-08-29 12:46:31,800 INFO cmd.copy :: copied 43 instances.
2023-08-29 12:46:31,802 INFO cmd.copy :: Copying instances of Setting...
2023-08-29 12:46:31,812 INFO cmd.copy :: copied 23 instances.
2023-08-29 12:46:31,818 INFO cmd.copy :: Copying instances of Table...
2023-08-29 12:46:31,865 ERROR cmd.copy :: BatchUpdateException:
Message: (conn=32) Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
SQLState: 23000
Error Code: 1062

2023-08-29 12:46:31,866 INFO cmd.copy :: Re-enabling DB constraints...
2023-08-29 12:46:31,868 INFO cmd.copy :: [OK]
clojure.lang.ExceptionInfo: Error copying instances of Table {:model "Table"}
at metabase.cmd.copy$copy_data_BANG_$fn__112773$fn__112774.invoke(copy.clj:226)
at metabase.cmd.copy$copy_data_BANG_$fn__112773.invoke(copy.clj:223)
at clojure.core$partition_all$fn__8625$fn__8626.invoke(core.clj:7332)
at clojure.java.jdbc$init_reduce_rs.invokeStatic(jdbc.clj:1205)
at clojure.java.jdbc$init_reduce_rs.invoke(jdbc.clj:1197)
at clojure.java.jdbc$reducible_result_set_STAR_$reify__21745.reduce(jdbc.clj:1227)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at clojure.java.jdbc$query_reducer$fn__21751$fn__21754.invoke(jdbc.clj:1262)
at clojure.java.jdbc$execute_query_with_params.invokeStatic(jdbc.clj:1091)
at clojure.java.jdbc$execute_query_with_params.invoke(jdbc.clj:1084)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1106)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$reducible_query$reify__21768.reduce(jdbc.clj:1357)
at clojure.core$transduce.invokeStatic(core.clj:6946)
at clojure.core$transduce.invoke(core.clj:6933)
at metabase.cmd.copy$copy_data_BANG_.invokeStatic(copy.clj:210)
at metabase.cmd.copy$copy_data_BANG_.invoke(copy.clj:204)
at metabase.cmd.copy$fn__112893$copy_BANG___112898$fn__112899$fn__112908$fn__112909$fn__112910.invoke(copy.clj:414)
at metabase.cmd.copy$do_with_disabled_db_constraints.invokeStatic(copy.clj:303)
at metabase.cmd.copy$do_with_disabled_db_constraints.invoke(copy.clj:299)
at metabase.cmd.copy$fn__112893$copy_BANG___112898$fn__112899$fn__112908$fn__112909.invoke(copy.clj:413)
at metabase.cmd.copy$do_with_connection_rollback_only.invokeStatic(copy.clj:245)
at metabase.cmd.copy$do_with_connection_rollback_only.invoke(copy.clj:243)
at metabase.cmd.copy$fn__112893$copy_BANG___112898$fn__112899$fn__112908.invoke(copy.clj:411)
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.copy$fn__112893$copy_BANG___112898$fn__112899.invoke(copy.clj:408)
at metabase.cmd.copy$fn__112893$copy_BANG___112898.invoke(copy.clj:385)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:36)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:26)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:73)
at metabase.cmd$load_from_h2.invoke(cmd.clj:67)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.cmd$run_cmd$fn__113981.invoke(cmd.clj:293)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:292)
at metabase.cmd$run_cmd.invoke(cmd.clj:282)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.core$run_cmd.invokeStatic(core.clj:181)
at metabase.core$run_cmd.invoke(core.clj:179)
at metabase.core$main.invokeStatic(core.clj:203)
at metabase.core$main.doInvoke(core.clj:198)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at clojure.lang.Var.applyTo(Var.java:705)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.bootstrap$main.invokeStatic(bootstrap.clj:31)
at metabase.bootstrap$main.doInvoke(bootstrap.clj:28)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.bootstrap.main(Unknown Source)
Caused by: java.sql.BatchUpdateException: (conn=32) Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:323)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeBatch(ClientSidePreparedStatement.java:299)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
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.invokeStatic(jdbc.clj:1058)
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:1653)
at clojure.java.jdbc$insert_multi_BANG.invoke(jdbc.clj:1619)
at metabase.cmd.copy$insert_chunk_BANG_.invokeStatic(copy.clj:163)
at metabase.cmd.copy$insert_chunk_BANG_.invoke(copy.clj:157)
at metabase.cmd.copy$copy_data_BANG_$fn__112773$fn__112774.invoke(copy.clj:224)
... 57 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=32) Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:70)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:319)
... 72 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.access$000(AbstractQueryProtocol.java:107)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol$1.handleResultException(AbstractQueryProtocol.java:692)
at org.mariadb.jdbc.internal.protocol.AsyncMultiRead.call(AsyncMultiRead.java:141)
at org.mariadb.jdbc.internal.protocol.AsyncMultiRead.call(AsyncMultiRead.java:67)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLException: Duplicate entry '129-mongov2_brantu-VUnitOccasions' for key 'metabase_table.idx_uniq_table_db_id_schema_name'
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at org.mariadb.jdbc.internal.protocol.AsyncMultiRead.call(AsyncMultiRead.java:132)
... 5 more
Command failed with exception: Error copying instances of Table

and for running Metabase with SQL connection logs:

C:\Users\Khaled Ezzat\Downloads\xNotes\VM Inistances (Metabase)\Files\Metabase Update attempt>java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://localhost:3306/metabase?user=root&password=password." -jar metabase.jar
2023-08-29 12:57:02,164 INFO metabase.util :: Maximum memory available to JVM: 4.0 GB
2023-08-29 12:57:03,444 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
2023-08-29 12:57:10,202 INFO driver.impl :: Registered abstract driver :sql
2023-08-29 12:57:10,210 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2023-08-29 12:57:10,214 INFO metabase.util :: Load driver :sql-jdbc took 62.4 ms
2023-08-29 12:57:10,215 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2023-08-29 12:57:10,244 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2023-08-29 12:57:10,271 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2023-08-29 12:57:11,528 INFO metabase.core ::
Metabase v0.47.0 (682ec2d release-x.47.x)

Copyright ⌐ 2023 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2023-08-29 12:57:11,536 INFO metabase.core :: Starting Metabase in STANDALONE mode
2023-08-29 12:57:11,576 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000}

2023-08-29 12:57:11,612 INFO metabase.core :: Starting Metabase version v0.47.0 (682ec2d release-x.47.x) ...
2023-08-29 12:57:11,630 INFO metabase.core :: System info:
{"file.encoding" "Cp1252",
"java.runtime.name" "Java(TM) SE Runtime Environment",
"java.runtime.version" "17.0.1+12-LTS-39",
"java.vendor" "Oracle Corporation",
"java.vendor.url" "https://java.oracle.com/",
"java.version" "17.0.1",
"java.vm.name" "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version" "17.0.1+12-LTS-39",
"os.name" "Windows 10",
"os.version" "10.0",
"user.language" "en",
"user.timezone" "Africa/Cairo"}

2023-08-29 12:57:11,635 INFO metabase.plugins :: Loading plugins in C:\Users\Khaled Ezzat\Downloads\xNotes\VM Inistances (Metabase)\Files\Metabase Update attempt\plugins...
2023-08-29 12:57:11,893 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :athena...
2023-08-29 12:57:11,893 INFO driver.impl :: Registered driver :athena (parents: [:sql-jdbc])
2023-08-29 12:57:11,916 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2023-08-29 12:57:11,916 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql])
2023-08-29 12:57:11,925 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2023-08-29 12:57:11,926 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2023-08-29 12:57:11,928 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase BigQuery Driver"]
2023-08-29 12:57:11,936 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2023-08-29 12:57:11,936 INFO driver.impl :: Registered driver :druid
2023-08-29 12:57:11,942 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2023-08-29 12:57:11,944 INFO driver.impl :: Registered abstract driver :google
2023-08-29 12:57:11,945 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2023-08-29 12:57:11,946 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver"]
2023-08-29 12:57:11,946 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2023-08-29 12:57:11,947 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2023-08-29 12:57:11,947 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google])
2023-08-29 12:57:11,954 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2023-08-29 12:57:11,955 INFO driver.impl :: Registered driver :googleanalytics
2023-08-29 12:57:11,967 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2023-08-29 12:57:11,968 INFO driver.impl :: Registered driver :mongo
2023-08-29 12:57:11,975 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-08-29 12:57:11,976 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2023-08-29 12:57:11,976 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2023-08-29 12:57:11,981 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-common...
2023-08-29 12:57:11,981 INFO driver.impl :: Registered abstract driver :presto-common
2023-08-29 12:57:11,994 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2023-08-29 12:57:11,994 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:sql-jdbc])
2023-08-29 12:57:12,000 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
2023-08-29 12:57:12,000 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
2023-08-29 12:57:12,001 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2023-08-29 12:57:12,008 INFO driver.impl :: Registered driver :presto (parents: [:presto-common])
2023-08-29 12:57:12,013 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2023-08-29 12:57:12,013 INFO driver.impl :: Registered driver :redshift (parents: [:postgres])
2023-08-29 12:57:12,029 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2023-08-29 12:57:12,029 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc])
2023-08-29 12:57:12,041 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2023-08-29 12:57:12,041 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc])
2023-08-29 12:57:12,042 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2023-08-29 12:57:12,042 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like])
2023-08-29 12:57:12,048 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2023-08-29 12:57:12,048 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc])
2023-08-29 12:57:12,053 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2023-08-29 12:57:12,055 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc])
2023-08-29 12:57:12,059 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2023-08-29 12:57:12,060 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2023-08-29 12:57:12,060 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]
2023-08-29 12:57:12,061 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2023-08-29 12:57:12,073 INFO db.setup :: Verifying mysql Database Connection ...
2023-08-29 12:57:12,144 INFO db.setup :: Successfully verified MySQL 8.0.34 application database connection.
2023-08-29 12:57:12,146 INFO db.setup :: Running Database Migrations...
2023-08-29 12:57:12,148 INFO db.setup :: Setting up Liquibase...
2023-08-29 12:57:12,248 INFO db.setup :: Liquibase is ready.
2023-08-29 12:57:12,249 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-08-29 12:57:12,968 INFO db.setup :: Database Migrations Current ...
2023-08-29 12:57:12,977 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2023-08-29 12:57:13,330 INFO db.data-migrations :: Running data migration 'migrate-remove-admin-from-group-mapping-if-needed'...
2023-08-29 12:57:13,366 ERROR metabase.core :: Metabase Initialization FAILED
clojure.lang.ExceptionInfo: Fatal error: magic Permissions Group "Administrators" has gone missing. {:name "Administrators", :toucan2/context-trace [["resolve connection" {:toucan2.connection/connectable metabase.db.connection.ApplicationDB}] ["resolve connection" {:toucan2.connection/connectable :default}] ["resolve connection" {:toucan2.connection/connectable nil}]]}
at metabase.models.permissions_group$magic_group$fn__48642.invoke(permissions_group.clj:42)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.db.connection$memoize_for_application_db$fn__41302.doInvoke(connection.clj:133)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$memoize$fn__6946.doInvoke(core.clj:6388)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.db.connection$memoize_for_application_db$fn__41304.doInvoke(connection.clj:135)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.db.data_migrations$remove_admin_group_from_mappings_by_setting_key_BANG_.invokeStatic(data_migrations.clj:202)
at metabase.db.data_migrations$remove_admin_group_from_mappings_by_setting_key_BANG_.invoke(data_migrations.clj:200)
at metabase.db.data_migrations$migrate_remove_admin_from_group_mapping_if_needed.invokeStatic(data_migrations.clj:228)
at metabase.db.data_migrations$migrate_remove_admin_from_group_mapping_if_needed.invoke(data_migrations.clj:215)
at metabase.db.data_migrations$run_migration_if_needed_BANG_$fn__112620$with_connection_STAR___112621$with_transaction_STAR___112622.invoke(data_migrations.clj:48)
at toucan2.connection$bind_current_connectable_fn$fn__27731.invoke(connection.clj:104)
at toucan2.connection$do_with_transaction_primary_method_java_sql_Connection$fn__27793.invoke(connection.clj:277)
at next.jdbc.transaction$transact_STAR_.invokeStatic(transaction.clj:72)
at next.jdbc.transaction$transact_STAR_.invoke(transaction.clj:51)
at next.jdbc.transaction$fn__27219.invokeStatic(transaction.clj:122)
at next.jdbc.transaction$fn__27219.invoke(transaction.clj:115)
at next.jdbc.protocols$fn__26379$G__26374__26388.invoke(protocols.clj:58)
at next.jdbc$transact.invokeStatic(jdbc.clj:381)
at next.jdbc$transact.invoke(jdbc.clj:373)
at toucan2.connection$do_with_transaction_primary_method_java_sql_Connection.invokeStatic(connection.clj:276)
at toucan2.connection$do_with_transaction_primary_method_java_sql_Connection.invoke(connection.clj:270)
at clojure.lang.AFn.applyToHelper(AFn.java:165)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:457)
at clojure.core$partial$fn__5908.invoke(core.clj:2643)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at methodical.impl.combo.threaded$fn__23390$fn__23391$fn__23394.invoke(threaded.clj:71)
at methodical.impl.combo.threaded$reducer_fn$fn__23360$fn__23364.invoke(threaded.clj:23)
at clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58)
at clojure.core.protocols$fn__8244.invokeStatic(protocols.clj:136)
at clojure.core.protocols$fn__8244.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6886)
at clojure.core$reduce.invoke(core.clj:6868)
at methodical.impl.combo.threaded$reducer_fn$fn__23360.invoke(threaded.clj:21)
at clojure.core$comp$fn__5876.invoke(core.clj:2588)
at methodical.impl.combo.threaded$combine_with_threader$fn__23370.invoke(threaded.clj:44)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at metabase.db.connection$do_with_transaction_around_method_java_sql_Connection.invokeStatic(connection.clj:145)
at metabase.db.connection$do_with_transaction_around_method_java_sql_Connection.invoke(connection.clj:141)
at clojure.lang.AFn.applyToHelper(AFn.java:165)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:457)
at clojure.core$partial$fn__5908.invoke(core.clj:2643)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at toucan2.connection$do_with_transaction_around_method_toucan2_connection_default.invokeStatic(connection.clj:268)
at toucan2.connection$do_with_transaction_around_method_toucan2_connection_default.invoke(connection.clj:264)
at clojure.lang.AFn.applyToHelper(AFn.java:165)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:457)
at clojure.core$partial$fn__5908.invoke(core.clj:2643)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:58)
at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47)
at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:195)
at metabase.db.data_migrations$run_migration_if_needed_BANG_$fn__112620$with_connection_STAR___112621.invoke(data_migrations.clj:47)
at toucan2.connection$bind_current_connectable_fn$fn__27731.invoke(connection.clj:104)
at toucan2.connection$bind_current_connectable_fn$fn__27731.invoke(connection.clj:104)
at toucan2.connection$bind_current_connectable_fn$fn__27731.invoke(connection.clj:104)
at toucan2.connection$do_with_connection_primary_method_javax_sql_DataSource.invokeStatic(connection.clj:213)
at toucan2.connection$do_with_connection_primary_method_javax_sql_DataSource.invoke(connection.clj:210)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at clojure.core$partial$fn__5908.invoke(core.clj:2642)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at methodical.impl.combo.threaded$fn__23390$fn__23391$fn__23392.invoke(threaded.clj:70)
at methodical.impl.combo.threaded$reducer_fn$fn__23360$fn__23364.invoke(threaded.clj:23)
at clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58)
at clojure.core.protocols$fn__8244.invokeStatic(protocols.clj:136)
at clojure.core.protocols$fn__8244.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6886)
at clojure.core$reduce.invoke(core.clj:6868)
at methodical.impl.combo.threaded$reducer_fn$fn__23360.invoke(threaded.clj:21)
at clojure.core$comp$fn__5876.invoke(core.clj:2587)
at methodical.impl.combo.threaded$combine_with_threader$fn__23370.invoke(threaded.clj:43)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invokeStatic(connection.clj:118)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invoke(connection.clj:106)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at clojure.core$partial$fn__5908.invoke(core.clj:2642)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:55)
at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47)
at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:193)
at metabase.db.connection$do_with_connection_primary_method_default.invokeStatic(connection.clj:139)
at metabase.db.connection$do_with_connection_primary_method_default.invoke(connection.clj:137)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at clojure.core$partial$fn__5908.invoke(core.clj:2642)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at methodical.impl.combo.threaded$fn__23390$fn__23391$fn__23392.invoke(threaded.clj:70)
at methodical.impl.combo.threaded$reducer_fn$fn__23360$fn__23364.invoke(threaded.clj:23)
at clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58)
at clojure.core.protocols$fn__8244.invokeStatic(protocols.clj:136)
at clojure.core.protocols$fn__8244.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6886)
at clojure.core$reduce.invoke(core.clj:6868)
at methodical.impl.combo.threaded$reducer_fn$fn__23360.invoke(threaded.clj:21)
at clojure.core$comp$fn__5876.invoke(core.clj:2587)
at methodical.impl.combo.threaded$combine_with_threader$fn__23370.invoke(threaded.clj:43)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invokeStatic(connection.clj:118)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invoke(connection.clj:106)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at clojure.core$partial$fn__5908.invoke(core.clj:2642)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:55)
at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47)
at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:193)
at toucan2.connection$do_with_connection_primary_method_.invokeStatic(connection.clj:204)
at toucan2.connection$do_with_connection_primary_method_.invoke(connection.clj:194)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at clojure.core$partial$fn__5908.invoke(core.clj:2642)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at methodical.impl.combo.threaded$fn__23390$fn__23391$fn__23392.invoke(threaded.clj:70)
at methodical.impl.combo.threaded$reducer_fn$fn__23360$fn__23364.invoke(threaded.clj:23)
at clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58)
at clojure.core.protocols$fn__8244.invokeStatic(protocols.clj:136)
at clojure.core.protocols$fn__8244.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
at clojure.core$reduce.invokeStatic(core.clj:6886)
at clojure.core$reduce.invoke(core.clj:6868)
at methodical.impl.combo.threaded$reducer_fn$fn__23360.invoke(threaded.clj:21)
at clojure.core$comp$fn__5876.invoke(core.clj:2587)
at methodical.impl.combo.threaded$combine_with_threader$fn__23370.invoke(threaded.clj:43)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invokeStatic(connection.clj:118)
at toucan2.connection$do_with_connection_around_method_toucan2_connection_default.invoke(connection.clj:106)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at clojure.core$partial$fn__5908.invoke(core.clj:2642)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.AFunction$1.doInvoke(AFunction.java:31)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:55)
at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47)
at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:193)
at metabase.db.data_migrations$run_migration_if_needed_BANG_$fn__112620.invoke(data_migrations.clj:47)
at metabase.db.data_migrations$run_migration_if_needed_BANG_.invokeStatic(data_migrations.clj:46)
at metabase.db.data_migrations$run_migration_if_needed_BANG_.invoke(data_migrations.clj:34)
at metabase.db.data_migrations$run_all_BANG_.invokeStatic(data_migrations.clj:72)
at metabase.db.data_migrations$run_all_BANG_.invoke(data_migrations.clj:66)
at clojure.lang.Var.invoke(Var.java:380)
at metabase.db.setup$fn__52129$run_data_migrations_BANG___52134$fn__52135.invoke(setup.clj:140)
at metabase.db.setup$fn__52129$run_data_migrations_BANG___52134.invoke(setup.clj:134)
at metabase.db.setup$fn__52155$setup_db_BANG___52160$fn__52161$fn__52164$fn__52165.invoke(setup.clj:157)
at metabase.util.jvm$do_with_us_locale.invokeStatic(jvm.clj:239)
at metabase.util.jvm$do_with_us_locale.invoke(jvm.clj:225)
at metabase.db.setup$fn__52155$setup_db_BANG___52160$fn__52161$fn__52164.invoke(setup.clj:152)
at metabase.db.setup$fn__52155$setup_db_BANG___52160$fn__52161.invoke(setup.clj:151)
at metabase.db.setup$fn__52155$setup_db_BANG___52160.invoke(setup.clj:145)
at metabase.db$setup_db_BANG_$fn__52188.invoke(db.clj:66)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:61)
at metabase.db$setup_db_BANG_.invoke(db.clj:52)
at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:113)
at metabase.core$init_BANG__STAR_.invoke(core.clj:99)
at metabase.core$init_BANG_.invokeStatic(core.clj:159)
at metabase.core$init_BANG_.invoke(core.clj:154)
at metabase.core$start_normally.invokeStatic(core.clj:171)
at metabase.core$start_normally.invoke(core.clj:165)
at metabase.core$_main.invokeStatic(core.clj:204)
at metabase.core$_main.doInvoke(core.clj:198)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.Var.applyTo(Var.java:705)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.bootstrap$_main.invokeStatic(bootstrap.clj:31)
at metabase.bootstrap$_main.doInvoke(bootstrap.clj:28)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.bootstrap.main(Unknown Source)
2023-08-29 12:57:13,386 INFO metabase.core :: Metabase Shutting Down ...
2023-08-29 12:57:13,387 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2023-08-29 12:57:13,392 INFO metabase.core :: Metabase Shutdown COMPLETE

thanks for your t.

AndrewMBaines · September 13, 2023, 3:51pm

Did the upgrade work with H2 before attempting the migration? You can't do both at the same time.
You're still using the Oracle JVM too.

Make sure that 0.47 works with your existing H2 database
Change to the Adoptium JVM
See if you can connect from Metabase to your MySQL database as a data source (just to test it can connect)
Run the migrate, but change the metabase.db bit to include the full path (I don't know if that is the problem, but worth a try)