Its failing on a migration from 2021:

time=2025-03-07T15:27:37Z level=info msg=Migration has not yet been applied, running migration. audience=application migration_file=migrations/20211004110003000000_change_client_primary_key.cockroach.up.sql migration_name=change_client_primary_key service_name=Ory Hydra service_version=v2.3.0 version=20211004110003000000
------------ ERROR ------------
Could not apply migrations:
ERROR: relation "hydra_client" (119): unimplemented: primary key dropped without subsequent addition of new primary key in same transaction (SQLSTATE 0A000)
error executing migrations/20211004110003000000_change_client_primary_key.cockroach.up.sql, sql: ALTER TABLE hydra_client DROP CONSTRAINT "primary";
ALTER TABLE hydra_client ADD CONSTRAINT "hydra_client_pkey" PRIMARY KEY (pk);

Have you tried a newer CRDB version?

This fails on the newest version of CRDB... the solution is to go back o earlier versions of 24.1 apparently 😞

Then CRDB did a backwards incompatible change which we haven't run into before.