How do I setup my Supabase DB connection string to work with Prisma Accelerate | Prisma | Page 1

primal atlas May 15, 2024, 1:30 AM

#

Supabase currently provide 2 connection modes; Session and Transaction (Pooler). From all indications, using the transaction mode (with pgbouncer=true) as the connection string in my Prisma Accelerate dashboard seems to be the intended approach. However, I get
Error occurred during query execution: ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "26000", message: "prepared statement \"s2\" does not exist", severity: "ERROR", detail: None, column: None, hint: None }), transient: false })

On the other hand, if I set the session mode connection url on my Accelerate dashboard, I get Client Max Connections Reached

Really need some pointers here for anyone who has been able to get this to work. Thanks.

spare starBOT May 15, 2024, 1:30 AM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

blissful jungle May 23, 2024, 10:42 AM

#

Hey @primal atlas

Can you please try using the non-pooled connection string, the one with port 5432 and check if you get the same error?

livid hornet Jun 4, 2024, 1:53 PM

#

Hi @blissful jungle
I was having the same problem, but when I used the direct_url, I did not get the error until now,
Thank you

livid hornet Jun 4, 2024, 6:36 PM

#

@blissful jungle
it started giving this error again??

#How do I setup my Supabase DB connection string to work with Prisma Accelerate