Error running metabase.jar

I keep getting an error running metabase.jar. "Your database requires updates" I get the same error whether I try to run metabase load-from-h2 or just connect it to an empty mariadb database instance.

The instance is running in a docker container started with docker-compose.

Host Environment

MB_DB_AUTOMIGRATE='false'
MB_DB_DBNAME='metabase'
MB_DB_HOST='db'
MB_DB_PASS='***************'
MB_DB_PORT='3306'
MB_DB_TYPE='mysql'
MB_DB_USER='redimdc_redimd2'

Metabase command

java -jar metabase.jar load-from-h2 data/metabase.db

Warning: environ value linux for key :os-name has been overwritten with Linux
2020-11-15 02:53:08,352 INFO metabase.util :: Maximum memory available to JVM: 1.7 GB
2020-11-15 02:53:36,614 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. ?
For more information, see https: / /metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2020-11-15 02:53:49,268 INFO metabase.core ::
Metabase v0.37.1 (ba57ab6 release-x.37.x)

Copyright ? 2020 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2020-11-15 02:53:49,287 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2020-11-15 02:53:49,404 INFO metabase.db :: Verifying mysql Database Connection ...
2020-11-15 02:53:49,988 INFO driver.impl :: Registered abstract driver :sql ?
Load driver :sql took 230.7 ms
2020-11-15 02:53:50,024 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) ?
Load driver :sql-jdbc took 358.5 ms
2020-11-15 02:53:50,040 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) ?
Load driver :mysql took 642.8 ms
2020-11-15 02:53:50,070 INFO driver.impl :: Initializing driver :sql...
2020-11-15 02:53:50,072 INFO driver.impl :: Initializing driver :sql-jdbc...
2020-11-15 02:53:50,073 INFO driver.impl :: Initializing driver :mysql...
2020-11-15 02:53:50,278 INFO metabase.db :: Successfully verified MariaDB 10.5.7-MariaDB-1:10.5.7+maria~focal application database connection. ?
2020-11-15 02:53:50,281 INFO metabase.db :: Running Database Migrations...
2020-11-15 02:53:50,293 INFO metabase.db :: Setting up Liquibase...
2020-11-15 02:53:50,346 INFO metabase.db :: Liquibase is ready.
2020-11-15 02:53:53,955 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:53,956 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:53,957 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:53,959 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:53,960 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:53,961 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:53,961 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:53,963 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,059 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,060 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,061 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,062 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,063 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,063 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,065 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,066 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use and re-specify all configuration if this is the case
2020-11-15 02:53:54,592 INFO metabase.db :: Database Upgrade Required

NOTICE: Your database requires updates to work with this version of Metabase.
Please execute the following sql commands on your database before proceeding.

-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: liquibase.yaml
-- Ran at: 11/15/20 2:53 AM
-- Against: redimdc_redimd2@jdbc:mysql://db:3306/metabase
-- Liquibase version: 3.6.3
-- *********************************************************************

-- Lock Database
UPDATE metabase.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '25a681363288 (172.25.0.5)', LOCKGRANTED = '2020-11-15 02:53:53.976' WHERE ID = 1 AND LOCKED = 0;

-- Changeset migrations/000_migrations.yaml::1::agilliland
CREATE TABLE metabase.core_organization (id INT AUTO_INCREMENT NOT NULL, slug VARCHAR(254) NOT NULL, name VARCHAR(254) NOT NULL, description TEXT NULL, logo_url VARCHAR(254) NULL, inherits BIT(1) NOT NULL, CONSTRAINT PK_CORE_ORGANIZATION PRIMARY KEY (id), UNIQUE (slug)) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

{ rest omitted }

mariadb Information

mysql -h db -u redimdc_redimd2 -p metabase
Enter password:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 27
Server version: 10.5.7-MariaDB-1:10.5.7+maria~focal mariadb . org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [metabase]> select @@version;
+-------------------------------------+
| @@ version |
+-------------------------------------+
| 10.5.7-MariaDB-1:10.5.7+maria~focal |
+-------------------------------------+
1 row in set (0.001 sec)

MariaDB [metabase]> SHOW GLOBAL VARIABLES LIKE 'innodb_larg%';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_large_prefix | ON |
+---------------------+-------+
1 row in set (0.002 sec)

MariaDB [metabase]> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@ character_set_database | @@ collation_database |
+--------------------------+----------------------+
| utf8mb4 | utf8mb4_unicode_ci |
+--------------------------+----------------------+
1 row in set (0.000 sec)

java -version

openjdk version "1.8.0_275"
OpenJDK Runtime Environment (build 1.8.0_275-b01)
OpenJDK 64-Bit Server VM (build 25.275-b01, mixed mode)

Additional info:

I was incorrect in my original post. I get fatal errors but not the "SAME" errors when initializing or load-from-h2.

I dropped all the tables before I ran this. I have tried with export MB_DB_AUTOMIGRATE='true' and with it set to false. Same results.

Results from just the java -jar metabase.jar command with an empty database "metabase".

# java -jar metabase.jar                                        

Warning: environ value linux for key :os-name has been overwritten with Linux
2020-11-15 03:38:09,584 INFO metabase.util :: Maximum memory available to JVM: 1.7 GB
2020-11-15 03:38:24,126 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. ?
For more information, see https:/ /metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2020-11-15 03:38:31,340 INFO metabase.core ::
Metabase v0.37.1 (ba57ab6 release-x.37.x)

Copyright ? 2020 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2020-11-15 03:38:31,352 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2020-11-15 03:38:31,356 INFO metabase.core :: Starting Metabase in STANDALONE mode
2020-11-15 03:38:31,413 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000}

2020-11-15 03:38:31,459 INFO metabase.core :: Starting Metabase version v0.37.1 (ba57ab6 release-x.37.x) ...
2020-11-15 03:38:31,514 INFO metabase.core :: System info:
{"file.encoding" "ANSI_X3.4-1968",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "1.8.0_275-b01",
"java.vendor" "BellSoft",
"java.vendor.url" "https://bell-sw.com/",
"java.version" "1.8.0_275",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "25.275-b01",
"os.name" "Linux",
"os.version" "5.4.39-linuxkit",
"user.language" "en",
"user.timezone" "Etc/UTC"}

