Hi, today I tried to make an version upgrade on my metabase instance. But it did not went ok. The log says something about a failed migration.
Is there any way to revert the failed migrations so I can go back to version 0.46.5?
Aug 26 14:59:24 util-server metabase[2788081]: 2024-08-26 14:59:24,556 INFO metabase.util :: Maximum memory available to JVM: 4.0 GB
Aug 26 14:59:27 util-server metabase[2788081]: 2024-08-26 14:59:27,562 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. 🔓
Aug 26 14:59:27 util-server metabase[2788081]: For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
Aug 26 14:59:34 util-server metabase[2788081]: 2024-08-26 14:59:34,524 INFO driver.impl :: #033[34mRegistered abstract driver :sql#033[0m 🚚
Aug 26 14:59:34 util-server metabase[2788081]: 2024-08-26 14:59:34,570 INFO driver.impl :: #033[34mRegistered abstract driver :sql-jdbc#033[0m (parents: [:sql]) 🚚
Aug 26 14:59:34 util-server metabase[2788081]: 2024-08-26 14:59:34,581 INFO metabase.util :: #033[32mLoad driver :sql-jdbc took 22.5 ms#033[0m
Aug 26 14:59:34 util-server metabase[2788081]: 2024-08-26 14:59:34,582 INFO driver.impl :: #033[34mRegistered driver :h2#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:34 util-server metabase[2788081]: 2024-08-26 14:59:34,907 INFO driver.impl :: #033[34mRegistered driver :mysql#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:34 util-server metabase[2788081]: 2024-08-26 14:59:34,948 INFO driver.impl :: #033[34mRegistered driver :postgres#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,341 INFO metabase.core ::
Aug 26 14:59:37 util-server metabase[2788081]: Metabase v0.50.21 (ec9f5d7)
Aug 26 14:59:37 util-server metabase[2788081]: Copyright © 2024 Metabase, Inc.
Aug 26 14:59:37 util-server metabase[2788081]: Metabase Enterprise Edition extensions are NOT PRESENT.
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,351 INFO metabase.core :: Starting Metabase in STANDALONE mode
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,402 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
Aug 26 14:59:37 util-server metabase[2788081]: {:port 3000}
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,454 INFO metabase.core :: Starting Metabase version v0.50.21 (ec9f5d7) ...
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,460 INFO metabase.core :: System info:
Aug 26 14:59:37 util-server metabase[2788081]: {"file.encoding" "UTF-8",
Aug 26 14:59:37 util-server metabase[2788081]: "java.runtime.name" "OpenJDK Runtime Environment",
Aug 26 14:59:37 util-server metabase[2788081]: "java.runtime.version" "11.0.24+8-post-Ubuntu-1ubuntu322.04",
Aug 26 14:59:37 util-server metabase[2788081]: "java.vendor" "Ubuntu",
Aug 26 14:59:37 util-server metabase[2788081]: "java.vendor.url" "https://ubuntu.com/",
Aug 26 14:59:37 util-server metabase[2788081]: "java.version" "11.0.24",
Aug 26 14:59:37 util-server metabase[2788081]: "java.vm.name" "OpenJDK 64-Bit Server VM",
Aug 26 14:59:37 util-server metabase[2788081]: "java.vm.version" "11.0.24+8-post-Ubuntu-1ubuntu322.04",
Aug 26 14:59:37 util-server metabase[2788081]: "os.name" "Linux",
Aug 26 14:59:37 util-server metabase[2788081]: "os.version" "5.15.0-117-generic",
Aug 26 14:59:37 util-server metabase[2788081]: "user.language" "en",
Aug 26 14:59:37 util-server metabase[2788081]: "user.timezone" "America/Bahia"}
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,463 INFO metabase.plugins :: Loading plugins in /metabase/plugins...
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,903 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :druid-jdbc...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,904 INFO driver.impl :: #033[34mRegistered driver :druid-jdbc#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,912 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :sqlserver...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,912 INFO driver.impl :: #033[34mRegistered driver :sqlserver#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,918 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :redshift...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,919 INFO driver.impl :: #033[34mRegistered driver :redshift#033[0m (parents: [:postgres]) 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,924 INFO plugins.dependencies :: #033[31mMetabase cannot initialize plugin Metabase Vertica Driver due to required dependencies.#033[0m 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.
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,925 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,926 INFO plugins.dependencies :: #033[33mPlugins with unsatisfied deps: ["Metabase Vertica Driver"]#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,939 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :athena...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,939 INFO driver.impl :: #033[34mRegistered driver :athena#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,953 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :presto-jdbc...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,954 INFO driver.impl :: #033[34mRegistered driver :presto-jdbc#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,960 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :googleanalytics...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,961 INFO driver.impl :: #033[34mRegistered driver :googleanalytics#033[0m 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,966 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :druid...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,967 INFO driver.impl :: #033[34mRegistered driver :druid#033[0m 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,973 INFO plugins.dependencies :: #033[31mMetabase cannot initialize plugin Metabase Oracle Driver due to required dependencies.#033[0m 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.
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,974 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,975 INFO plugins.dependencies :: #033[33mPlugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,977 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :sqlite...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,978 INFO driver.impl :: #033[34mRegistered driver :sqlite#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,993 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :bigquery-cloud-sdk...#033[0m
Aug 26 14:59:37 util-server metabase[2788081]: 2024-08-26 14:59:37,994 INFO driver.impl :: #033[34mRegistered driver :bigquery-cloud-sdk#033[0m (parents: [:sql]) 🚚
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,023 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :snowflake...#033[0m
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,024 INFO driver.impl :: #033[34mRegistered driver :snowflake#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,030 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :mongo...#033[0m
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,030 INFO driver.impl :: #033[34mRegistered driver :mongo#033[0m 🚚
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,037 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :hive-like...#033[0m
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,038 INFO driver.impl :: #033[34mRegistered abstract driver :hive-like#033[0m (parents: [:sql-jdbc]) 🚚
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,039 DEBUG plugins.lazy-loaded-driver :: #033[35mRegistering lazy loading driver :sparksql...#033[0m
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,039 INFO driver.impl :: #033[34mRegistered driver :sparksql#033[0m (parents: [:hive-like]) 🚚
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,046 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,048 INFO db.setup :: #033[36mVerifying mysql Database Connection ...#033[0m
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,235 INFO db.setup :: Successfully verified MySQL 5.7.42-0ubuntu0.18.04.1-log application database connection. ✅
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,236 INFO db.setup :: #033[36mChecking if a database downgrade is required...#033[0m
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,932 INFO db.setup :: Running Database Migrations...
Aug 26 14:59:38 util-server metabase[2788081]: 2024-08-26 14:59:38,934 INFO db.setup :: Setting up Liquibase...
Aug 26 14:59:39 util-server metabase[2788081]: 2024-08-26 14:59:39,215 INFO db.setup :: Liquibase is ready.
Aug 26 14:59:39 util-server metabase[2788081]: 2024-08-26 14:59:39,216 INFO db.liquibase :: Checking if Database has unrun migrations...
Aug 26 14:59:39 util-server metabase[2788081]: 2024-08-26 14:59:39,854 INFO db.liquibase :: Database has unrun migrations. Checking if migration lock is taken...
Aug 26 14:59:39 util-server metabase[2788081]: 2024-08-26 14:59:39,868 INFO db.liquibase :: No migration lock found.
Aug 26 14:59:39 util-server metabase[2788081]: 2024-08-26 14:59:39,868 INFO db.liquibase :: Migration lock acquired.
Aug 26 14:59:40 util-server metabase[2788081]: 2024-08-26 14:59:40,217 INFO db.liquibase :: Running 220 migrations ...
Aug 26 14:59:40 util-server metabase[2788081]: 2024-08-26 14:59:40,531 ERROR liquibase.changelog :: ChangeSet migrations/001_update_migrations.yaml::v48.00-033::noahmoss encountered an exception.
Aug 26 14:59:40 util-server metabase[2788081]: liquibase.exception.DatabaseException: (conn=208263669) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as ( [Failed SQL: (1064) create or replace view v_subscriptions as
Aug 26 14:59:40 util-server metabase[2788081]: with agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel_id,
Aug 26 14:59:40 util-server metabase[2788081]: group_concat(core_user.email) as recipients
Aug 26 14:59:40 util-server metabase[2788081]: from pulse_channel_recipient
Aug 26 14:59:40 util-server metabase[2788081]: left join core_user on pulse_channel_recipient.user_id = core_user.id
Aug 26 14:59:40 util-server metabase[2788081]: group by pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: )
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse.id as entity_id,
Aug 26 14:59:40 util-server metabase[2788081]: concat('pulse_', pulse.id) as entity_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.created_at,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.updated_at,
Aug 26 14:59:40 util-server metabase[2788081]: creator_id,
Aug 26 14:59:40 util-server metabase[2788081]: archived,
Aug 26 14:59:40 util-server metabase[2788081]: concat('dashboard_', dashboard_id) as dashboard_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_type,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_day,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_hour,
Aug 26 14:59:40 util-server metabase[2788081]: channel_type as recipient_type,
Aug 26 14:59:40 util-server metabase[2788081]: agg_recipients.recipients,
Aug 26 14:59:40 util-server metabase[2788081]: details as recipient_external,
Aug 26 14:59:40 util-server metabase[2788081]: parameters
Aug 26 14:59:40 util-server metabase[2788081]: from pulse
Aug 26 14:59:40 util-server metabase[2788081]: left join pulse_channel on pulse.id = pulse_channel.pulse_id
Aug 26 14:59:40 util-server metabase[2788081]: left join agg_recipients on pulse_channel.id = agg_recipients.pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: where alert_condition is null]
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:470)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:179)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1285)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeSet.execute(ChangeSet.java:755)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:119)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:68)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeLogIterator$2.lambda$run$0(ChangeLogIterator.java:133)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:122)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:252)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:256)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:110)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:108)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.CommandScope.execute(CommandScope.java:217)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.lambda$update$0(Liquibase.java:245)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.runInScope(Liquibase.java:1419)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.update(Liquibase.java:234)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.update(Liquibase.java:212)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.update(Liquibase.java:194)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__44502.invoke(liquibase.clj:360)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$run_in_scope_locked$reify__44498.run(liquibase.clj:325)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$run_in_scope_locked.invokeStatic(liquibase.clj:318)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$run_in_scope_locked.invoke(liquibase.clj:301)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:349)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:342)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$migrate_BANG_$fn__53447.invoke(setup.clj:84)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$do_with_liquibase$f_STAR___44439.invoke(liquibase.clj:140)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:143)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:131)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$migrate_BANG_.invokeStatic(setup.clj:73)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$migrate_BANG_.doInvoke(setup.clj:55)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:425)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$run_schema_migrations_BANG_.invokeStatic(setup.clj:149)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$run_schema_migrations_BANG_.invoke(setup.clj:144)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_$fn__53475$fn__53476.invoke(setup.clj:167)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.util.jvm$do_with_us_locale.invokeStatic(jvm.clj:239)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.util.jvm$do_with_us_locale.invoke(jvm.clj:225)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_$fn__53475.invoke(setup.clj:161)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_.invokeStatic(setup.clj:160)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_.invoke(setup.clj:153)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db$setup_db_BANG_$fn__53500.invoke(db.clj:86)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db$setup_db_BANG_.invokeStatic(db.clj:81)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db$setup_db_BANG_.doInvoke(db.clj:68)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:421)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:117)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG__STAR_.invoke(core.clj:98)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG_.invokeStatic(core.clj:171)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG_.invoke(core.clj:166)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$start_normally.invokeStatic(core.clj:183)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$start_normally.invoke(core.clj:177)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$entrypoint.invokeStatic(core.clj:216)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$entrypoint.doInvoke(core.clj:210)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:397)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.AFn.applyToHelper(AFn.java:152)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.applyTo(RestFn.java:132)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.Var.applyTo(Var.java:705)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.core$apply.invokeStatic(core.clj:667)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.core$apply.invoke(core.clj:662)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.bootstrap$_main.invokeStatic(bootstrap.clj:31)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.bootstrap$_main.doInvoke(bootstrap.clj:28)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:397)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.AFn.applyToHelper(AFn.java:152)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.applyTo(RestFn.java:132)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.bootstrap.main(Unknown Source)
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: java.sql.SQLSyntaxErrorException: (conn=208263669) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
Aug 26 14:59:40 util-server metabase[2788081]: #011at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:464)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 86 more
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:263)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 89 more
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel_id,
Aug 26 14:59:40 util-server metabase[2788081]: group_concat(co' at line 1
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1693)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1555)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:257)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 90 more
Aug 26 14:59:40 util-server metabase[2788081]: UPDATE SUMMARY
Aug 26 14:59:40 util-server metabase[2788081]: Run: 220
Aug 26 14:59:40 util-server metabase[2788081]: Previously run: 182
Aug 26 14:59:40 util-server metabase[2788081]: Filtered out: 5
Aug 26 14:59:40 util-server metabase[2788081]: -------------------------------
Aug 26 14:59:40 util-server metabase[2788081]: Total change sets: 407
Aug 26 14:59:40 util-server metabase[2788081]: FILTERED CHANGE SETS SUMMARY
Aug 26 14:59:40 util-server metabase[2788081]: DBMS mismatch: 5
Aug 26 14:59:40 util-server metabase[2788081]: 2024-08-26 14:59:40,610 ERROR metabase.core :: Metabase Initialization FAILED
Aug 26 14:59:40 util-server metabase[2788081]: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v48.00-033::noahmoss:
Aug 26 14:59:40 util-server metabase[2788081]: Reason: liquibase.exception.DatabaseException: (conn=208263669) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as ( [Failed SQL: (1064) create or replace view v_subscriptions as
Aug 26 14:59:40 util-server metabase[2788081]: with agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel_id,
Aug 26 14:59:40 util-server metabase[2788081]: group_concat(core_user.email) as recipients
Aug 26 14:59:40 util-server metabase[2788081]: from pulse_channel_recipient
Aug 26 14:59:40 util-server metabase[2788081]: left join core_user on pulse_channel_recipient.user_id = core_user.id
Aug 26 14:59:40 util-server metabase[2788081]: group by pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: )
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse.id as entity_id,
Aug 26 14:59:40 util-server metabase[2788081]: concat('pulse_', pulse.id) as entity_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.created_at,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.updated_at,
Aug 26 14:59:40 util-server metabase[2788081]: creator_id,
Aug 26 14:59:40 util-server metabase[2788081]: archived,
Aug 26 14:59:40 util-server metabase[2788081]: concat('dashboard_', dashboard_id) as dashboard_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_type,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_day,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_hour,
Aug 26 14:59:40 util-server metabase[2788081]: channel_type as recipient_type,
Aug 26 14:59:40 util-server metabase[2788081]: agg_recipients.recipients,
Aug 26 14:59:40 util-server metabase[2788081]: details as recipient_external,
Aug 26 14:59:40 util-server metabase[2788081]: parameters
Aug 26 14:59:40 util-server metabase[2788081]: from pulse
Aug 26 14:59:40 util-server metabase[2788081]: left join pulse_channel on pulse.id = pulse_channel.pulse_id
Aug 26 14:59:40 util-server metabase[2788081]: left join agg_recipients on pulse_channel.id = agg_recipients.pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: where alert_condition is null]
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.CommandScope.execute(CommandScope.java:253)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.lambda$update$0(Liquibase.java:245)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.runInScope(Liquibase.java:1419)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.update(Liquibase.java:234)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.update(Liquibase.java:212)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Liquibase.update(Liquibase.java:194)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__44502.invoke(liquibase.clj:360)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$run_in_scope_locked$reify__44498.run(liquibase.clj:325)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$run_in_scope_locked.invokeStatic(liquibase.clj:318)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$run_in_scope_locked.invoke(liquibase.clj:301)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:349)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:342)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$migrate_BANG_$fn__53447.invoke(setup.clj:84)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$do_with_liquibase$f_STAR___44439.invoke(liquibase.clj:140)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:143)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:131)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$migrate_BANG_.invokeStatic(setup.clj:73)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$migrate_BANG_.doInvoke(setup.clj:55)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:425)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$run_schema_migrations_BANG_.invokeStatic(setup.clj:149)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$run_schema_migrations_BANG_.invoke(setup.clj:144)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_$fn__53475$fn__53476.invoke(setup.clj:167)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.util.jvm$do_with_us_locale.invokeStatic(jvm.clj:239)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.util.jvm$do_with_us_locale.invoke(jvm.clj:225)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_$fn__53475.invoke(setup.clj:161)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_.invokeStatic(setup.clj:160)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db.setup$setup_db_BANG_.invoke(setup.clj:153)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db$setup_db_BANG_$fn__53500.invoke(db.clj:86)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db$setup_db_BANG_.invokeStatic(db.clj:81)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.db$setup_db_BANG_.doInvoke(db.clj:68)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:421)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:117)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG__STAR_.invoke(core.clj:98)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG_.invokeStatic(core.clj:171)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$init_BANG_.invoke(core.clj:166)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$start_normally.invokeStatic(core.clj:183)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$start_normally.invoke(core.clj:177)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$entrypoint.invokeStatic(core.clj:216)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.core$entrypoint.doInvoke(core.clj:210)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:397)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.AFn.applyToHelper(AFn.java:152)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.applyTo(RestFn.java:132)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.Var.applyTo(Var.java:705)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.core$apply.invokeStatic(core.clj:667)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.core$apply.invoke(core.clj:662)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.bootstrap$_main.invokeStatic(bootstrap.clj:31)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.bootstrap$_main.doInvoke(bootstrap.clj:28)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.invoke(RestFn.java:397)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.AFn.applyToHelper(AFn.java:152)
Aug 26 14:59:40 util-server metabase[2788081]: #011at clojure.lang.RestFn.applyTo(RestFn.java:132)
Aug 26 14:59:40 util-server metabase[2788081]: #011at metabase.bootstrap.main(Unknown Source)
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v48.00-033::noahmoss:
Aug 26 14:59:40 util-server metabase[2788081]: Reason: liquibase.exception.DatabaseException: (conn=208263669) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as ( [Failed SQL: (1064) create or replace view v_subscriptions as
Aug 26 14:59:40 util-server metabase[2788081]: with agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel_id,
Aug 26 14:59:40 util-server metabase[2788081]: group_concat(core_user.email) as recipients
Aug 26 14:59:40 util-server metabase[2788081]: from pulse_channel_recipient
Aug 26 14:59:40 util-server metabase[2788081]: left join core_user on pulse_channel_recipient.user_id = core_user.id
Aug 26 14:59:40 util-server metabase[2788081]: group by pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: )
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse.id as entity_id,
Aug 26 14:59:40 util-server metabase[2788081]: concat('pulse_', pulse.id) as entity_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.created_at,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.updated_at,
Aug 26 14:59:40 util-server metabase[2788081]: creator_id,
Aug 26 14:59:40 util-server metabase[2788081]: archived,
Aug 26 14:59:40 util-server metabase[2788081]: concat('dashboard_', dashboard_id) as dashboard_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_type,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_day,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_hour,
Aug 26 14:59:40 util-server metabase[2788081]: channel_type as recipient_type,
Aug 26 14:59:40 util-server metabase[2788081]: agg_recipients.recipients,
Aug 26 14:59:40 util-server metabase[2788081]: details as recipient_external,
Aug 26 14:59:40 util-server metabase[2788081]: parameters
Aug 26 14:59:40 util-server metabase[2788081]: from pulse
Aug 26 14:59:40 util-server metabase[2788081]: left join pulse_channel on pulse.id = pulse_channel.pulse_id
Aug 26 14:59:40 util-server metabase[2788081]: left join agg_recipients on pulse_channel.id = agg_recipients.pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: where alert_condition is null]
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:151)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:110)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:108)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.command.CommandScope.execute(CommandScope.java:217)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 58 more
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v48.00-033::noahmoss:
Aug 26 14:59:40 util-server metabase[2788081]: Reason: liquibase.exception.DatabaseException: (conn=208263669) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as ( [Failed SQL: (1064) create or replace view v_subscriptions as
Aug 26 14:59:40 util-server metabase[2788081]: with agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel_id,
Aug 26 14:59:40 util-server metabase[2788081]: group_concat(core_user.email) as recipients
Aug 26 14:59:40 util-server metabase[2788081]: from pulse_channel_recipient
Aug 26 14:59:40 util-server metabase[2788081]: left join core_user on pulse_channel_recipient.user_id = core_user.id
Aug 26 14:59:40 util-server metabase[2788081]: group by pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: )
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse.id as entity_id,
Aug 26 14:59:40 util-server metabase[2788081]: concat('pulse_', pulse.id) as entity_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.created_at,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.updated_at,
Aug 26 14:59:40 util-server metabase[2788081]: creator_id,
Aug 26 14:59:40 util-server metabase[2788081]: archived,
Aug 26 14:59:40 util-server metabase[2788081]: concat('dashboard_', dashboard_id) as dashboard_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_type,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_day,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_hour,
Aug 26 14:59:40 util-server metabase[2788081]: channel_type as recipient_type,
Aug 26 14:59:40 util-server metabase[2788081]: agg_recipients.recipients,
Aug 26 14:59:40 util-server metabase[2788081]: details as recipient_external,
Aug 26 14:59:40 util-server metabase[2788081]: parameters
Aug 26 14:59:40 util-server metabase[2788081]: from pulse
Aug 26 14:59:40 util-server metabase[2788081]: left join pulse_channel on pulse.id = pulse_channel.pulse_id
Aug 26 14:59:40 util-server metabase[2788081]: left join agg_recipients on pulse_channel.id = agg_recipients.pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: where alert_condition is null]
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeSet.execute(ChangeSet.java:797)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:119)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:68)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeLogIterator$2.lambda$run$0(ChangeLogIterator.java:133)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:122)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.lambda$child$0(Scope.java:186)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:185)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:164)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:252)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.Scope.child(Scope.java:256)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 66 more
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: liquibase.exception.DatabaseException: (conn=208263669) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as ( [Failed SQL: (1064) create or replace view v_subscriptions as
Aug 26 14:59:40 util-server metabase[2788081]: with agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel_id,
Aug 26 14:59:40 util-server metabase[2788081]: group_concat(core_user.email) as recipients
Aug 26 14:59:40 util-server metabase[2788081]: from pulse_channel_recipient
Aug 26 14:59:40 util-server metabase[2788081]: left join core_user on pulse_channel_recipient.user_id = core_user.id
Aug 26 14:59:40 util-server metabase[2788081]: group by pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: )
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse.id as entity_id,
Aug 26 14:59:40 util-server metabase[2788081]: concat('pulse_', pulse.id) as entity_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.created_at,
Aug 26 14:59:40 util-server metabase[2788081]: pulse.updated_at,
Aug 26 14:59:40 util-server metabase[2788081]: creator_id,
Aug 26 14:59:40 util-server metabase[2788081]: archived,
Aug 26 14:59:40 util-server metabase[2788081]: concat('dashboard_', dashboard_id) as dashboard_qualified_id,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_type,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_day,
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel.schedule_hour,
Aug 26 14:59:40 util-server metabase[2788081]: channel_type as recipient_type,
Aug 26 14:59:40 util-server metabase[2788081]: agg_recipients.recipients,
Aug 26 14:59:40 util-server metabase[2788081]: details as recipient_external,
Aug 26 14:59:40 util-server metabase[2788081]: parameters
Aug 26 14:59:40 util-server metabase[2788081]: from pulse
Aug 26 14:59:40 util-server metabase[2788081]: left join pulse_channel on pulse.id = pulse_channel.pulse_id
Aug 26 14:59:40 util-server metabase[2788081]: left join agg_recipients on pulse_channel.id = agg_recipients.pulse_channel_id
Aug 26 14:59:40 util-server metabase[2788081]: where alert_condition is null]
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:470)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:179)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:141)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1285)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.changelog.ChangeSet.execute(ChangeSet.java:755)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 81 more
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: java.sql.SQLSyntaxErrorException: (conn=208263669) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
Aug 26 14:59:40 util-server metabase[2788081]: #011at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
Aug 26 14:59:40 util-server metabase[2788081]: #011at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:464)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 86 more
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:263)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 89 more
Aug 26 14:59:40 util-server metabase[2788081]: Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'agg_recipients as (
Aug 26 14:59:40 util-server metabase[2788081]: select
Aug 26 14:59:40 util-server metabase[2788081]: pulse_channel_id,
Aug 26 14:59:40 util-server metabase[2788081]: group_concat(co' at line 1
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1693)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1555)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)
Aug 26 14:59:40 util-server metabase[2788081]: #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:257)
Aug 26 14:59:40 util-server metabase[2788081]: #011... 90 more
Aug 26 14:59:40 util-server metabase[2788081]: 2024-08-26 14:59:40,618 INFO metabase.core :: Metabase Shutting Down ...
Aug 26 14:59:40 util-server metabase[2788081]: 2024-08-26 14:59:40,620 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
Aug 26 14:59:40 util-server metabase[2788081]: 2024-08-26 14:59:40,630 WARN db.liquibase :: ()
Aug 26 14:59:40 util-server metabase[2788081]: 2024-08-26 14:59:40,632 INFO metabase.core :: Metabase Shutdown COMPLETE