This site is in development
Confusing Prisma Client's error message when given string value isn't UUID compatible format for Postgres

Home > Blogs

Confusing Prisma Client's error message when given string value isn't UUID compatible format for Postgres

April 12, 2021

Example error message:

shell

PrismaClientUnknownRequestError2 [PrismaClientUnknownRequestError]: Invalid `prisma.verificationRequest.findFirst()` invocation: Error occurred during query execution: ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: ToSql(0), cause: Some(Error(Parser(InvalidLength { expected: Any([36, 32]), found: 5 }))) }) })

The error message above telling us that a field in the findFirst() parameter is an incompatible UUID string because of its length. The expected string length is either 36 or 32 characters, but found 5 characters instead. This is undebuggable!


Someone created a GitHub issue on this problem here: https://github.com/prisma/prisma/issues/4060