TraceResolve
MCP
Back to CatalogPrisma / Postgres

Prisma: P2002 Unique constraint failed on the fields

PrismaClientKnownRequestError: Unique constraint failed on the fields: (`email`) Code: P2002
Immediate Remediation
bash
Use prisma.user.upsert({ where: { email }, update: {...}, create: {...} }) or catch error.code === "P2002".
Root Cause Analysis

Encountered in Prisma / Postgres when standard configuration or runtime constraints are violated.

Verification & Guardrails

  • Verify dependencies and runtime version compatibility.
  • Ensure clean build artifact state.

Have a custom or uncategorized crash?

Run your trace through our in-memory client privacy sandbox for instant SRE remediation.

Open Diagnostic Studio