connection_limit with Prisma Accelerate

[mystic dome]

Hello!

A bit about our setup:
We're using Lambdas, an Aurora Cluster with Postgresql and Prisma ORM.

We setup accelerate and are able to query our DB through accelerate.

Our issue is with the connection pool size, accelerate is only opening 5 connections to our cluster, even if we set the connection_limit to 100 in our DB URL. ([dbURL]?connection_limit=100). As mentioned in the documentation https://www.prisma.io/docs/accelerate/connection-pooling#configuring-the-connection-pool-size.

Are we missing something in our configuration to be able to open more connections?

The associated error in our logs:

{"type":"UnknownJsonError","body":{"code":"P6008","message":"Accelerate was not able to connect to your database. The underlying error is: Too many failed attempts to query database. Try again after 2024-02-02T22:33:34.799Z"}}

Thanks 🙏

[stoic mural]

Hey @mystic dome 👋

When do you get this P6008 errors? Is this intermittent?

Can you share your GitHub handle with me? This would allow me to check the connection pool limit for your project.

[mystic dome]

Hi @stoic mural,

We are doing some load testing to see if Accelerate is the right fit for us and the error arrives right after we try more than 4-5 calls simultaneously. So yes it is intermittent but we can consistently reproduce it.

Of course, my github handle is flowflorent

Is there a connection_limit limit on Accelerate projects? I can't seem to find associated documentation or a section in pricing https://www.prisma.io/pricing

Thanks for the quick response!

[livid totem]

https://www.prisma.io/docs/accelerate/connection-pooling

maybe this can be of some help

[mystic dome]

Thanks @livid totem ! We've already looked at that unfortunately and used it to implement the connection_limit=100 parameter.

@stoic mural would you have any updates on this?