2020-11-15 03:38:31,529 INFO metabase.plugins :: Loading plugins in /bitnami/metabase/plugins...
2020-11-15 03:38:31,670 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /bitnami/metabase/plugins/snowflake.metabase-driver.jar
2020-11-15 03:38:35,566 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /bitnami/metabase/plugins/googleanalytics.metabase-driver.jar
2020-11-15 03:38:35,672 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /bitnami/metabase/plugins/druid.metabase-driver.jar
2020-11-15 03:38:35,749 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /bitnami/metabase/plugins/redshift.metabase-driver.jar
2020-11-15 03:38:36,027 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /bitnami/metabase/plugins/sparksql.metabase-driver.jar
2020-11-15 03:38:43,485 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /bitnami/metabase/plugins/sqlite.metabase-driver.jar
2020-11-15 03:38:44,069 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /bitnami/metabase/plugins/sqlserver.metabase-driver.jar
2020-11-15 03:38:44,219 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /bitnami/metabase/plugins/oracle.metabase-driver.jar
2020-11-15 03:38:44,234 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /bitnami/metabase/plugins/vertica.metabase-driver.jar
2020-11-15 03:38:44,244 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /bitnami/metabase/plugins/bigquery.metabase-driver.jar
2020-11-15 03:38:44,326 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /bitnami/metabase/plugins/presto.metabase-driver.jar
2020-11-15 03:38:44,352 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /bitnami/metabase/plugins/mongo.metabase-driver.jar
2020-11-15 03:38:44,929 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /bitnami/metabase/plugins/google.metabase-driver.jar
2020-11-15 03:38:45,458 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2020-11-15 03:38:45,461 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2020-11-15 03:38:45,481 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase BigQuery Driver"]
2020-11-15 03:38:45,506 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2020-11-15 03:38:45,509 INFO driver.impl :: Registered driver :druid ?
2020-11-15 03:38:45,524 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2020-11-15 03:38:45,526 INFO driver.impl :: Registered abstract driver :google ?
2020-11-15 03:38:45,528 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-11-15 03:38:45,530 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver"]
2020-11-15 03:38:45,534 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2020-11-15 03:38:45,535 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2020-11-15 03:38:45,685 INFO driver.impl :: Registered abstract driver :sql ?
Load driver :sql took 154.2 ms
2020-11-15 03:38:45,693 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google]) ?
2020-11-15 03:38:45,714 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2020-11-15 03:38:45,716 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-11-15 03:38:45,717 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2020-11-15 03:38:45,719 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) ?
2020-11-15 03:38:45,754 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2020-11-15 03:38:45,762 INFO driver.impl :: Registered driver :mongo ?
2020-11-15 03:38:45,782 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 https:/ /metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

2020-11-15 03:38:45,784 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2020-11-15 03:38:45,785 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2020-11-15 03:38:45,794 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2020-11-15 03:38:45,799 INFO driver.impl :: Registered driver :presto (parents: [:sql]) ?
2020-11-15 03:38:45,815 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2020-11-15 03:38:45,911 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) ?
Load driver :sql-jdbc took 10.9 ms
2020-11-15 03:38:45,919 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) ?
Load driver :postgres took 116.3 ms
2020-11-15 03:38:45,935 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) ?
2020-11-15 03:38:45,970 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2020-11-15 03:38:45,972 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) ?
2020-11-15 03:38:46,019 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2020-11-15 03:38:46,022 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) ?
2020-11-15 03:38:46,024 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2020-11-15 03:38:46,026 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) ?
2020-11-15 03:38:46,034 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2020-11-15 03:38:46,037 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) ?
2020-11-15 03:38:46,052 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2020-11-15 03:38:46,058 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) ?
2020-11-15 03:38:46,071 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.

2020-11-15 03:38:46,074 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2020-11-15 03:38:46,076 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]
2020-11-15 03:38:46,087 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) ?
2020-11-15 03:38:46,109 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) ?
2020-11-15 03:38:46,129 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2020-11-15 03:38:46,135 INFO metabase.db :: Verifying mysql Database Connection ...
2020-11-15 03:38:46,141 INFO driver.impl :: Initializing driver :sql...
2020-11-15 03:38:46,142 INFO driver.impl :: Initializing driver :sql-jdbc...
2020-11-15 03:38:46,143 INFO driver.impl :: Initializing driver :mysql...
2020-11-15 03:38:46,246 INFO metabase.db :: Successfully verified MariaDB 10.5.7-MariaDB-1:10.5.7+maria~focal application database connection. ?
2020-11-15 03:38:46,248 INFO metabase.db :: Running Database Migrations...
2020-11-15 03:38:46,254 INFO metabase.db :: Setting up Liquibase...
2020-11-15 03:38:46,277 INFO metabase.db :: Liquibase is ready.
2020-11-15 03:38:48,341 ERROR metabase.core :: Metabase Initialization FAILED
liquibase.exception.DatabaseException: (conn=48) Table 'databasechangelog' already exists [Failed SQL: CREATE TABLE metabase.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:109) ~[metabase.jar:?]
at liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:280) ~[metabase.jar:?]
at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1219) ~[metabase.jar:?]
at liquibase.Liquibase.listLocks(Liquibase.java:1240) ~[metabase.jar:?]
at metabase.db.liquibase$migration_lock_exists_QMARK_.invokeStatic(liquibase.clj:97) ~[metabase.jar:?]
at metabase.db.liquibase$migration_lock_exists_QMARK_.invoke(liquibase.clj:94) ~[metabase.jar:?]
at metabase.db.liquibase$release_lock_if_needed_BANG_.invokeStatic(liquibase.clj:187) ~[metabase.jar:?]
at metabase.db.liquibase$release_lock_if_needed_BANG_.invoke(liquibase.clj:183) ~[metabase.jar:?]
at metabase.db$migrate_BANG_$fn__21746$fn__21747.invoke(db.clj:231) ~[metabase.jar:?]
at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:37) ~[metabase.jar:?]
at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:29) ~[metabase.jar:?]
at metabase.db$migrate_BANG_$fn__21746.invoke(db.clj:203) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:852) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]
at metabase.db$migrate_BANG_.invokeStatic(db.clj:194) ~[metabase.jar:?]
at metabase.db$migrate_BANG_.invoke(db.clj:173) ~[metabase.jar:?]
at metabase.db$run_schema_migrations_BANG_.invokeStatic(db.clj:336) ~[metabase.jar:?]
at metabase.db$run_schema_migrations_BANG_.invoke(db.clj:330) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_$fn__21829.invoke(db.clj:353) ~[metabase.jar:?]
at metabase.util$do_with_us_locale.invokeStatic(util.clj:670) ~[metabase.jar:?]
at metabase.util$do_with_us_locale.invoke(util.clj:656) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invokeStatic(db.clj:351) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invoke(db.clj:346) ~[metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invokeStatic(db.clj:365) ~[metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invoke(db.clj:358) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_$fn__21834.invoke(db.clj:375) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:373) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_.invoke(db.clj:368) ~[metabase.jar:?]
at metabase.core$init_BANG_.invokeStatic(core.clj:96) ~[metabase.jar:?]
at metabase.core$init_BANG_.invoke(core.clj:75) ~[metabase.jar:?]
at metabase.core$start_normally.invokeStatic(core.clj:140) [metabase.jar:?]
at metabase.core$start_normally.invoke(core.clj:134) [metabase.jar:?]
at metabase.core$_main.invokeStatic(core.clj:173) [metabase.jar:?]
at metabase.core$_main.doInvoke(core.clj:167) [metabase.jar:?]
at clojure.lang.RestFn.invoke(RestFn.java:397) [metabase.jar:?]
at clojure.lang.AFn.applyToHelper(AFn.java:152) [metabase.jar:?]
at clojure.lang.RestFn.applyTo(RestFn.java:132) [metabase.jar:?]
at metabase.core.main(Unknown Source) [metabase.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=48) Table 'databasechangelog' already exists
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]
... 44 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Table 'databasechangelog' already exists
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]
... 44 more
Caused by: java.sql.SQLException: Table 'databasechangelog' already exists
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1688) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1550) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1513) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]
... 44 more
2020-11-15 03:38:48,381 INFO metabase.core :: Metabase Shutting Down ...
2020-11-15 03:38:48,382 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2020-11-15 03:38:48,396 INFO metabase.core :: Metabase Shutdown COMPLETE

