Migration error on Heroku from 0.41.6 => 0.42.0

Hi!

I am getting a migration error when trying to upgrade my metabase... Any ideas


WARN metabase.util :: auto-retry metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__14371@4e09a3a9: Migration failed for change set migrations/000_migrations.yaml::v42.00-000::camsaul:
2022-08-18T20:28:12.221939+00:00 app[web.1]: Reason: liquibase.exception.DatabaseException: ERROR: cannot drop column entity_name of table metabase_table because other objects depend on it
2022-08-18T20:28:12.221940+00:00 app[web.1]: Detail: view vw_meta_table_count depends on column entity_name of table metabase_table
2022-08-18T20:28:12.221940+00:00 app[web.1]: Hint: Use DROP ... CASCADE to drop the dependent objects too. [Failed SQL: ALTER TABLE public.metabase_table DROP COLUMN entity_name]
2022-08-18T20:28:12.292495+00:00 app[web.1]: 2022-08-18 13:28:12,292 ERROR changelog.ChangeSet :: Change Set migrations/000_migrations.yaml::v42.00-000::camsaul failed.  Error: ERROR: cannot drop column entity_name of table metabase_table because other objects depend on it
2022-08-18T20:28:12.292497+00:00 app[web.1]: Detail: view vw_meta_table_count depends on column entity_name of table metabase_table
2022-08-18T20:28:12.292497+00:00 app[web.1]: Hint: Use DROP ... CASCADE to drop the dependent objects too. [Failed SQL: ALTER TABLE public.metabase_table DROP COLUMN entity_name]
2022-08-18T20:28:12.329384+00:00 app[web.1]: 2022-08-18 13:28:12,324 ERROR metabase.core :: Metabase Initialization FAILED
2022-08-18T20:28:12.329386+00:00 app[web.1]: liquibase.exception.MigrationFailedException: Migration failed for change set migrations/000_migrations.yaml::v42.00-000::camsaul:
2022-08-18T20:28:12.329386+00:00 app[web.1]: Reason: liquibase.exception.DatabaseException: ERROR: cannot drop column entity_name of table metabase_table because other objects depend on it
2022-08-18T20:28:12.329387+00:00 app[web.1]: Detail: view vw_meta_table_count depends on column entity_name of table metabase_table
2022-08-18T20:28:12.329387+00:00 app[web.1]: Hint: Use DROP ... CASCADE to drop the dependent objects too. [Failed SQL: ALTER TABLE public.metabase_table DROP COLUMN entity_name]
2022-08-18T20:28:12.329388+00:00 app[web.1]: at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
2022-08-18T20:28:12.329388+00:00 app[web.1]: at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
2022-08-18T20:28:12.329389+00:00 app[web.1]: at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83)
2022-08-18T20:28:12.329389+00:00 app[web.1]: at liquibase.Liquibase.update(Liquibase.java:202)
2022-08-18T20:28:12.329389+00:00 app[web.1]: at liquibase.Liquibase.update(Liquibase.java:179)
2022-08-18T20:28:12.329390+00:00 app[web.1]: at liquibase.Liquibase.update(Liquibase.java:175)
2022-08-18T20:28:12.329390+00:00 app[web.1]: at metabase.db.liquibase$migrate_up_if_needed_BANG_$fn__14371.invoke(liquibase.clj:126)
2022-08-18T20:28:12.329390+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invokeStatic(util.clj:471)
2022-08-18T20:28:12.329391+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invoke(util.clj:463)
2022-08-18T20:28:12.329391+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invokeStatic(util.clj:478)
2022-08-18T20:28:12.329391+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invoke(util.clj:463)
2022-08-18T20:28:12.329392+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invokeStatic(util.clj:478)
2022-08-18T20:28:12.329392+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invoke(util.clj:463)
2022-08-18T20:28:12.329392+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invokeStatic(util.clj:478)
2022-08-18T20:28:12.329392+00:00 app[web.1]: at metabase.util$do_with_auto_retries.invoke(util.clj:463)
2022-08-18T20:28:12.329393+00:00 app[web.1]: at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:126)
2022-08-18T20:28:12.329393+00:00 app[web.1]: at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:114)
2022-08-18T20:28:12.329393+00:00 app[web.1]: at metabase.db.setup$migrate_BANG_$fn__34055$fn__34056.invoke(setup.clj:68)
2022-08-18T20:28:12.329393+00:00 app[web.1]: at metabase.db.liquibase$do_with_liquibase.invokeStatic(liquibase.clj:38)
2022-08-18T20:28:12.329394+00:00 app[web.1]: at metabase.db.liquibase$do_with_liquibase.invoke(liquibase.clj:30)
2022-08-18T20:28:12.329394+00:00 app[web.1]: at metabase.db.setup$migrate_BANG_$fn__34055.invoke(setup.clj:63)
2022-08-18T20:28:12.329394+00:00 app[web.1]: at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:807)
2022-08-18T20:28:12.329394+00:00 app[web.1]: at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
2022-08-18T20:28:12.329395+00:00 app[web.1]: at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:852)
2022-08-18T20:28:12.329395+00:00 app[web.1]: at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
2022-08-18T20:28:12.329395+00:00 app[web.1]: at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:789)
2022-08-18T20:28:12.329396+00:00 app[web.1]: at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:776)
2022-08-18T20:28:12.329396+00:00 app[web.1]: at metabase.db.setup$migrate_BANG_.invokeStatic(setup.clj:54)
2022-08-18T20:28:12.329396+00:00 app[web.1]: at metabase.db.setup$migrate_BANG_.invoke(setup.clj:40)
2022-08-18T20:28:12.329396+00:00 app[web.1]: at metabase.db.setup$run_schema_migrations_BANG_.invokeStatic(setup.clj:119)
2022-08-18T20:28:12.329397+00:00 app[web.1]: at metabase.db.setup$run_schema_migrations_BANG_.invoke(setup.clj:115)
2022-08-18T20:28:12.329397+00:00 app[web.1]: at metabase.db.setup$setup_db_BANG_$fn__34106$fn__34107.invoke(setup.clj:143)
2022-08-18T20:28:12.329397+00:00 app[web.1]: at metabase.util$do_with_us_locale.invokeStatic(util.clj:692)
2022-08-18T20:28:12.329397+00:00 app[web.1]: at metabase.util$do_with_us_locale.invoke(util.clj:678)
2022-08-18T20:28:12.329398+00:00 app[web.1]: at metabase.db.setup$setup_db_BANG_$fn__34106.invoke(setup.clj:141)
2022-08-18T20:28:12.329398+00:00 app[web.1]: at metabase.db.setup$setup_db_BANG_.invokeStatic(setup.clj:140)
2022-08-18T20:28:12.329398+00:00 app[web.1]: at metabase.db.setup$setup_db_BANG_.invoke(setup.clj:136)
2022-08-18T20:28:12.329398+00:00 app[web.1]: at metabase.db$setup_db_BANG_$fn__34216.invoke(db.clj:61)
2022-08-18T20:28:12.329399+00:00 app[web.1]: at metabase.db$setup_db_BANG_.invokeStatic(db.clj:56)
2022-08-18T20:28:12.329399+00:00 app[web.1]: at metabase.db$setup_db_BANG_.invoke(db.clj:51)
2022-08-18T20:28:12.329401+00:00 app[web.1]: at metabase.core$init_BANG_.invokeStatic(core.clj:90)
2022-08-18T20:28:12.329401+00:00 app[web.1]: at metabase.core$init_BANG_.invoke(core.clj:73)
2022-08-18T20:28:12.329401+00:00 app[web.1]: at metabase.core$start_normally.invokeStatic(core.clj:131)
2022-08-18T20:28:12.329401+00:00 app[web.1]: at metabase.core$start_normally.invoke(core.clj:125)
2022-08-18T20:28:12.329402+00:00 app[web.1]: at metabase.core$_main.invokeStatic(core.clj:164)
2022-08-18T20:28:12.329402+00:00 app[web.1]: at metabase.core$_main.doInvoke(core.clj:158)
2022-08-18T20:28:12.329402+00:00 app[web.1]: at clojure.lang.RestFn.invoke(RestFn.java:397)
2022-08-18T20:28:12.329403+00:00 app[web.1]: at clojure.lang.AFn.applyToHelper(AFn.java:152)
2022-08-18T20:28:12.329403+00:00 app[web.1]: at clojure.lang.RestFn.applyTo(RestFn.java:132)
2022-08-18T20:28:12.329403+00:00 app[web.1]: at metabase.core.main(Unknown Source)
2022-08-18T20:28:12.329403+00:00 app[web.1]: Caused by: liquibase.exception.DatabaseException: ERROR: cannot drop column entity_name of table metabase_table because other objects depend on it

Any ideas how I could get unstuck?

Hi @maxwell
You have made manual changes to the Metabase application database, which causes problems for the automatic migration. I don't know what vw_meta_table_count is, but guess it's something you have created.