Prisma timeout

I am trying to use a fairly large query with Prisma and get 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) Is there a way to increase the timeout and maybe the pool size?
11 Replies
Percy
Percy10mo ago
Project ID: 97e88910-4a3c-48f5-a692-b9f2291f4b3e
schmell_mafeet
schmell_mafeet10mo ago
97e88910-4a3c-48f5-a692-b9f2291f4b3e
Brody
Brody10mo ago
wouldn't that be done as a prisma setting? look into the prisma docs
schmell_mafeet
schmell_mafeet10mo ago
No its done by adding ?connection_limit=5&pool_timeout=2 to the connection string
Brody
Brody10mo ago
okay then do that lol
schmell_mafeet
schmell_mafeet10mo ago
i can't edit the DATABASE_URL environment variable
Brody
Brody10mo ago
why cant you?
schmell_mafeet
schmell_mafeet10mo ago
i don't know. there is no edit button let me look at it again
Brody
Brody10mo ago
Brody
Brody10mo ago
DATABASE_URL=${{Postgres.DATABASE_URL}}?connection_limit=5&pool_timeout=2
schmell_mafeet
schmell_mafeet10mo ago
ohh. ok. its not in the postgres page. Awsome i will try it out