prisma: Migration failed to apply cleanly to the shadow database

Bug description

After manually correcting a broken migration and committing it to the DB, I’m now getting the following error when I try to create a new migration with prisma migrate dev --create-only

Error: P3006

Migration `20220425205658_add_reference_to_model` failed to apply cleanly to the shadow database.
Error:
insert or update on table "reference" violates foreign key constraint "reference_model_id_fkey"
   0: sql_migration_connector::flavour::postgres::sql_schema_from_migration_history
             at migration-engine/connectors/sql-migration-connector/src/flavour/postgres.rs:354
   1: migration_core::api::DevDiagnostic
             at migration-engine/core/src/api.rs:108

But when I run prisma migrate status it returns Database schema is up to date!, so it shouldn’t be returning this error.

How to reproduce

Expected behavior

If a migration is successfully added to the DB, it shouldn’t still be returning errors.

Prisma information

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["nativeTypes", "interactiveTransactions"]
  binaryTargets   = ["native", "rhel-openssl-1.0.x"]
}

Environment & setup

• OS: MacOS 10.15.7
• Database: PostgreSQL
• Node.js version: v14.18.1

Prisma Version

3.4.2