Hi !
I try to migrate from 0.49.25 to 0.50.28.
I get the following liquibase migration error :
Chargement de la configuration
Lancement du module Java...
2024-10-09 23:25:10,178 INFO metabase.util :: Maximum memory available to JVM: 7.8 GB
2024-10-09 23:25:12,698 INFO util.encryption :: Saved credentials encryption is ENABLED for this Metabase instance. 🔐
For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2024-10-09 23:25:17,861 INFO driver.impl :: Registered abstract driver :sql 🚚
2024-10-09 23:25:17,896 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) 🚚
2024-10-09 23:25:17,903 INFO metabase.util :: Load driver :sql-jdbc took 18.3 ms
2024-10-09 23:25:17,903 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:18,163 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:18,197 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:19,779 INFO metabase.core ::
Metabase v0.50.28 (3179ef2)
Copyright © 2024 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2024-10-09 23:25:19,787 INFO metabase.core :: Starting Metabase in STANDALONE mode
2024-10-09 23:25:19,826 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}
2024-10-09 23:25:19,879 INFO metabase.core :: Starting Metabase version v0.50.28 (3179ef2) ...
2024-10-09 23:25:19,884 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.24+8-post-Ubuntu-1ubuntu322.04",
"java.vendor" "Ubuntu",
"java.vendor.url" "https://ubuntu.com/",
"java.version" "11.0.24",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.24+8-post-Ubuntu-1ubuntu322.04",
"os.name" "Linux",
"os.version" "5.15.0-122-generic",
"user.language" "en",
"user.timezone" "Europe/Paris"}
2024-10-09 23:25:19,885 INFO metabase.plugins :: Loading plugins in /home/metabase/plugins...
2024-10-09 23:25:20,201 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2024-10-09 23:25:20,201 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:20,201 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2024-10-09 23:25:20,202 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) 🚚
2024-10-09 23:25:20,209 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.
2024-10-09 23:25:20,210 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2024-10-09 23:25:20,211 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2024-10-09 23:25:20,215 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2024-10-09 23:25:20,215 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:20,221 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid-jdbc...
2024-10-09 23:25:20,221 INFO driver.impl :: Registered driver :druid-jdbc (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:20,224 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.
2024-10-09 23:25:20,225 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2024-10-09 23:25:20,225 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]
2024-10-09 23:25:20,232 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2024-10-09 23:25:20,232 INFO driver.impl :: Registered driver :mongo 🚚
2024-10-09 23:25:20,242 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2024-10-09 23:25:20,242 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:20,318 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2024-10-09 23:25:20,318 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:20,321 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2024-10-09 23:25:20,322 INFO driver.impl :: Registered driver :googleanalytics 🚚
2024-10-09 23:25:20,324 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2024-10-09 23:25:20,324 INFO driver.impl :: Registered driver :druid 🚚
2024-10-09 23:25:20,326 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2024-10-09 23:25:20,327 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:20,329 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2024-10-09 23:25:20,330 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) 🚚
2024-10-09 23:25:20,338 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :athena...
2024-10-09 23:25:20,338 INFO driver.impl :: Registered driver :athena (parents: [:sql-jdbc]) 🚚
2024-10-09 23:25:20,352 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2024-10-09 23:25:20,353 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql]) 🚚
2024-10-09 23:25:20,357 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2024-10-09 23:25:20,419 INFO db.setup :: Verifying mysql Database Connection ...
2024-10-09 23:25:20,625 INFO db.setup :: Successfully verified MySQL 8.0.39-0ubuntu0.22.04.1 application database connection. ✅
2024-10-09 23:25:20,626 INFO db.setup :: Checking if a database downgrade is required...
2024-10-09 23:25:21,034 INFO liquibase :: Parsed changelog file 'liquibase.yaml'
2024-10-09 23:25:21,124 INFO db.setup :: Running Database Migrations...
2024-10-09 23:25:21,125 INFO db.setup :: Setting up Liquibase...
2024-10-09 23:25:21,286 INFO liquibase :: Parsed changelog file 'liquibase.yaml'
2024-10-09 23:25:21,308 INFO db.setup :: Liquibase is ready.
2024-10-09 23:25:21,309 INFO db.liquibase :: Checking if Database has unrun migrations...
2024-10-09 23:25:21,461 INFO liquibase :: Parsed changelog file 'liquibase.yaml'
2024-10-09 23:25:21,490 INFO liquibase.changelog :: Reading from metabase.DATABASECHANGELOG
2024-10-09 23:25:21,766 WARN liquibase.changelog :: Due to mysql SQL limitations, setNullable will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-10-09 23:25:21,767 WARN liquibase.changelog :: Due to mysql SQL limitations, addDefaultValue will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-10-09 23:25:21,773 INFO db.liquibase :: Database has unrun migrations. Checking if migration lock is taken...
2024-10-09 23:25:21,785 INFO liquibase.lockservice :: Successfully acquired change log lock
2024-10-09 23:25:21,785 INFO db.liquibase :: No migration lock found.
2024-10-09 23:25:21,786 INFO db.liquibase :: Migration lock acquired.
2024-10-09 23:25:21,921 INFO liquibase :: Parsed changelog file 'liquibase.yaml'
2024-10-09 23:25:21,942 INFO liquibase.changelog :: Reading from metabase.DATABASECHANGELOG
2024-10-09 23:25:22,021 WARN liquibase.changelog :: Due to mysql SQL limitations, setNullable will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-10-09 23:25:22,021 WARN liquibase.changelog :: Due to mysql SQL limitations, addDefaultValue will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-10-09 23:25:22,025 INFO db.liquibase :: Running 67 migrations ...
2024-10-09 23:25:22,097 INFO liquibase.changelog :: Reading from metabase.DATABASECHANGELOG
2024-10-09 23:25:22,179 WARN liquibase.changelog :: Due to mysql SQL limitations, setNullable will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-10-09 23:25:22,179 WARN liquibase.changelog :: Due to mysql SQL limitations, addDefaultValue will lose primary key/autoincrement/not null/comment settings explicitly redefined in the change. Use <sql> or <modifySql> to re-specify all configuration if this is the case
2024-10-09 23:25:22,184 INFO liquibase.command :: Using deploymentId: 8509122184
2024-10-09 23:25:22,186 INFO liquibase.changelog :: Reading from metabase.DATABASECHANGELOG
2024-10-09 23:25:22,250 ERROR liquibase.changelog :: ChangeSet migrations/001_update_migrations.yaml::v50.2024-02-20T19:21:04::camsaul encountered an exception.
liquibase.exception.DatabaseException: (conn=317276) Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [Failed SQL: (1227) DROP VIEW IF EXISTS v_content]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:470)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:179)
at liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1285)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:755)
at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:119)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:68)
at liquibase.changelog.ChangeLogIterator$2.lambda$run$0(ChangeLogIterator.java:133)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:122)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.Scope.child(Scope.java:252)
at liquibase.Scope.child(Scope.java:256)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:110)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:108)
at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
at liquibase.command.CommandScope.execute(CommandScope.java:217)
at liquibase.Liquibase.lambda$update$0(Liquibase.java:245)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.Liquibase.runInScope(Liquibase.java:1419)
at liquibase.Liquibase.update(Liquibase.java:234)
at liquibase.Liquibase.update(Liquibase.java:212)
at liquibase.Liquibase.update(Liquibase.java:194)
at metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__44295.invoke(liquibase.clj:360)
at metabase.db.liquibase$run_in_scope_locked$reify__44291.run(liquibase.clj:325)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at metabase.db.liquibase$run_in_scope_locked.invokeStatic(liquibase.clj:318)
at metabase.db.liquibase$run_in_scope_locked.invoke(liquibase.clj:301)
at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:349)
at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:342)
at metabase.db.setup$migrate_BANG_$fn__54300.invoke(setup.clj:84)
at metabase.db.liquibase$do_with_liquibase$f_STAR___44232.invoke(liquibase.clj:140)
at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:143)
at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:131)
at metabase.db.setup$migrate_BANG_.invokeStatic(setup.clj:73)
at metabase.db.setup$migrate_BANG_.doInvoke(setup.clj:55)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.db.setup$run_schema_migrations_BANG_.invokeStatic(setup.clj:149)
at metabase.db.setup$run_schema_migrations_BANG_.invoke(setup.clj:144)
at metabase.db.setup$setup_db_BANG_$fn__54328$fn__54329.invoke(setup.clj:167)
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$setup_db_BANG_$fn__54328.invoke(setup.clj:161)
at metabase.db.setup$setup_db_BANG_.invokeStatic(setup.clj:160)
at metabase.db.setup$setup_db_BANG_.invoke(setup.clj:153)
at metabase.db$setup_db_BANG_$fn__54353.invoke(db.clj:86)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:81)
at metabase.db$setup_db_BANG_.doInvoke(db.clj:68)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:117)
at metabase.core$init_BANG__STAR_.invoke(core.clj:98)
at metabase.core$init_BANG_.invokeStatic(core.clj:171)
at metabase.core$init_BANG_.invoke(core.clj:166)
at metabase.core$start_normally.invokeStatic(core.clj:183)
at metabase.core$start_normally.invoke(core.clj:177)
at metabase.core$entrypoint.invokeStatic(core.clj:216)
at metabase.core$entrypoint.doInvoke(core.clj:210)
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)
Caused by: java.sql.SQLSyntaxErrorException: (conn=317276) Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:464)
... 86 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:263)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
... 89 more
Caused by: java.sql.SQLException: Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1693)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1555)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:257)
... 90 more
UPDATE SUMMARY
Run: 67
Previously run: 345
Filtered out: 5
-------------------------------
Total change sets: 417
FILTERED CHANGE SETS SUMMARY
DBMS mismatch: 5
...
Any idea ?
Thx,