P1017: Server has closed the connection

TL;DR

P1017 means the database server hung up on Prisma mid-query. This almost always happens with a connection pooler (PgBouncer, RDS Proxy, Neon pooled) that closes idle connections, or when the server restarts. Point Prisma at the pooler correctly, shorten Prisma's idle handling, or raise the pooler's idle timeout.

The error

Error: P1017
Server has closed the connection

Fix it

1. Check whether you are behind a pooler. If your connection string uses port 6543 (Supabase), a -pooler host (Neon), or PgBouncer/RDS Proxy, the pooler is the prime suspect. Confirm with your provider's dashboard that idle connections get closed after N seconds.

• Expected: you find an idle-timeout setting (often 60-300s) on the pooler.

1. Set connection_limit and pool_timeout in your datasource URL. Add query params so Prisma recycles connections before the pooler kills them:

   datasource db {
     provider = "postgresql"
     url      = env("DATABASE_URL")
   }

   postgresql://HOST:5432/DB?connection_limit=5&pool_timeout=10

• Expected: prisma db pull or your app no longer throws P1017 on idle-then-query patterns.

1. For PgBouncer in transaction mode, keep transactions short. Long interactive transactions get killed first. Break work into smaller transactions.

• Expected: P1017 stops appearing on long-running jobs.

1. If it happens on deploys/restarts, add retry on P1017. Wrap the query in a retry with backoff for this code specifically; a fresh connection succeeds.

• Expected: transient P1017s during rolling restarts no longer fail the request.

When to use

• P1017 appears after periods of inactivity, behind PgBouncer/RDS Proxy/Neon pooler/Supabase pooler.
• P1017 spikes during deployments or database restarts.

When NOT to use

• The error is P1001 (can't reach server at all) or P1008 (operations timed out) - different fixes.
• Every query fails immediately, even the first one - that is a credentials/network issue, not closed idle connections.

Compatibility

• Prisma ORM 2.x-6.x, PostgreSQL and MySQL. Pooler-specific settings vary by provider (Supabase, Neon, RDS).

Root cause

The server or pooler terminates a TCP connection Prisma thought was alive (idle timeout, server restart, max lifetime). Prisma only discovers this when it tries to reuse the connection, and surfaces P1017.

Edge cases

• Neon scale-to-zero closes connections; use the pooled connection string and expect cold starts.
• pool_timeout=0 disables the timeout and can hang forever - keep it small but nonzero.
• Serverless (Lambda, Vercel) with many concurrent invocations can exhaust the pool; lower connection_limit per instance.