NeonN
Neon14mo ago
3 replies
wet-aqua

connection terminated on vercel

I'm running a remix app on vercel with prisma. The connection happens through @neondatabase/serverless@0.9.3 and @prisma/adapter-neon (changelog indicates that there isn't much changes between 0.9.3 and latest).
I'm experiencing Unhandled Rejection: Error: Connection terminated unexpectedly and Error: socket hang up on file:///var/task/node_modules/.pnpm/@neondatabase+serverless@0.9.3/node_modules/@neondatabase/serverless/index.mjs. Nothing on my neon dashboard is showing issues.

It does not happen consistently. The query does return a big payload: 1.3MB spread out on 433 records, it is sent compressed to the client so it isn't that heavy. My assumption is that the size of the results is causing this issue. Am I correct?
The result size is kind of outrageous 🙈😅 so I'll be filtering what data I actually need on the page.

I guess my questions are:
1. is the connection terminated because of the result size?
2. if so is there any configuration we can rely on to mitigate this issue?
3. if not, is there a limit I should pay attention to? so in the future I can monitor this, and change the way I load data.
Was this page helpful?