Hi to all,
I want to use latest verison of metabase with Postgres 16.6
However while db migration I got error below:
Liquibase scripts try to change id gen sequence owner by none (as far as I understand)
Can I help about that issue ?
2025-02-14 10:29:43,854 ERROR core.core :: Metabase Initialization FAILED
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset migrations/001_update_migrations.yaml::v45.00-001::snoe:
Reason: liquibase.exception.DatabaseException: ERROR: Owned by none change failed for SEQUENCE public.action_id_seq: cannot change ownership of identity sequence
Where: PL/pgSQL function change_ownership() line 20 at RAISE [Failed SQL: (0) CREATE TABLE "public"."action" ("id" INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL, "created_at" TIMESTAMP with time zone DEFAULT NOW() NOT NULL, "updated_at" TIMESTAMP with time zone DEFAULT NOW() NOT NULL, "type" TEXT NOT NULL, CONSTRAINT "action_pkey" PRIMARY KEY ("id"))]
.....
Caused by: org.postgresql.util.PSQLException: ERROR: Owned by none change failed for SEQUENCE public.action_id_seq: cannot change ownership of identity sequence
Where: PL/pgSQL function change_ownership()