Hi @av84fun
Are you sure the database is empty? This error comes from MySQL:
Table 'databasechangelog' already exists
Unless the MySQL user doesn’t have alter privileges, then you should just allow Metabase to be able to control it’s own database (hence do not define MB_DB_AUTOMIGRATE).

It’s not the database user. Below I show creating a temp user and empty tables before the run. I checked all the other databases on the instance and all other local db instances. The databasechange.log doesn’t exist.

I suspect there is a different issue and the error message is incorrect or there is a conflict with another app on this image. This image is the reporting server that hosts Jasperserver, a tomcat, app, as well. Jasperserver

Logon and create user

mysql -h db -u redimdc_redimd2 -p metabase

Enter password:
MariaDB [metabase]> CREATE USER ‘metabase’@’%’ IDENTIFIED BY ‘metabase’;
Query OK, 0 rows affected (0.002 sec)

MariaDB [metabase]> GRANT ALL PRIVILEGES ON * . * TO ‘metabase’@’%’;
Query OK, 0 rows affected (0.002 sec)

MariaDB [metabase]> exit
Bye

Logon as new user and show tables

mysql -h db -u metabase -pmetabase metabase

MariaDB [metabase]> show tables;
Empty set (0.001 sec)

MariaDB [metabase]> exit
Bye
cd /app/metabase

Environment variables

set

ALLOW_EMPTY_PASSWORD=‘yes’
BITNAMI_APP_NAME=‘jasperreports’
BITNAMI_IMAGE_VERSION=‘7.8.0-debian-10-r68’
HOME=’/root’
HOSTNAME=‘f6d1db3742d7’
IFS=’

JASPERREPORTS_DATABASE_NAME=‘jasperserver’
JASPERREPORTS_DATABASE_PASSWORD=’***************’
JASPERREPORTS_DATABASE_USER=‘redimdc_redimd2’
JASPERREPORTS_EMAIL=‘user@example.com’
JASPERREPORTS_PASSWORD=‘bitnami’
JASPERREPORTS_USERNAME=‘user’
MARIADB_HOST=‘db’
MARIADB_PORT_NUMBER=‘3306’
MARIADB_ROOT_PASSWORD=’’
MARIADB_ROOT_USER=‘root’
MB_DB_DBNAME=‘metabase’
MB_DB_HOST=‘db’
MB_DB_PASS=‘metabase’
MB_DB_PORT=‘3306’
MB_DB_TYPE=‘mysql’
MB_DB_USER=‘metabase’
MYSQL_CLIENT_CREATE_DATABASE_NAME=’’
MYSQL_CLIENT_CREATE_DATABASE_PASSWORD=’’
MYSQL_CLIENT_CREATE_DATABASE_PRIVILEGES=‘ALL’
MYSQL_CLIENT_CREATE_DATABASE_USER=’’
MYSQL_CLIENT_ENABLE_SSL=‘no’
MYSQL_CLIENT_SSL_CA_FILE=’’
OLDPWD=’/’
OPTIND=‘1’
OS_ARCH=‘amd64’
OS_FLAVOUR=‘debian-10’
OS_NAME=‘linux’
PATH=’/opt/bitnami/java/bin:/opt/bitnami/tomcat/bin:/opt/bitnami/mysql/bin:/opt/bitnami/git/bin:/opt/bitnami/common/bin:/opt/bitnami/nami/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin’
PPID=‘0’
PS1=’# ’
PS2=’> ’
PS4=’+ ’
PWD=’/app/metabase’
SMTP_EMAIL=’’
SMTP_HOST=’’
SMTP_PASSWORD=’’
SMTP_PORT=’’
SMTP_PROTOCOL=’’
SMTP_USER=’’
TERM=‘xterm’
='MB

Load From H2

java -jar metabase.jar load-from-h2 /metabase/data/metabase.db

Warning: environ value linux for key :os-name has been overwritten with Linux
2020-11-15 17:36:45,614 INFO metabase.util :: Maximum memory available to JVM: 1.7 GB
2020-11-15 17:37:00,021 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. ?
For more information, see https:/ /metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2020-11-15 17:37:07,294 INFO metabase.core ::
Metabase v0.37.1 (ba57ab6 release-x.37.x)

