P
Prisma3mo ago
aa55h

postgres db collation error

riginal error:
ERROR: template database "template1" has a collation version mismatch
DETAIL: The template database was created using collation version 2.39, but the operating system provides version 2.40.
HINT: Rebuild all objects in the template database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
0: schema_core::state::DevDiagnostic
at schema-engine/core/src/state.rs:276
riginal error:
ERROR: template database "template1" has a collation version mismatch
DETAIL: The template database was created using collation version 2.39, but the operating system provides version 2.40.
HINT: Rebuild all objects in the template database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
0: schema_core::state::DevDiagnostic
at schema-engine/core/src/state.rs:276
it basically happens for any database prisma creates, any idea why?
2 Replies
Nurul
Nurul3mo ago
Can you provide a minimal reproduction so that we can take a look?
RaphaelEtim
RaphaelEtim3mo ago
In addition, can you try this command?
ALTER DATABASE template1 REFRESH COLLATION VERSION;
ALTER DATABASE template1 REFRESH COLLATION VERSION;
Want results from more Discord servers?
Add your server