2 months ago
I'm getting DB connection issues for my MySQL instance which is impacting prod. Sometimes requests go through, sometimes they don't. Intermittent connectivity.
Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 5), data=None)
Pinned Solution
2 months ago
that's it, prisma links you to their own docs in the error message confirming this is the issue. try that first and let me know if it helps
3 Replies
2 months ago
your error is telling you the fix, ur connection pool is maxed out at 5 connections with a 10s timeout, so when requests pile up they get dropped
just update your database_url and add these two params at the end:
?connection_limit=20&pool_timeout=30
2 months ago
that's it, prisma links you to their own docs in the error message confirming this is the issue. try that first and let me know if it helps
2 months ago
Hi Ilyass012,
This is working for us. My guess is increased traffic has caused more connections to be used up, so this is a good temporary fix in the meantime. Thanks!
Status changed to Solved nico • 2 months ago