Copyright ? 2020 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2020-11-15 17:37:07,307 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2020-11-15 17:37:07,358 INFO metabase.db :: Verifying mysql Database Connection …
2020-11-15 17:37:07,579 INFO driver.impl :: Registered abstract driver :sql ?
Load driver :sql took 119.8 ms
2020-11-15 17:37:07,600 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) ?
Load driver :sql-jdbc took 143.9 ms
2020-11-15 17:37:07,606 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) ?
Load driver :mysql took 264.0 ms
2020-11-15 17:37:07,627 INFO driver.impl :: Initializing driver :sql…
2020-11-15 17:37:07,628 INFO driver.impl :: Initializing driver :sql-jdbc…
2020-11-15 17:37:07,629 INFO driver.impl :: Initializing driver :mysql…
2020-11-15 17:37:07,726 INFO metabase.db :: Successfully verified MariaDB 10.5.7-MariaDB-1:10.5.7+maria~focal application database connection. ?
2020-11-15 17:37:07,727 INFO metabase.db :: Running Database Migrations…
2020-11-15 17:37:07,737 INFO metabase.db :: Setting up Liquibase…
2020-11-15 17:37:07,760 INFO metabase.db :: Liquibase is ready.
2020-11-15 17:37:07,762 INFO db.liquibase :: Checking if Database has unrun migrations…
liquibase.exception.DatabaseException: (conn=56) Table ‘databasechangelog’ already exists [Failed SQL: CREATE TABLE metabase.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

Command failed with exception: (conn=56) Table ‘databasechangelog’ already exists [Failed SQL: CREATE TABLE metabase.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

No export just initialize new

java -jar metabase.jar

Warning: environ value linux for key :os-name has been overwritten with Linux
2020-11-15 17:42:55,689 INFO metabase.util :: Maximum memory available to JVM: 1.7 GB
2020-11-15 17:43:10,024 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. ?
For more information, see https:/ /metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2020-11-15 17:43:17,388 INFO metabase.core ::
Metabase v0.37.1 (ba57ab6 release-x.37.x)

Copyright ? 2020 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2020-11-15 17:43:17,406 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2020-11-15 17:43:17,408 INFO metabase.core :: Starting Metabase in STANDALONE mode
2020-11-15 17:43:17,471 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000}

2020-11-15 17:43:17,529 INFO metabase.core :: Starting Metabase version v0.37.1 (ba57ab6 release-x.37.x) …
2020-11-15 17:43:17,608 INFO metabase.core :: System info:
{“file.encoding” “ANSI_X3.4-1968”,
“java.runtime.name” “OpenJDK Runtime Environment”,
“java.runtime.version” “1.8.0_275-b01”,
“java.vendor” “BellSoft”,
“java.vendor.url” “https:/ /bell-sw.com/”,
“java.version” “1.8.0_275”,
“java.vm.name” “OpenJDK 64-Bit Server VM”,
“java.vm.version” “25.275-b01”,
“os.name” “Linux”,
“os.version” “5.4.39-linuxkit”,
“user.language” “en”,
“user.timezone” “Etc/UTC”}

2020-11-15 17:43:17,623 INFO metabase.plugins :: Loading plugins in /app/metabase/plugins…
2020-11-15 17:43:17,737 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /app/metabase/plugins/snowflake.metabase-driver.jar
2020-11-15 17:43:18,051 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /app/metabase/plugins/googleanalytics.metabase-driver.jar
2020-11-15 17:43:18,062 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /app/metabase/plugins/druid.metabase-driver.jar
2020-11-15 17:43:18,069 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /app/metabase/plugins/redshift.metabase-driver.jar
2020-11-15 17:43:18,098 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /app/metabase/plugins/sparksql.metabase-driver.jar
2020-11-15 17:43:18,676 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /app/metabase/plugins/sqlite.metabase-driver.jar
2020-11-15 17:43:18,707 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /app/metabase/plugins/sqlserver.metabase-driver.jar
2020-11-15 17:43:18,719 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /app/metabase/plugins/oracle.metabase-driver.jar
2020-11-15 17:43:18,722 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /app/metabase/plugins/vertica.metabase-driver.jar
2020-11-15 17:43:18,724 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /app/metabase/plugins/bigquery.metabase-driver.jar
2020-11-15 17:43:18,731 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /app/metabase/plugins/presto.metabase-driver.jar
2020-11-15 17:43:18,734 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /app/metabase/plugins/mongo.metabase-driver.jar
2020-11-15 17:43:18,784 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /app/metabase/plugins/google.metabase-driver.jar
2020-11-15 17:43:18,955 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 https:/ /metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

2020-11-15 17:43:18,957 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2020-11-15 17:43:18,972 INFO plugins.dependencies :: Plugins with unsatisfied deps: [“Metabase Oracle Driver”]
2020-11-15 17:43:18,982 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto…
2020-11-15 17:43:19,132 INFO driver.impl :: Registered abstract driver :sql ?
Load driver :sql took 153.1 ms
2020-11-15 17:43:19,139 INFO driver.impl :: Registered driver :presto (parents: [:sql]) ?
2020-11-15 17:43:19,151 INFO plugins.dependencies :: Plugin ‘Metabase Google Analytics Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
2020-11-15 17:43:19,152 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2020-11-15 17:43:19,153 INFO plugins.dependencies :: Plugins with unsatisfied deps: [“Metabase Google Analytics Driver” “Metabase Oracle Driver”]
2020-11-15 17:43:19,159 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 https:/ /metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.

2020-11-15 17:43:19,160 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2020-11-15 17:43:19,161 INFO plugins.dependencies :: Plugins with unsatisfied deps: [“Metabase Google Analytics Driver” “Metabase Oracle Driver” “Metabase Vertica Driver”]
2020-11-15 17:43:19,168 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift…
2020-11-15 17:43:19,323 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) ?
Load driver :sql-jdbc took 10.4 ms
2020-11-15 17:43:19,330 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) ?
Load driver :postgres took 175.4 ms
2020-11-15 17:43:19,346 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) ?
2020-11-15 17:43:19,352 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid…
2020-11-15 17:43:19,353 INFO driver.impl :: Registered driver :druid ?
2020-11-15 17:43:19,361 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite…
2020-11-15 17:43:19,364 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) ?
2020-11-15 17:43:19,375 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo…
2020-11-15 17:43:19,376 INFO driver.impl :: Registered driver :mongo ?
2020-11-15 17:43:19,381 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google…
2020-11-15 17:43:19,382 INFO driver.impl :: Registered abstract driver :google ?
2020-11-15 17:43:19,384 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-11-15 17:43:19,386 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: [“Metabase Google Analytics Driver”]
2020-11-15 17:43:19,387 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics…
2020-11-15 17:43:19,389 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) ?
2020-11-15 17:43:19,414 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake…
2020-11-15 17:43:19,416 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) ?
2020-11-15 17:43:19,421 INFO plugins.dependencies :: Plugin ‘Metabase BigQuery Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
2020-11-15 17:43:19,423 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-11-15 17:43:19,424 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2020-11-15 17:43:19,425 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery…
2020-11-15 17:43:19,427 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google]) ?
2020-11-15 17:43:19,450 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like…
2020-11-15 17:43:19,452 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) ?
2020-11-15 17:43:19,453 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql…
2020-11-15 17:43:19,454 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) ?
2020-11-15 17:43:19,460 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver…
2020-11-15 17:43:19,462 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) ?
2020-11-15 17:43:19,471 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) ?
2020-11-15 17:43:19,494 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) ?
2020-11-15 17:43:19,512 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute…
2020-11-15 17:43:19,516 INFO metabase.db :: Verifying mysql Database Connection …
2020-11-15 17:43:19,519 INFO driver.impl :: Initializing driver :sql…
2020-11-15 17:43:19,521 INFO driver.impl :: Initializing driver :sql-jdbc…
2020-11-15 17:43:19,522 INFO driver.impl :: Initializing driver :mysql…
2020-11-15 17:43:19,615 INFO metabase.db :: Successfully verified MariaDB 10.5.7-MariaDB-1:10.5.7+maria~focal application database connection. ?
2020-11-15 17:43:19,617 INFO metabase.db :: Running Database Migrations…
2020-11-15 17:43:19,622 INFO metabase.db :: Setting up Liquibase…
2020-11-15 17:43:19,647 INFO metabase.db :: Liquibase is ready.
2020-11-15 17:43:19,648 INFO db.liquibase :: Checking if Database has unrun migrations…
2020-11-15 17:43:21,532 ERROR metabase.core :: Metabase Initialization FAILED
liquibase.exception.DatabaseException: (conn=61) Table ‘databasechangelog’ already exists [Failed SQL: CREATE TABLE metabase.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:109) ~[metabase.jar:?]
at liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:280) ~[metabase.jar:?]
at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1219) ~[metabase.jar:?]
at liquibase.Liquibase.listLocks(Liquibase.java:1240) ~[metabase.jar:?]
at metabase.db.liquibase$migration_lock_exists_QMARK_.invokeStatic(liquibase.clj:97) ~[metabase.jar:?]
at metabase.db.liquibase$migration_lock_exists_QMARK_.invoke(liquibase.clj:94) ~[metabase.jar:?]
at metabase.db.liquibase$release_lock_if_needed_BANG_.invokeStatic(liquibase.clj:187) ~[metabase.jar:?]
at metabase.db.liquibase$release_lock_if_needed_BANG_.invoke(liquibase.clj:183) ~[metabase.jar:?]
at metabase.db$migrate_BANG_$fn__21746$fn__21747.invoke(db.clj:231) ~[metabase.jar:?]
at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:37) ~[metabase.jar:?]
at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:29) ~[metabase.jar:?]
at metabase.db$migrate_BANG_$fn__21746.invoke(db.clj:203) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:852) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789) ~[metabase.jar:?]
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]
at metabase.db$migrate_BANG_.invokeStatic(db.clj:194) ~[metabase.jar:?]
at metabase.db$migrate_BANG_.invoke(db.clj:173) ~[metabase.jar:?]
at metabase.db$run_schema_migrations_BANG_.invokeStatic(db.clj:336) ~[metabase.jar:?]
at metabase.db$run_schema_migrations_BANG_.invoke(db.clj:330) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_$fn__21829.invoke(db.clj:353) ~[metabase.jar:?]
at metabase.util$do_with_us_locale.invokeStatic(util.clj:670) ~[metabase.jar:?]
at metabase.util$do_with_us_locale.invoke(util.clj:656) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invokeStatic(db.clj:351) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invoke(db.clj:346) ~[metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invokeStatic(db.clj:365) ~[metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invoke(db.clj:358) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_$fn__21834.invoke(db.clj:375) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:373) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_.invoke(db.clj:368) ~[metabase.jar:?]
at metabase.core$init_BANG_.invokeStatic(core.clj:96) ~[metabase.jar:?]
at metabase.core$init_BANG_.invoke(core.clj:75) ~[metabase.jar:?]
at metabase.core$start_normally.invokeStatic(core.clj:140) [metabase.jar:?]
at metabase.core$start_normally.invoke(core.clj:134) [metabase.jar:?]
at metabase.core$_main.invokeStatic(core.clj:173) [metabase.jar:?]
at metabase.core$_main.doInvoke(core.clj:167) [metabase.jar:?]
at clojure.lang.RestFn.invoke(RestFn.java:397) [metabase.jar:?]
at clojure.lang.AFn.applyToHelper(AFn.java:152) [metabase.jar:?]
at clojure.lang.RestFn.applyTo(RestFn.java:132) [metabase.jar:?]
at metabase.core.main(Unknown Source) [metabase.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=61) Table ‘databasechangelog’ already exists
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]
… 44 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Table ‘databasechangelog’ already exists
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]
… 44 more
Caused by: java.sql.SQLException: Table ‘databasechangelog’ already exists
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1688) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1550) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1513) ~[metabase.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[metabase.jar:?]
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]
… 44 more
2020-11-15 17:43:21,564 INFO metabase.core :: Metabase Shutting Down …
2020-11-15 17:43:21,566 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2020-11-15 17:43:21,580 INFO metabase.core :: Metabase Shutdown COMPLETE

