Migration fails with CockroachDB

I use CockroachDB as the database for my app and prisma as the ORM. Running

npx prisma migrate dev

npx prisma migrate dev

always fails for whatever reason, but

npx prisma db push

npx prisma db push

succeeds. Is there a reason why this behaves like this?

Migration fails with CockroachDB - Prisma