Razil
Explore posts from serversPPrisma
•Created by Razil on 8/7/2024 in #help-and-questions
Prisma & Supbase
In case someone else gets here
"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: 80)" This error is referring to Prisma's internal pooler and not Supavisor.
I checked your metrics and it gave me the impression that you deployed Prisma to a single server. By default, Prisma will set the connection_limit to "num_cpus * 2 + 1". Prisma's query engine and internal pooler utilizes a lot of memory and CPU. When you changed the value significantly above the default, Prisma struggled to orchestrate requests.You would need to upgrade the server hosting Prisma or divide the workload across machines.
2 replies