@av84fun Okay, then try using a MySQL server that isn’t part of the rest of your applications. Without knowing your exact setup or configuration, it’s difficult to know where the problem is, so it’s much easier if you try running Metabase with a separate MySQL to confirm that everything is working and then start working that into your docker-compose to figure out where the problem occurs.

@flamber Thanks for looking into this for me. I setup a pristine MariaDB container and a pristine metabase/metabase container.

Error:

ERROR changelog.ChangeSet :: Change Set migrations/000_migrations.yaml::89::camsaul failed. Error: (conn=6) Can’t create table metabase.qrtz_simple_triggers (errno: 150 “Foreign key constraint is incorrectly formed”) [Failed SQL: ALTER TABLE metabase.QRTZ_SIMPLE_TRIGGERS ADD CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_TRIGGERS FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES metabase.QRTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)]

Structure:

    .
    ├── docker-compose.yml
    ├── mariadb
    │   ├── aria_log.00000001
    │   ├── aria_log_control
    │   ├── ib_buffer_pool
    │   ├── ib_logfile0
    │   ├── ibdata1
    │   ├── ibtmp1
    │   ├── metabase
    │   ├── multi-master.info
    │   ├── mysql
    │   └── performance_schema
    ├── metabase.db.mv.db
    └── metabase.jar 

docker-compose.yml

# Use root/example as user/password credentials
version: '3.1'

