Upgrade from 0.51.14 to 0.52.1 - liquibase migrations failing

[thomasr]

Hello everyone,

I’m getting a liquibase migration fail when trying to upgrade from 0.51.14 to 0.52.1:

metabase-1 | 2025-10-28 12:15:25,840 ERROR liquibase.changelog :: ChangeSet migrations/001_update_migrations.yaml::v52.2024-09-05T08:00:00::qnkhuat encountered an exception.
metabase-1 | liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v52.2024-09-05T08:00:00::qnkhuat:
metabase-1 | Reason:
metabase-1 | liquibase.yaml : Not precondition failed

This is the migration in question:

- changeSet:
      id: v52.2024-09-05T08:00:00
      author: qnkhuat
      comment: Create the notification table
      changes:
        - createTable:
            tableName: notification
            remarks: join table that connect notification subscriptions and notification handlers
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: payload_type
                  remarks: the type of the payload
                  type: varchar(64)
                  constraints:
                    nullable: false
              - column:
                  name: active
                  remarks: whether the notification is active
                  type: ${boolean.type}
                  constraints:
                    nullable: false
                  defaultValueBoolean: true
              - column:
                  remarks: The timestamp of when the notification was created
                  name: created_at
                  type: ${timestamp_type}
                  constraints:
                    nullable: false
              - column:
                  name: updated_at
                  remarks: The timestamp of when the notification was updated
                  type: ${timestamp_type}
                  constraints:
                    nullable: false

Those tables exist in my database:

 public | notification                         | table | metabase-user
 public | notification_card                    | table | metabase-user
 public | notification_handler                 | table | metabase-user
 public | notification_recipient               | table | metabase-user
 public | notification_subscription            | table | metabase-user

Any help would be appreciated

Thank you

[dwhitemv]

It looks like the migration already happened as the tables exist and shouldn’t. Was there a failed migration earlier?

Try rolling back to the previous version and see if the tables disappear. If they don’t, your app database is corrupted, restore from backup and try the upgrade again.

Make sure metabase-user has permissions to create whatever database objects it wants.