Database Connection Leak - Connections Never Close

1. Not awaiting database queries properly
2. Promise not being resolved/rejected
3. Connection created but not returned to pool
4. Long-running queries holding connections indefinitely
5. Error in query handler not releasing connection

Always await database calls: await prisma.user.findUnique(...)

Use try/finally to ensure cleanup: try { await db.query(...) } finally { await client.release() }

Set query timeout: Prisma has built-in, use setTimeout for others

Check connection pool size: should be reasonable for concurrent users

Monitor connections: SELECT count(*) FROM pg_stat_activity in PostgreSQL