services:
    db:
        image: mariadb
        container_name: mariadb
        restart: always
        ports:
            - "3306:3306" 
        volumes: 
            - ./mariadb:/var/lib/mysql
        environment:
            ALLOW_EMPTY_PASSWORD: "yes"
            MYSQL_ROOT_PASSWORD: metabase
            MYSQL_USER: metabase
    
    metabase:
        image: 'metabase/metabase'
        container_name: metabaseonly
        #command: bash -c 'cd /app/metabase && java -jar metabase.jar'
        environment:
            - MB_DB_TYPE=mysql
            - MB_DB_DBNAME=metabase
            - MB_DB_PORT=3306
            - MB_DB_USER=root
            - MB_DB_PASS=metabase
            - MB_DB_HOST=db
        ports:
            - '8080:3000'
        volumes:
            - './:/app/metabase'
        depends_on: 
            - db
    

container log

Warning: environ value jdk-11.0.7+10 for key :java-version has been overwritten with 11.0.7

WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.

2020-11-15 22:12:45,655 INFO metabase.util :: Maximum memory available to JVM: 1.9 GB

2020-11-15 22:13:00,355 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. 🔓

For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html

2020-11-15 22:13:09,400 INFO metabase.core ::

Metabase v0.37.0.2 (ba7be09 release-x.37.x)


Copyright © 2020 Metabase, Inc.


Metabase Enterprise Edition extensions are NOT PRESENT.

2020-11-15 22:13:09,413 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.

2020-11-15 22:13:09,415 INFO metabase.core :: Starting Metabase in STANDALONE mode

2020-11-15 22:13:09,525 INFO metabase.server :: Launching Embedded Jetty Webserver with config:

{:port 3000, :host "0.0.0.0"}


2020-11-15 22:13:09,599 INFO metabase.core :: Starting Metabase version v0.37.0.2 (ba7be09 release-x.37.x) ...

2020-11-15 22:13:09,678 INFO metabase.core :: System info:

{"file.encoding" "UTF-8",

"java.runtime.name" "OpenJDK Runtime Environment",

"java.runtime.version" "11.0.7+10",

"java.vendor" "AdoptOpenJDK",

"java.vendor.url" "https://adoptopenjdk.net/",

"java.version" "11.0.7",

"java.vm.name" "OpenJDK 64-Bit Server VM",

"java.vm.version" "11.0.7+10",

"os.name" "Linux",

"os.version" "5.4.39-linuxkit",

"user.language" "en",

"user.timezone" "GMT"}


2020-11-15 22:13:09,679 INFO metabase.plugins :: Loading plugins in /plugins...

2020-11-15 22:13:09,861 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar

2020-11-15 22:13:10,218 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar

2020-11-15 22:13:10,229 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar

2020-11-15 22:13:10,236 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar

2020-11-15 22:13:10,266 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar

2020-11-15 22:13:10,928 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar

2020-11-15 22:13:10,967 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar

2020-11-15 22:13:10,982 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar

2020-11-15 22:13:10,985 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar

2020-11-15 22:13:10,987 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar

2020-11-15 22:13:10,995 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar

2020-11-15 22:13:11,000 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar

2020-11-15 22:13:11,046 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar

2020-11-15 22:13:11,267 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 https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.


2020-11-15 22:13:11,273 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false

2020-11-15 22:13:11,292 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]

2020-11-15 22:13:11,304 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...

2020-11-15 22:13:11,470 INFO driver.impl :: Registered abstract driver :sql 🚚

Load driver :sql took 169.6 ms

2020-11-15 22:13:11,476 INFO driver.impl :: Registered driver :presto (parents: [:sql]) 🚚

2020-11-15 22:13:11,495 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'

2020-11-15 22:13:11,497 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false

2020-11-15 22:13:11,498 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Google Analytics Driver"]

2020-11-15 22:13:11,513 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 https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.


2020-11-15 22:13:11,514 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false

2020-11-15 22:13:11,516 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver" "Metabase Google Analytics Driver"]

2020-11-15 22:13:11,535 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...

2020-11-15 22:13:11,626 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) 🚚

Load driver :sql-jdbc took 10.2 ms

2020-11-15 22:13:11,632 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) 🚚

Load driver :postgres took 110.7 ms

2020-11-15 22:13:11,649 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) 🚚

2020-11-15 22:13:11,662 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...

2020-11-15 22:13:11,665 INFO driver.impl :: Registered driver :druid 🚚

2020-11-15 22:13:11,680 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...

2020-11-15 22:13:11,681 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚

2020-11-15 22:13:11,700 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...

2020-11-15 22:13:11,703 INFO driver.impl :: Registered driver :mongo 🚚

2020-11-15 22:13:11,708 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...

2020-11-15 22:13:11,709 INFO driver.impl :: Registered abstract driver :google 🚚

2020-11-15 22:13:11,711 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true

2020-11-15 22:13:11,712 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase Google Analytics Driver"]

2020-11-15 22:13:11,714 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...

2020-11-15 22:13:11,715 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) 🚚

2020-11-15 22:13:11,742 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...

2020-11-15 22:13:11,744 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) 🚚

2020-11-15 22:13:11,755 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'

2020-11-15 22:13:11,757 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true

2020-11-15 22:13:11,760 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties

2020-11-15 22:13:11,761 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...

2020-11-15 22:13:11,765 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google]) 🚚

2020-11-15 22:13:11,798 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...

2020-11-15 22:13:11,799 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚

2020-11-15 22:13:11,800 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...

2020-11-15 22:13:11,801 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) 🚚

2020-11-15 22:13:11,806 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...

2020-11-15 22:13:11,809 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚

2020-11-15 22:13:11,817 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) 🚚

2020-11-15 22:13:11,840 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) 🚚

2020-11-15 22:13:11,859 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...

2020-11-15 22:13:11,862 INFO metabase.db :: Verifying mysql Database Connection ...

2020-11-15 22:13:11,870 INFO driver.impl :: Initializing driver :sql...

2020-11-15 22:13:11,871 INFO driver.impl :: Initializing driver :sql-jdbc...

2020-11-15 22:13:11,872 INFO driver.impl :: Initializing driver :mysql...

2020-11-15 22:13:12,033 INFO metabase.db :: Successfully verified MariaDB 10.5.7-MariaDB-1:10.5.7+maria~focal application database connection. ✅

2020-11-15 22:13:12,036 INFO metabase.db :: Running Database Migrations...

2020-11-15 22:13:12,044 INFO metabase.db :: Setting up Liquibase...

2020-11-15 22:13:12,071 INFO metabase.db :: Liquibase is ready.

2020-11-15 22:13:12,072 INFO db.liquibase :: Checking if Database has unrun migrations...

2020-11-15 22:13:15,191 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

[Repeats 23 times]

2020-11-15 22:13:15,206 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...

