Anybody ever faced this error before?
```Error in ...
# orm-helpk
khareta
07/02/2021, 1:48 PMAnybody ever faced this error before?
Copy code
Error in connector: Error creating a database connection. (Timed out fetching a connection from the pool (connection limit: 50, in use: 17))r
Ryan
07/02/2021, 1:54 PMPossibly related: https://github.com/prisma/prisma/issues/7249
k
khareta
07/02/2021, 2:06 PMWhat do you think of this @Ryan?
khareta
07/02/2021, 2:08 PMkhareta
07/02/2021, 2:24 PMr
Ryan
07/02/2021, 2:33 PMThere was a spike in requests it seems but this is long running server so you could try increasing the connection limit and check.
k
khareta
07/02/2021, 2:36 PMIt was set to 50, but I have changed it some time ago to 100. This elastic beanstalk has 3 apps; a frontend website + a blog + backend api.
j
janpio
07/02/2021, 4:00 PM
The error message indicates this is a older version.
janpio
07/02/2021, 4:01 PM
This might very well be something already fixed in a newer version.
janpio
07/02/2021, 4:01 PM
You can also increase the
pool_timeoutjanpio
07/02/2021, 4:01 PM
Fundamentally I would say the database was unresponsive for a bit, and then things snowballed from there 😕
k
khareta
07/02/2021, 7:02 PM@janpio yeah, we're at v2.19 and hoping to upgrade soon. I really hope that this issue has been fixed in later versions.
👍 1
khareta
07/02/2021, 7:03 PMwhat values do you recommend for
pool_timeoutj
janpio
07/02/2021, 7:16 PM
If you are hitting the error, double it.
janpio
07/02/2021, 7:16 PM
The default is quite sensible with 10s (I think), but a simple way to avoid it might be to just double it.
k
khareta
07/02/2021, 11:23 PMI'll attempt other related fixes, and if they don't work, then I'll double the pool timeout. Thank you guys.
4 Views