dev migrations are failing with cdb due to multi-region enum cannot be modified
after
prisma migrate dev i face this error
I'm using cockroachdb
Error: P3006
Migration 20251015143453_init failed to apply cleanly to the shadow database.
Error:
ERROR: "public.crdb_internal_region" is a multi-region enum and cannot be modified directly
HINT: try ALTER DATABASE DROP REGION public.crdb_internal_region
0: sql_schema_connector::validate_migrations
with namespaces=None filter=SchemaFilter { external_tables: [], external_enums: [] }
at schema-engine/connectors/sql-schema-connector/src/lib.rs:538
1: schema_core::state::DevDiagnostic
at schema-engine/core/src/state.rs:3034 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.This looks related to this GitHub Issue:
https://github.com/prisma/prisma/issues/11127
GitHub
Cannot use
crdb_region in CockroachDB · Issue #11127 · prisma/p...Bug description I'm using Prisma to query a dedicated CockroachDB multi-region instance. For REGIONAL BY ROW tables, there is a hidden internal crdb_region column created by CockroachDB. This c...
Try this workaround?
https://github.com/prisma/prisma/issues/11127#issuecomment-2518608758
GitHub
Cannot use
crdb_region in CockroachDB · Issue #11127 · prisma/p...Bug description I'm using Prisma to query a dedicated CockroachDB multi-region instance. For REGIONAL BY ROW tables, there is a hidden internal crdb_region column created by CockroachDB. This c...
hey! thanks for replying i'll surely go through this