2020-11-15 22:13:15,365 INFO db.liquibase :: Migration lock is cleared. Running migrations...


2020-11-15 22:13:22,929 ERROR changelog.ChangeSet :: Change Set migrations/000_migrations.yaml::89::camsaul failed. Error: (conn=6) Can't create table `metabase`.`qrtz_simple_triggers` (errno: 150 "Foreign key constraint is incorrectly formed") [Failed SQL: ALTER TABLE metabase.QRTZ_SIMPLE_TRIGGERS ADD CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_TRIGGERS FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES metabase.QRTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)]

2020-11-15 22:13:22,938 WARN metabase.util :: auto-retry metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__20970@1b70a1e3: Migration failed for change set migrations/000_migrations.yaml::89::camsaul:

Reason: liquibase.exception.DatabaseException: (conn=6) Can't create table `metabase`.`qrtz_simple_triggers` (errno: 150 "Foreign key constraint is incorrectly formed") [Failed SQL: ALTER TABLE metabase.QRTZ_SIMPLE_TRIGGERS ADD CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_TRIGGERS FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES metabase.QRTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)]

2020-11-15 22:13:23,060 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,062 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,063 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,064 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,065 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,066 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,077 ERROR changelog.ChangeSet :: Change Set migrations/000_migrations.yaml::89::camsaul failed. Error: (conn=6) Table 'qrtz_job_details' already exists [Failed SQL: CREATE TABLE metabase.QRTZ_JOB_DETAILS (SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, `DESCRIPTION` VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BIT(1) NOT NULL, IS_NONCONCURRENT BIT(1) NOT NULL, IS_UPDATE_DATA BIT(1) NOT NULL, REQUESTS_RECOVERY BIT(1) NOT NULL, JOB_DATA BLOB NULL) COMMENT='Used for Quartz scheduler.' ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

2020-11-15 22:13:23,081 WARN metabase.util :: auto-retry metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__20970@1b70a1e3: Migration failed for change set migrations/000_migrations.yaml::89::camsaul:

Reason: liquibase.exception.DatabaseException: (conn=6) Table 'qrtz_job_details' already exists [Failed SQL: CREATE TABLE metabase.QRTZ_JOB_DETAILS (SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, `DESCRIPTION` VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BIT(1) NOT NULL, IS_NONCONCURRENT BIT(1) NOT NULL, IS_UPDATE_DATA BIT(1) NOT NULL, REQUESTS_RECOVERY BIT(1) NOT NULL, JOB_DATA BLOB NULL) COMMENT='Used for Quartz scheduler.' ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

2020-11-15 22:13:23,157 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,158 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,160 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,161 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,162 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,163 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,171 ERROR changelog.ChangeSet :: Change Set migrations/000_migrations.yaml::89::camsaul failed. Error: (conn=6) Table 'qrtz_job_details' already exists [Failed SQL: CREATE TABLE metabase.QRTZ_JOB_DETAILS (SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, `DESCRIPTION` VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BIT(1) NOT NULL, IS_NONCONCURRENT BIT(1) NOT NULL, IS_UPDATE_DATA BIT(1) NOT NULL, REQUESTS_RECOVERY BIT(1) NOT NULL, JOB_DATA BLOB NULL) COMMENT='Used for Quartz scheduler.' ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

2020-11-15 22:13:23,177 WARN metabase.util :: auto-retry metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__20970@1b70a1e3: Migration failed for change set migrations/000_migrations.yaml::89::camsaul:

Reason: liquibase.exception.DatabaseException: (conn=6) Table 'qrtz_job_details' already exists [Failed SQL: CREATE TABLE metabase.QRTZ_JOB_DETAILS (SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, `DESCRIPTION` VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BIT(1) NOT NULL, IS_NONCONCURRENT BIT(1) NOT NULL, IS_UPDATE_DATA BIT(1) NOT NULL, REQUESTS_RECOVERY BIT(1) NOT NULL, JOB_DATA BLOB NULL) COMMENT='Used for Quartz scheduler.' ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

2020-11-15 22:13:23,233 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,234 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,235 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,237 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,238 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,239 WARN changelog.DatabaseChangeLog :: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case

2020-11-15 22:13:23,246 ERROR changelog.ChangeSet :: Change Set migrations/000_migrations.yaml::89::camsaul failed. Error: (conn=6) Table 'qrtz_job_details' already exists [Failed SQL: CREATE TABLE metabase.QRTZ_JOB_DETAILS (SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, `DESCRIPTION` VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BIT(1) NOT NULL, IS_NONCONCURRENT BIT(1) NOT NULL, IS_UPDATE_DATA BIT(1) NOT NULL, REQUESTS_RECOVERY BIT(1) NOT NULL, JOB_DATA BLOB NULL) COMMENT='Used for Quartz scheduler.' ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

2020-11-15 22:13:23,265 ERROR metabase.core :: Metabase Initialization FAILED

liquibase.exception.MigrationFailedException: Migration failed for change set migrations/000_migrations.yaml::89::camsaul:

Reason: liquibase.exception.DatabaseException: (conn=6) Table 'qrtz_job_details' already exists [Failed SQL: CREATE TABLE metabase.QRTZ_JOB_DETAILS (SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, `DESCRIPTION` VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BIT(1) NOT NULL, IS_NONCONCURRENT BIT(1) NOT NULL, IS_UPDATE_DATA BIT(1) NOT NULL, REQUESTS_RECOVERY BIT(1) NOT NULL, JOB_DATA BLOB NULL) COMMENT='Used for Quartz scheduler.' ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637) ~[metabase.jar:?]

at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[metabase.jar:?]

at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83) ~[metabase.jar:?]

at liquibase.Liquibase.update(Liquibase.java:202) ~[metabase.jar:?]

at liquibase.Liquibase.update(Liquibase.java:179) ~[metabase.jar:?]

at liquibase.Liquibase.update(Liquibase.java:175) ~[metabase.jar:?]

at metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__20970.invoke(liquibase.clj:125) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invokeStatic(util.clj:437) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invoke(util.clj:429) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invokeStatic(util.clj:444) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invoke(util.clj:429) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invokeStatic(util.clj:444) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invoke(util.clj:429) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invokeStatic(util.clj:444) ~[metabase.jar:?]

at metabase.util$do_with_auto_retries.invoke(util.clj:429) ~[metabase.jar:?]

at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:125) ~[metabase.jar:?]

at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:113) ~[metabase.jar:?]

at metabase.db$migrate_BANG_$fn__21754$fn__21755.invoke(db.clj:208) ~[metabase.jar:?]

at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:37) ~[metabase.jar:?]

at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:29) ~[metabase.jar:?]

