Hello everyone I am using hydra version v1.11.8 ...
# talk-hydra
b
Hello everyone I am using hydra version v1.11.8 when I do hydra migrate somehow drop is applied before create? anyone knows why this error is throwing? here is the command which I am using to do migrations
Copy code
docker run -it --rm \
  --env DSN=$HYDRA_DB_URL \
  oryd/hydra:1.11.8 \
  migrate sql -e --yes
error
Copy code
20211226155900000000   grant_jwk_bearer                                  Pending
20211226156000000000   dynamic_registration                              Pending
20220328111500000000   support_any_subject_trusts                        Pending
Could not apply migrations:
ERROR: index "hydra_oauth2_access_request_id_idx" does not exist (SQLSTATE 42704)
error executing migrations/20201110104000000000_drop_uq_oauth2.postgres.up.sql, sql: DROP INDEX hydra_oauth2_access_request_id_idx;
DROP INDEX hydra_oauth2_refresh_request_id_idx;

CREATE INDEX hydra_oauth2_access_request_id_idx ON hydra_oauth2_access (request_id);
CREATE INDEX hydra_oauth2_refresh_request_id_idx ON hydra_oauth2_refresh (request_id);

CREATE INDEX hydra_oauth2_code_request_id_idx ON hydra_oauth2_code (request_id);
CREATE INDEX hydra_oauth2_oidc_request_id_idx ON hydra_oauth2_oidc (request_id);
CREATE INDEX hydra_oauth2_pkce_request_id_idx ON hydra_oauth2_pkce (request_id);

<http://github.com/ory/x/popx.NewMigrationBox.func1.1|github.com/ory/x/popx.NewMigrationBox.func1.1>
	/go/pkg/mod/github.com/ory/x@v0.0.368/popx/migration_box.go:80
<http://github.com/ory/x/popx.Migration.Run|github.com/ory/x/popx.Migration.Run>
	/go/pkg/mod/github.com/ory/x@v0.0.368/popx/migration_info.go:34
<http://github.com/ory/x/popx.(*Migrator).UpTo.func1.2|github.com/ory/x/popx.(*Migrator).UpTo.func1.2>
	/go/pkg/mod/github.com/ory/x@v0.0.368/popx/migrator.go:139
<http://github.com/ory/x/popx.(*Migrator).isolatedTransaction|github.com/ory/x/popx.(*Migrator).isolatedTransaction>
	/go/pkg/mod/github.com/ory/x@v0.0.368/popx/migrator.go:314
<http://github.com/ory/x/popx.(*Migrator).UpTo.func1|github.com/ory/x/popx.(*Migrator).UpTo.func1>