at metabase.db$migrate_BANG_$fn__21754.invoke(db.clj:203) ~[metabase.jar:?]

at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807) ~[metabase.jar:?]

at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]

at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:852) ~[metabase.jar:?]

at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]

at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789) ~[metabase.jar:?]

at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776) ~[metabase.jar:?]

at metabase.db$migrate_BANG_.invokeStatic(db.clj:194) ~[metabase.jar:?]

at metabase.db$migrate_BANG_.invoke(db.clj:173) ~[metabase.jar:?]

at metabase.db$run_schema_migrations_BANG_.invokeStatic(db.clj:336) ~[metabase.jar:?]

at metabase.db$run_schema_migrations_BANG_.invoke(db.clj:330) ~[metabase.jar:?]

at metabase.db$setup_db_BANG__STAR_$fn__21837.invoke(db.clj:353) ~[metabase.jar:?]

at metabase.util$do_with_us_locale.invokeStatic(util.clj:670) ~[metabase.jar:?]

at metabase.util$do_with_us_locale.invoke(util.clj:656) ~[metabase.jar:?]

at metabase.db$setup_db_BANG__STAR_.invokeStatic(db.clj:351) ~[metabase.jar:?]

at metabase.db$setup_db_BANG__STAR_.invoke(db.clj:346) ~[metabase.jar:?]

at metabase.db$setup_db_from_env_BANG_.invokeStatic(db.clj:365) ~[metabase.jar:?]

at metabase.db$setup_db_from_env_BANG_.invoke(db.clj:358) ~[metabase.jar:?]

at metabase.db$setup_db_BANG_$fn__21842.invoke(db.clj:375) ~[metabase.jar:?]

at metabase.db$setup_db_BANG_.invokeStatic(db.clj:373) ~[metabase.jar:?]

at metabase.db$setup_db_BANG_.invoke(db.clj:368) ~[metabase.jar:?]

at metabase.core$init_BANG_.invokeStatic(core.clj:96) ~[metabase.jar:?]

at metabase.core$init_BANG_.invoke(core.clj:75) ~[metabase.jar:?]

at metabase.core$start_normally.invokeStatic(core.clj:140) [metabase.jar:?]

at metabase.core$start_normally.invoke(core.clj:134) [metabase.jar:?]

at metabase.core$_main.invokeStatic(core.clj:173) [metabase.jar:?]

at metabase.core$_main.doInvoke(core.clj:167) [metabase.jar:?]

at clojure.lang.RestFn.invoke(RestFn.java:397) [metabase.jar:?]

at clojure.lang.AFn.applyToHelper(AFn.java:152) [metabase.jar:?]

at clojure.lang.RestFn.applyTo(RestFn.java:132) [metabase.jar:?]

at metabase.core.main(Unknown Source) [metabase.jar:?]

Caused by: liquibase.exception.DatabaseException: (conn=6) Table 'qrtz_job_details' already exists [Failed SQL: CREATE TABLE metabase.QRTZ_JOB_DETAILS (SCHED_NAME VARCHAR(120) NOT NULL, JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, `DESCRIPTION` VARCHAR(250) NULL, JOB_CLASS_NAME VARCHAR(250) NOT NULL, IS_DURABLE BIT(1) NOT NULL, IS_NONCONCURRENT BIT(1) NOT NULL, IS_UPDATE_DATA BIT(1) NOT NULL, REQUESTS_RECOVERY BIT(1) NOT NULL, JOB_DATA BLOB NULL) COMMENT='Used for Quartz scheduler.' ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci]

at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211) ~[metabase.jar:?]

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600) ~[metabase.jar:?]

... 50 more

Caused by: java.sql.SQLSyntaxErrorException: (conn=6) Table 'qrtz_job_details' already exists

at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[metabase.jar:?]

at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153) ~[metabase.jar:?]

at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274) ~[metabase.jar:?]

at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363) ~[metabase.jar:?]

at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211) ~[metabase.jar:?]

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600) ~[metabase.jar:?]

... 50 more

Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Table 'qrtz_job_details' already exists

at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34) ~[metabase.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)

~[metabase.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262) ~[metabase.jar:?]

at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[metabase.jar:?]

at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211) ~[metabase.jar:?]

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600) ~[metabase.jar:?]

... 50 more

Caused by: java.sql.SQLException: Table 'qrtz_job_details' already exists

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1688) ~[metabase.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1550) ~[metabase.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1513) ~[metabase.jar:?]

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256) ~[metabase.jar:?]

at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:357) ~[metabase.jar:?]

at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) ~[metabase.jar:?]

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229) ~[metabase.jar:?]

at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211) ~[metabase.jar:?]

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600) ~[metabase.jar:?]

... 50 more

2020-11-15 22:13:23,290 INFO metabase.core :: Metabase Shutting Down ...

2020-11-15 22:13:23,292 INFO metabase.server :: Shutting Down Embedded Jetty Webserver

2020-11-15 22:13:23,314 INFO metabase.core :: Metabase Shutdown COMPLETE

@av84fun Something tells me that you have a dirty volume for MariaDB. Delete the folder before starting.
Since I don’t see you creating the database metabase, then I don’t know how this docker-compose would work on a clean setup.
I highly recommend not doing migration on Docker, but just use the JAR file with Java properties, since migration is only done once and is much easier to control that way.

docker-compose.yaml:

version: '3.1'

services:
    metabasedb:
        image: mariadb:latest
        container_name: metabasedb
        restart: always
        ports:
            - 3306:3306
        volumes: 
            - ./mariadb:/var/lib/mysql
            - ./metabase-mariadb-init.sql:/docker-entrypoint-initdb.d/init.sql
        environment:
            MYSQL_ROOT_PASSWORD: password
    
    metabase:
        image: metabase/metabase:latest
        container_name: metabaseapp
        environment:
            - MB_DB_TYPE=mysql
            - MB_DB_DBNAME=metabase
            - MB_DB_PORT=3306
            - MB_DB_USER=root
            - MB_DB_PASS=password
            - MB_DB_HOST=metabasedb
        ports:
            - 3000:3000
        volumes:
            - './:/app/metabase'
        depends_on: 
            - metabasedb

metabase-mariadb-init.sql

CREATE DATABASE metabase;

@flamber Got it! Only Four days :unamused:!

Your suggestion didn’t work. Same problems. I still don’t know the root cause but I copied the entire folder from MacOS Big Sur to a windows 10 box and started the containers, worked perfectly. Was able to export H2 to mysql as well.

Thanks for your assistance.
E